Cette requete permet de connaitre le nombre de produits vendus par client pour un Fabriquant / Marque sur Prestashop

nb_product_customer_order_by_manufacturer.sql

SELECT SUM(OD.product_quantity) AS 'OD.product_quantity',
 	   OD.product_name,
 	   C.firstname,
 	   C.lastname,
 	   C.email
  FROM ps_order_detail OD
	INNER JOIN ps_product P ON P.id_product = OD.product_id
	LEFT OUTER JOIN ps_orders O ON O.id_order = OD.id_order
	LEFT OUTER JOIN ps_customer C ON C.id_customer = O.id_customer
WHERE P.id_manufacturer = 216
GROUP BY OD.product_name,  	   
         C.firstname,
 	     C.lastname,
 	     C.email