SELECT b.bid_id,b.seller_id,u.user_email,p.guid,b.buyer_id,b.product_id,p.post_title FROM wordpress_bids b left join wordpress_postmeta pm on b.product_id=pm.post_id left join wordpress_users u on u.id=b.buyer_id left join wordpress_posts p on p.id=b.product_id where pm.meta_key="meta_product_type" and pm.meta_value="auction" and pm.post_id in (SELECT post_id from wordpress_postmeta pm1 where pm1.meta_key="meta_end_time" and TIMESTAMPDIFF(MINUTE, DATE_ADD(NOW(), INTERVAL 3 HOUR), pm1.meta_value)=360)Array
(
)