SELECT * FROM store_main sm LEFT JOIN customers c ON sm.customer_id=c.customers_id LEFT JOIN customer_to_marketplace c2m ON c.customers_id = c2m.customer_id LEFT JOIN products p ON p.store_id=sm.store_id LEFT JOIN products_description pd ON p.products_id=pd.products_id WHERE p.products_status = 1 AND sm.store_status=1 AND c2m.marketplace=1 AND c2m.status=1 AND pd.language_id='1' AND sm.store_category!=4 AND p.store_id=40848 AND p.adults_only != 1 order by products_date_added desc http://www.mystore.com/index.php?ID=40848 en-us http://www.mystore.com/templates/mystore/images/logo_image.png http://www.mystore.com/