Magento Cara melihat konsumen yang membeli barang tertentu.
SQL Magento Cara melihat konsumen yang membeli barang tertentu
SELECT email FROM customer_entity WHERE entity_id IN(SELECT DISTINCT o.customer_id FROM sales_flat_order_item i INNER JOIN sales_flat_order o ON o.entity_id = i.order_id WHERE o.customer_id IS NOT NULL AND i.sku LIKE 'SKUNYA%');