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 = '82' AND p.product_id IN (709,710,711,712,713,715,716,717,718,719,720,1251,1252,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2132,2133,2134,2135,2136,2137,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,2930,3233,3234,3235,3236,3501,3631,3905,3907,4546,4547,4548,4549,4550,4551,4552,4553,4554,4555,4556,4557,4558,4559,4560,4561,4562,4563,4564,4565,4566,4569,4570,4571,4572,4573,4574,5256,5257,5258,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5269,5270,5271,5272,5273,5274,5275,5276,5279,5280,5281,5282,5283,5284,7124,7125,7126,7127,7128,7129,7130,7131,7132,7133,7134,7135,7136,7137,7138,7139,7140,7141,7142,7143,7144,7145,7146,7147,7148,7149,7150,7151,7152,7153,7154,7155,7156,7157,7158,7159,7160,7161,7162,7163,7164,7165,7166,7167,7168,7169,7170,7171,7172,7173,7174,7974,7975,7976,7977,7978,7979,7980,7981,7982,7983,7984,8670,8671,8672,8673,8674,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8685,8686,8687,8688,8689,8690,8693,8694,8695,8696,8697,8698,9379,9380,9381,9382,9383,9384,9385,9386,9387,9388,9389,9390,9391,9392,9393,9394,9395,9396,9397,9398,9399,9402,9403,9404,9405,9406,9407,9714,9715,9716,9717,10442,10443,10444,10445,10446,10447,10448,10449,10450,10451,10452,10453,11094,11095,11096,11097,11098,11099,11100,11101,11102,11103,11104,11105,11106,11107,11108,11109,11110,12639,12640,12641,12642,12643,12644,12645,12646,12647,12648,12649,12650,12651,12652,12653,12654,12655,12656,12657,13643,13698,13877,13926,14267,14268,14307,14308,14309,14310,14311,14372,14373,14444,14445,14446,14447,14529,14713,14714,14715,14850,14851,15738,15739,15740,15741,15742,15743,15744,15745,15746,15747,15748,15749,15750,16338,16339,16494,17118,17119,17120,17121,17122,17123,17124,17854,17855,17856,17857,17858,17859,17860,17861,24234,24235,24236,24237,24238,24239,24240,24241,24242,24243,24244,24245,24246,24247,24793,24794,24795,24796,24797,24798,24799,24800,24801,24802,24803,24804,24805,24806,25443,25444,25445,25446,25464,26072,26073,26074,26075,26076,26077,26078,26079,26080,26081,26082,26645,26646,26647,26648,26649,26650,26651,26652,26653,26654,26655,26656,26657,26658,27233,27234,27375,27376,27377,27407,13334,13349,13400,13404,13409,13486,13487,13513,13520,13334,13349,13400,13404,13409,13486,13487,13513,13520) 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
Suzuki valytuvai pagal automobilio modelį internetu pigiau | autorolis.lt