TestTSELECT p.product_id, p.price AS sprice, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, pd.url FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '233' AND p.product_id IN (20281,21166,21216,21389,21397,21421,21425,21428,21432,21601,21622,21910,21911,21920,21921,21922,21923,21925,21926,21930,22288,22320,22330,28551,28552,28608,28680,28686,28687,28688,28689,28690,28691,28705,28731,28816,28862,28885,29219,29220,29401,29495,29496,29614,29631,29644,29647,29667,29676,29715,29716,29717,29719,29722,29723,29724,29725,29726,29727,29736,30387,30399,30400,30401,30402,30403,30404,30405,30406,30408,30411,30414,30416,30425,30430,30434,31064,31065,31100,31104,31113,31114,31120,31121,31123,31132,31138,31139,31140,31143,31410,31417,31433,31435,31440,31441,31447,31450,31457,31459,31584,31585,31586,31587,31588,31589,31605,31622,31713,31715,31728,31737,31778,31803,31805,31817,31857,31975,31978,31980,31984,31985,31986,31988,31990,31992,31994,31995) AND p.quantity > 0 GROUP BY p.product_id ORDER BY CASE WHEN p.quantity <= 0 THEN 1 ELSE 0 END, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,10000
Naujos vasarinės padangos internetu pigiau | Autorolis.lt