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 = '235' AND p.product_id IN (16655,19485,19497,19498,19500,19502,19503,19505,19521,19541,19548,19551,20266,20836,20845,20846,20847,20848,20849,20880,20896,20909,20913,20945,21126,21143,21217,21371,21372,21374,21378,21379,21380,21381,21382,21384,21386,21390,21392,21418,21431,21441,21444,21484,21531,21533,21540,21541,21543,21544,21545,21546,21547,21548,21552,21553,21554,21555,21556,21557,21558,21559,21560,21561,21562,21568,21570,21663,21664,21717,22289,22291,22301,22313,22316,22317,22319,22326,22350,22351,22356,22374,22376,22388,22389,22402,22417,22418,22425,22429,22430,22592,22593,22608,23107,23112,23123,23125,23126,23263,23279,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,27760,27761,27762,27763,27764,27765,27766,27767,27768,27770,27771,27772,27773,28314,28536,28537,28543,28581,28585,28587,28604,28610,28684,28721,28742,28743,28749,28837,28861,28864,28865,28866,28867,28872,28877,28883,29145,29146,29218,29227,29447,29513,29518,29519,29522,29526,29527,29528,29529,29530,29531,29535,29537,29538,29539,29540,29543,29546,29547,29548,29549,29550,29551,29554,29555,29563,29696,29698,29702,29707,29865,29866,29867,29871,30080,30266,30268,30269,30410,30413,30423,30612,31076,31078,31080,31083,31086,31117,31119,31170,31175,31176,31195,31196,31208,31405,31411,31413,31415,31416,31418,31419,31422,31426,31431,31434,31439,31444,31446,31451,31458,31471,31526,31548,31604,31639,31649,31658,31669,31672,31686,31689,31695,31696,31699,31738,31751,31768,31787,31864,31865,31920,31921,31924,31927,31929,31960,31974,31976,31977,31981,31991,31997,31998) 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 universalios padangos internetu pigiau | Autorolis.lt