Get List of customers that purchase certain product

[ernie02]

Hi there,

 

I am trying to get the list of emails of all customers that purchase a certain product for newsletter purposes. I am sure this is pretty common and I am looking for an add-on for this. I tried searching for this but cannot seem to use the correct keyword to do so. Can anyone point me to the right add-on? Thank you very much.

[♥geoffreywalton]

try

 

SELECT customers.customers_email_address

FROM (orders INNER JOIN orders_products ON orders.orders_id = orders_products.orders_id) LEFT JOIN customers ON orders.customers_id = customers.customers_id

WHERE (((orders_products.products_model)="ST1"))