string(720) " SELECT p.`id_manufacturer`, COUNT(DISTINCT p.`id_product`) as nb_products FROM `ps_product` p USE INDEX (product_manufacturer) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_manufacturer` as m ON (m.`id_manufacturer`= p.`id_manufacturer`) WHERE p.`id_manufacturer` != 0 AND product_shop.`visibility` NOT IN ("none") AND product_shop.`active` = 1 AND EXISTS ( SELECT 1 FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` = 1 ) GROUP BY p.`id_manufacturer`" Произволители | стр.2

Бренды Всего брендов: 38

на странице
Показано 21 - 38 из 38 товаров
Показано 21 - 38 из 38 товаров