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 (18030,18031,18034,18035,18036,18037,18040,18041,18043,18044,18047,18049,18050,18051,18055,18056,18057,18059,18060,18061,18062,18067,18071,18073,18075,18076,18077,18078,18080,18081,18082,18083,18084,18085,18088,18089,18090,18091,18092,18093,18095,18096,18097,18101,18102,18103,18104,18105,18106,18107,18108,18109,18110,18111,18114,18115,18118,18119,18121,18123,18125,18126,18128,18129,18134,18138,18139,18141,18142,18143,18144,18148,18149,18150,18151,18153,18155,18156,18157,18162,18164,18165,18168,18169,18170,18174,18175,18176,18177,18178,18183,18184,18186,18187,18188,18190,18214,18224,18227,18228,18229,18233,18234,18235,18236,18239,18240,18241,18242,18243,18245,18246,18248,18249,18250,18253,18254,18255,18256,18258,18261,18263,18264,18267,18268,18269,18270,18271,18272,18273,18274,18275,18276,18277,18281,18282,18283,18284,18285,18286,18287,18288,18289,18290,18291,18292,18293,18294,18295,18296,18297,18298,18299,18301,18302,18303,18304,18305,18306,18421,18511,18512,18514,18515,18516,18517,18520,18521,18522,18524,18526,18527,18532,18534,18538,18540,18543,18544,18546,18548,18555,18556,18557,18560,18561,18562,18564,18567,18705,18751,18752,18753,18760,18775,18776,18777,18785,18786,18787,18789,18792,18795,18797,18798,18803,18804,18806,18817,18819,18825,18829,18838,18839,18847,18852,18853,18855,18856,18858,18859,18860,18861,18864,18865,18875,18877,18879,19374,19382,19394,19405,19406,19428,19429,19430,19432,19433,19434,19437,19439,19440,19441,19442,19444,19445,19446,19450,19452,19453,19454,19457,19458,19460,19461,19462,19463,19464,19466,19467,19468,19469,19470,19471,19472,19473,19474,19475,19476,19477,19478,19479,19480,19481,19482,19483,19484,19486,19487,19489,19490,19491,19492,20212,20900,20924,20932,20938,21111,21140,21146,21150,21320,21403,21429,21437,21441,21444,21446,22127,22128,22244,23002,23138,23140,23141,23142,23144,23145,23146,23147,23148,23149,23150,23151,23152,23153,23154,23155,23156,23157,23158,23259,23279,23286,23288,23619,23643,23644,23645,23646,23647,23648,23649,23650,23651,23652,23653,23655,23656,23657,23658,23659,23739,25055,28296,28297,28299,28304,28305,28306,28581,28588,28623,28626,28889,28891,28896,28902,28915,28919,28928,28932,28939,28942,30451,30452,30453,30454,30455,30456,30457,30458,30459,30460,30461,30462,30463,30464,30516,30526,30527,30528,30537,30544,30548,30551,30561,30562,30563,30564,30565,30566,30567,30575,30576,30578,30579,30580,30581,30584,30585,30586,30588,30589,30590,30591,30592,30594,30597,30598,30599,30600,30601,30602,30604,30605,30606,30607,30608,30609,30610,30611,30614,30615,30616,30617,30618,30619,30620,30621,30622,30623,30624,30626,30627,30629,30631,30632,30633,30634,30635,30637,30638,30639,30835,30844,30850,31024,31042,31044,31048,31053,31328,31359,31377,31600,31967,31970,32006,32034,32036,32045) 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