SELECT p.product_id, p.status, p.create_date, ep.start_date, ep.end_date, ei.item_id
FROM m2epro_listing_product
p
LEFT JOIN m2epro_ebay_listing_product
ep ON p.id = ep.listing_product_id
LEFT JOIN m2epro_ebay_item
ei ON ei.id = ep.ebay_item_id
WHERE (ep.end_date +36000) < NOW()
AND p.status = 2;
Posted by Alan Vo to Alan Vo's deck (2014-08-18 00:23)