RE: How to find all customers who bought a specific product

[kieranbold]

In response to this thread: https://www.prestashop.com/forums/topic/324997-solved-how-to-find-all-customers-who-bought-a-specific-product/

 

I'm trying to execute this on SQL Manager and I get:

 

The "id_customerINNER" attribute does not exist in the "ps_orders" table.

 

CODE:

 

SELECT C.email FROM ps_customer C
INNER JOIN ps_orders O on C.id_customer = O.id_customer
INNER JOIN ps_order_detail OD on O.id_order = OD.id_order
WHERE OD.product_id IN (3,45,47,94,102)

 

OR

 

SELECT C.email FROM ps_customer C 

INNER JOIN ps_orders O on C.id_customer = O.id_customer
INNER JOIN ps_order_detail OD on O.id_order = OD.id_order
WHERE OD.product_id =3

 

Even with changing the last line of each code statements.

 

How can I resolve this?

 

Thanks

Edited August 10, 2015 by kieranbold (see edit history)

[kieranbold]

Any update on how to solve this please?

 

Thank you

[madj]

Hi kieranbold,

 

I use this and it works. Problem of parenthesis !!

 

SELECT * FROM ps_customer c
INNER JOIN ps_orders o ON (c.id_customer=o.id_customer)
INNER JOIN ps_order_detail od ON(od.id_order=o.id_order)
WHERE od.product_id=100