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
SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(1531,1533,613,616,614,435,880,445,682,1027,178), 1, 0)) as flag FROM zen_products_attributes p2a JOIN zen_products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN zen_products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 WHERE p2a.products_id IN (682,178,1027,445,880,435,614,616,613,1533,1531) AND p2a.options_id IN (2,1,3,8) AND p2a.options_id NOT IN (4,5,6,7) GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_sort_order, pov.products_options_values_sort_order
.jpg "Anvelope industriale 440/80-24 168 A8 MICHELIN POWER CL TL")
