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 = '232' AND p.product_id IN (20214,20217,20219,20224,20227,20254,20268,20275,20276,20280,20281,20289,20306,20308,20311,20317,20323,20329,20331,20344,20362,20363,20374,20375,20376,20377,20378,20379,20380,20381,20382,20383,20384,20385,20386,20392,20396,20399,20405,20407,20408,20409,20410,20411,20413,20414,20415,20416,20417,20418,20419,20420,20421,20422,20423,20424,20425,20427,20428,20429,20430,20432,20433,20434,20435,20436,20437,20438,20439,20440,20441,20442,20443,20444,20445,20446,20447,20448,20449,20450,20451,20452,20453,20455,20456,20457,20458,20459,20479,20544,20569,20570,20863,20865,20866,20867,20868,20869,20870,20871,20872,20907,20915,21127,21134,21135,21149,21166,21173,21174,21175,21188,21189,21211,21216,21224,21232,21244,21251,21259,21270,21311,21365,21366,21368,21389,21391,21397,21400,21403,21406,21410,21412,21415,21416,21421,21422,21425,21428,21432,21433,21435,21526,21527,21528,21601,21606,21622,21623,21693,21910,21911,21912,21913,21914,21915,21916,21917,21918,21919,21920,21921,21922,21923,21924,21925,21926,21927,21928,21929,21930,21957,22026,22063,22066,22077,22190,22191,22198,22200,22205,22288,22320,22322,22323,22330,22331,22332,22335,22339,22341,22345,22348,22354,22358,22364,22370,22373,22379,22383,22384,22390,22393,22396,22397,22398,22959,22964,22980,22983,23110,23111,23134,27593,27604,28311,28551,28552,28580,28586,28589,28596,28598,28603,28605,28608,28620,28621,28624,28625,28627,28630,28631,28632,28635,28636,28638,28651,28676,28678,28680,28681,28685,28686,28687,28688,28689,28690,28691,28694,28695,28696,28698,28703,28705,28706,28709,28710,28711,28713,28714,28716,28717,28731,28761,28765,28779,28783,28816,28851,28854,28859,28862,28873,28876,28884,28885,28895,28906,28919,29219,29220,29385,29401,29406,29428,29477,29485,29488,29489,29491,29492,29495,29496,29516,29523,29525,29597,29599,29614,29616,29631,29634,29644,29647,29667,29676,29710,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29729,29736,29747,29821,29851,29870,29875,29876,29877,30377,30378,30379,30380,30381,30382,30383,30384,30385,30386,30387,30388,30389,30390,30391,30392,30393,30394,30395,30396,30397,30398,30399,30400,30401,30402,30403,30404,30405,30406,30407,30408,30409,30411,30412,30414,30415,30416,30417,30418,30419,30420,30421,30422,30424,30425,30426,30427,30428,30429,30430,30431,30432,30433,30434,30435,30436,30437,30438,30439,30440,30441,30442,30443,30444,30445,30446,30447,30448,30449,30450,30655,30657,30673,30674,30683,30684,30687,30691,30870,30871,30877,30878,30886,30892,30893,30910,30951,31008,31010,31014,31064,31065,31099,31100,31102,31103,31104,31105,31106,31107,31108,31109,31113,31114,31115,31116,31118,31120,31121,31122,31123,31125,31126,31127,31129,31130,31131,31132,31133,31135,31136,31137,31138,31139,31140,31141,31142,31143,31144,31145,31146,31147,31148,31151,31349,31367,31394,31407,31410,31412,31417,31420,31421,31429,31432,31433,31435,31438,31440,31441,31442,31447,31448,31450,31452,31453,31455,31456,31457,31459,31584,31585,31586,31587,31588,31589,31590,31591,31592,31593,31594,31595,31596,31597,31598,31600,31605,31610,31611,31622,31625,31634,31635,31642,31653,31657,31667,31681,31713,31714,31715,31725,31728,31731,31733,31737,31739,31745,31771,31774,31776,31778,31786,31794,31803,31805,31806,31817,31818,31823,31833,31846,31848,31854,31857,31859,31860,31888,31975,31978,31979,31980,31982,31983,31984,31985,31986,31988,31990,31992,31994,31995,31996,32014,32019) 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 padangos internetu pigiau | Autorolis.lt