SQL PRESTASHOP
customer atoo
	SELECT * FROM ps177_atoosync_gescom_key 	
product
	SELECT * FROM ps177_product WHERE reference = '0400106 1' 	
TEST 	
	SELECT * FROM ps177_product_attribute_shop WHERE id_product = 3144 	
test
	SELECT * FROM ps177_product_attribute WHERE reference = '0400106 5' 	
product_shop
	SELECT * FROM ps177_product_shop WHERE id_product = 2824 	
product
	SELECT * FROM ps177_product_attribute_shop WHERE id_product_attribute = 48321 	
Test commande
	SELECT * FROM ps177_custom_field_userdata WHERE id_order = 7102 	
Test atoo
	SELECT * FROM ps177_atoosync_gescom_key 	

Clients 
	SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps177_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN ('2')) AND (o.valid = 1)) as total_spent, (SELECT con.date_add FROM ps177_guest g LEFT JOIN ps177_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY con.date_add DESC LIMIT 1) as connect FROM ps177_customer c LEFT JOIN ps177_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = 1 LEFT JOIN ps177_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN ('2')) ORDER BY c.date_add DESC LIMIT 200 



 Export Mattea 	SELECT * FROM ( SELECT '2023' as 'year', SUM(o.`total_paid`) as 'ca', COUNT(o.`id_order`) as 'nb_order', SUM(o.`total_paid`)/COUNT(o.`id_order`) as 'panier_moyen' FROM `psml_orders` o WHERE o.`current_state` NOT IN (6,7,8) AND o.`date_add` >= "2023-01-01 00:00:00" AND o.`date_add` <= "2023-12-31 23:59:59" AND o.`id_shop` = 1 ) a UNION ( SELECT '2022' as 'year', SUM(o.`total_paid`) as 'ca', COUNT(o.`id_order`) as 'nb_order', SUM(o.`total_paid`)/COUNT(o.`id_order`) as 'panier_moyen' FROM `psml_orders` o WHERE o.`current_state` NOT IN (6,7,8) AND o.`date_add` >= "2022-01-01 00:00:00" AND o.`date_add` <= "2022-12-31 23:59:59" AND o.`id_shop` = 1 ) 

 Export produits "new" 	SELECT DISTINCT `name`, `reference`, `sym_new` FROM `psml_product` p LEFT JOIN `psml_product_lang` pl ON pl.id_product = p.id_product AND pl.id_lang = 1 WHERE `sym_new` = 1 



 CLOUD COMPTA

DELETE FROM ps_atoosync_customer_account;
DELETE FROM ps_atoosync_export_compta_key WHERE class = 'customer' AND name = 'atoosync_compta_account';




Lister les clients d'un groupe (Pro) pour obtenir leur code ERP 	SELECT cg.id_customer, cg.id_group, acc.account_number FROM ps8_customer_group cg INNER JOIN ps8_atoosync_customer_account acc ON cg.id_customer = acc.id_customer WHERE cg.id_group = 13;