SELECT p.products_id, p.products_price_sorter, p.master_categories_id, p.manufacturers_id FROM zen_products p LEFT JOIN zen_specials s on p.products_id = s.products_id LEFT JOIN zen_products_description pd on p.products_id = pd.products_id LEFT JOIN zen_manufacturers m on p.manufacturers_id = m.manufacturers_id LEFT JOIN zen_products_to_categories p2c on p.products_id = p2c.products_id WHERE p.products_status = '1' AND s.status = 1 AND pd.language_id = 2 GROUP BY p.products_id ORDER BY s.specials_date_added DESC