SELECT c.cust_email FROM Customers c, (SELECT a.prod_id,a.order_num,b.cust_id FROM OrderItems a INNER JOIN Orders b ON a.order_num=b.order_num WHERE a.prod_id= 'BR01') d WHERE c.cust_id=d.cust_id;