SELECT orders.id AS order_id , orders.order_email , orders.product_id AS prd_id , orders.transaction_id , orders.transaction_date , orders.transaction_time , orders.quantity , customer_details.address_one , customer_details.address_two , customer_details.city , customer_details.zip , customer_details.country , customer_details.first_name , customer_details.last_name FROM orders JOIN customer_details ON orders.customer_id=customer_details.id WHERE(orders.transaction_date = CURDATE() - INTERVAL 1 DAY) AND (orders.product_id IN('3757', '3884')) ORDER By orders.customer_id DESC

Array
(
)