SELECT COUNT(DISTINCT p.product_id) as total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) WHERE 1=1 AND p.status = '1' AND p.quantity > 0 AND cp.path_id = '37020400' ORDER BY p.quantity DESC, (p.price>0) DESC, p.price ASC
Профессиональные кофемашины Black+Decker купить в Ростове-на-Дону, Краснодаре | TEPLOTEK-UG.RU
