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 (16623,16628,16629,16630,16631,16632,16633,16635,16636,16637,16638,16639,16640,16641,16642,16644,16646,16647,16648,16649,16661,16671,18680,18706,18767,18768,19291,19329,19330,19331,19332,19335,19347,19413,19516,19683,19685,19686,19690,19691,19692,19697,19699,19701,19703,19704,19705,19706,19717,19770,19774,19799,19800,19802,19805,19811,19827,19842,19873,20246,20919,20925,20938,21108,21112,21115,21147,21195,21439,21475,21564,21878,21884,21885,22560,22566,22623,22631,22633,23167,23185,23461,23462,23463,23464,23492,23533,23620,24899,24909,24910,24911,25020,25021,28546,28548,28549,28555,28560,28652,29120,29121,29122,29123,29124,29126,29147,29149,29151,29152,29207,29208,29209,29210,29213,29429,29999,30152,30153,30154,30155,30156,30157,30158,30159,30160,30161,30162,30290,30291,30542,31659,31691,31746,31801,31917,32197,32198,32200) 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