Solution:
SELECT DISTINCT o.customer_email, o.customer_firstname, o.customer_lastname, o.store_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 = 'B/BVP700'
Posted by Alan Vo to Alan Vo's deck (2014-04-23 23:18)