SELECT p.product_id FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = 1 AND p.status = 1 AND p2c.category_id = '134' AND p.shop_id = 20012 AND p.active = 1 AND p.product_id <> '32072' GROUP BY p.product_id ORDER BY p.sort_order_list DESC, RAND() ASC, LCASE(pd.name) LIMIT 0,4
0.514038
Заказывай через мобильное приложение и получай баллы за каждый заказ!