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 (23435,27575,27579,27580,27581,27582,27584,27585,27586,27587,27588,27589,27590,27591,27592,27594,27595,27596,27597,27598,27599,27600,27601,27602,27603,27605,27606,27607,27610,27611,27612,27613,27614,27615,27617,27674,27679,27688,27729,27730,27732,27733,27734,27735,27738,27739,27740,27741,27742,27743,27744,27745,27746,27747,27748,27749,27750,27751,27752,27753,27754,27755,27756,27757,27758,27759,27760,27761,27762,27763,27764,27765,27766,27767,27768,27769,27770,27771,27772,27773,27791,27792,27793,27796,27821,27823,27825,27827,27830,27831,27832,27833,27834,27927,27934,27941,27943,27954,27955,27956,27964,27965,27988,28011,28016,28039,28054,28261,28976,29008,29009,29010,29012,29013,29014,29015,29016,29017,29019,29020,29022,29023,29025,29026,29027,29029,29030,29031,29032,29051,29052,29054,29058,29059,29083,29134,29144,29145,29146,29218,29224,29227,29962,29965,29966,29968,29969,29970,29972,29973,29974,29975,29976,29977,29978,29979,30008,30080,30186,30204,30207,30266,30268,30269,30325) 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