SELECT DISTINCT ps.*, i.`id_image`, pl.`name`, pl.`link_rewrite` FROM `pm_product_shop` ps LEFT JOIN `pm_product_lang` `pl` ON (`pl`.id_product = ps.id_product) LEFT JOIN pm_image_shop i ON (i.id_product = ps.id_product)
LEFT JOIN `pm_category_product` cp ON (cp.`id_category` = ps.id_category_default
AND cp.id_product = ps.id_product)
LEFT JOIN `pm_category_group` cg ON (cp.`id_category` = cg.`id_category`) WHERE ps.`id_product` IN (1301,1302,1303,1304,1305,1306) AND ps.id_shop = 1 AND ps.active = 1 AND ps.show_price = 1 AND ps.visibility != 'none' AND i.cover = 1 AND pl.id_lang = 1 AND pl.id_shop = 1 AND i.id_shop = 1 AND ps.available_for_order = 1 AND cg.`id_group` =1 ORDER BY ps.id_product
SELECT DISTINCT ps.*, i.`id_image`, pl.`name`, pl.`link_rewrite` FROM `pm_product_shop` ps LEFT JOIN `pm_product_lang` `pl` ON (`pl`.id_product = ps.id_product) LEFT JOIN pm_image_shop i ON (i.id_product = ps.id_product)
LEFT JOIN `pm_category_product` cp ON (cp.`id_category` = ps.id_category_default
AND cp.id_product = ps.id_product)
LEFT JOIN `pm_category_group` cg ON (cp.`id_category` = cg.`id_category`) WHERE ps.`id_product` IN (10573,10575,10576,13110) AND ps.id_shop = 1 AND ps.active = 1 AND ps.show_price = 1 AND ps.visibility != 'none' AND i.cover = 1 AND pl.id_lang = 1 AND pl.id_shop = 1 AND i.id_shop = 1 AND ps.available_for_order = 1 AND cg.`id_group` =1 ORDER BY ps.id_product
SELECT DISTINCT ps.*, i.`id_image`, pl.`name`, pl.`link_rewrite` FROM `pm_product_shop` ps LEFT JOIN `pm_product_lang` `pl` ON (`pl`.id_product = ps.id_product) LEFT JOIN pm_image_shop i ON (i.id_product = ps.id_product)
LEFT JOIN `pm_category_product` cp ON (cp.`id_category` = ps.id_category_default
AND cp.id_product = ps.id_product)
LEFT JOIN `pm_category_group` cg ON (cp.`id_category` = cg.`id_category`) WHERE ps.`id_product` IN (8181,8182,8183,8184,8185,8193,8194,8195,8196,8197,8198,8199,8200,8201,8202,168836) AND ps.id_shop = 1 AND ps.active = 1 AND ps.show_price = 1 AND ps.visibility != 'none' AND i.cover = 1 AND pl.id_lang = 1 AND pl.id_shop = 1 AND i.id_shop = 1 AND ps.available_for_order = 1 AND cg.`id_group` =1 ORDER BY ps.id_product
SELECT DISTINCT ps.*, i.`id_image`, pl.`name`, pl.`link_rewrite` FROM `pm_product_shop` ps LEFT JOIN `pm_product_lang` `pl` ON (`pl`.id_product = ps.id_product) LEFT JOIN pm_image_shop i ON (i.id_product = ps.id_product)
LEFT JOIN `pm_category_product` cp ON (cp.`id_category` = ps.id_category_default
AND cp.id_product = ps.id_product)
LEFT JOIN `pm_category_group` cg ON (cp.`id_category` = cg.`id_category`) WHERE ps.`id_product` IN (9824,9825,9826,9828,9829,9830,9831,9832,9833,9840,9841,9842,9854,9861,9862,9863,9864,9866,9869,9887,9893,9894,9929,9943,9957,9963,9964,9998,10011,10069,10089,10090,10284,13084) AND ps.id_shop = 1 AND ps.active = 1 AND ps.show_price = 1 AND ps.visibility != 'none' AND i.cover = 1 AND pl.id_lang = 1 AND pl.id_shop = 1 AND i.id_shop = 1 AND ps.available_for_order = 1 AND cg.`id_group` =1 ORDER BY ps.id_product
SELECT DISTINCT ps.*, i.`id_image`, pl.`name`, pl.`link_rewrite` FROM `pm_product_shop` ps LEFT JOIN `pm_product_lang` `pl` ON (`pl`.id_product = ps.id_product) LEFT JOIN pm_image_shop i ON (i.id_product = ps.id_product)
LEFT JOIN `pm_category_product` cp ON (cp.`id_category` = ps.id_category_default
AND cp.id_product = ps.id_product)
LEFT JOIN `pm_category_group` cg ON (cp.`id_category` = cg.`id_category`) WHERE ps.`id_product` IN (2543,2544,2545,2547,2548,2549,363668,363669,363670,363671,363672,363673,363674,363675,363676) AND ps.id_shop = 1 AND ps.active = 1 AND ps.show_price = 1 AND ps.visibility != 'none' AND i.cover = 1 AND pl.id_lang = 1 AND pl.id_shop = 1 AND i.id_shop = 1 AND ps.available_for_order = 1 AND cg.`id_group` =1 ORDER BY ps.id_product