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 = '218' AND p.product_id IN (832,833,834,835,837,838,839,840,841,842,844,845,846,847,848,849,850,851,852,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1328,1329,1330,1331,2287,2288,2289,2290,2291,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2304,2305,2306,2307,2308,2309,2311,2312,2313,2314,3008,3009,3010,3011,3012,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3268,3269,3270,3271,3272,3273,3274,3275,3276,3277,3278,3279,3280,3281,3325,3326,3327,3329,3330,3507,3664,3665,3666,3944,3945,4664,4665,4666,4667,4668,4669,4670,4671,4672,4673,5374,5375,5376,5377,5378,5379,5380,5381,5382,5383,7409,7410,7411,7412,7413,7414,7415,7416,7417,7418,7419,7420,7421,7422,7423,7424,7425,7426,7427,7428,7429,7430,7431,7432,7433,7434,7435,7436,7437,7438,7439,7440,7441,7442,7443,7444,7445,7446,7447,7448,7449,7450,7451,7452,7453,7454,7455,7456,7457,7458,7459,7460,8062,8063,8064,8065,8066,8068,8069,8070,8071,8072,8073,8074,8075,8076,8077,8078,8079,8080,8081,8082,8083,8084,8085,8788,8789,8790,8791,8792,8793,8794,8795,8796,8797,9497,9498,9499,9500,9501,9502,9503,9504,9505,9506,9754,9755,9756,9757,10575,10576,10577,10578,10579,10580,10581,10582,10583,10584,10585,10586,10587,10588,10589,10590,10591,10592,10593,10594,10595,10596,10597,11170,11171,11172,11173,11174,11175,11176,11177,11178,11927,11928,11929,11930,11931,11932,11933,11934,11935,11936,11937,11938,11939,11940,11941,12769,12770,12771,12772,12773,12774,12775,12776,12777,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12788,12789,12790,12791,12792,12793,13647,13648,13766,13817,13818,13836,13850,13854,13871,13881,13953,13954,14463,14536,14537,14538,14601,14602,14603,14604,14730,14731,14732,14733,14734,14786,14787,14788,14860,14861,14936,14937,15082,15083,15084,15085,15086,15087,15088,15089,15090,15139,15140,15141,15841,15842,15843,15844,15845,15846,15847,15848,15849,15850,15851,15852,15853,15854,15855,15856,15858,15859,15860,15861,15862,15863,15865,15866,15867,15868,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16403,16404,16409,16492,17189,17190,17191,17192,17193,17194,17195,17196,17197,17198,17199,17200,17201,17202,17988,17989,17990,17991,17992,17993,17994,17995,17996,17997,17998,17999,18000,18001,18002,18003,18004,18005,18006,18007,18008,18009,18010,18011,18012,18013,18014,18015,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,18027,18028,18029,24321,24322,24323,24324,24325,24326,24327,24328,24329,24330,24331,24332,24333,24880,24881,24882,24883,24884,24885,24886,24887,24888,24889,24890,24891,24892,25480,25481,25482,25483,25484,25485,25486,25487,25488,25489,25490,25491,25492,25493,25494,25495,25496,25497,25498,25499,26160,26161,26162,26163,26164,26165,26166,26167,26168,26169,26170,26171,26172,26173,26174,26175,26176,26177,26178,26179,26180,26181,26182,26732,26733,26734,26735,26736,26737,26738,26739,26740,26741,26742,26743,26744,27058,27059,27244,27245,27246,27247,27248,27411,27412,27413,27414,27415,27416,12809,12816,13055,13095,13099,13118,13139,13272,13292,13294,13350,13353,13355,13359,13381,13382,13383,13385,13386,13427,14241,13055,13095,13099,13118,13139,13272,13292,13294,13350,13353,13355,13359,13381,13382,13383,13385,13386,13427,14241) 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
Volvo polimeriniai eva kilimėliai internetu pigiau | autorolis.lt