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 = '60' AND p.product_id IN (583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,609,610,611,612,613,614,615,616,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,3180,3181,3182,3185,3186,3187,3188,3189,3190,3191,3192,3494,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3599,3685,3688,3690,3692,3700,3704,3717,3764,3767,3773,3776,3777,3842,3845,3846,3847,3848,3850,3852,3854,3855,3856,3859,3860,3877,3880,3939,3942,4430,4431,4432,4433,4434,4435,4436,4437,4438,4439,4440,4441,4442,4443,4444,4445,4446,4447,4448,4449,4450,4451,4452,4453,4454,4457,4458,4459,4460,4461,4462,4463,4464,4465,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,5160,5161,5162,5163,5164,5167,5168,5169,5170,5171,5172,5173,5174,5175,6731,6732,6733,6734,6735,6736,6737,6738,6739,6740,6741,6742,6743,6744,6745,6746,6747,6748,6749,6750,6751,6752,6753,6754,6755,6756,6757,6758,6759,6760,6761,6762,6763,6764,6765,6766,6767,6768,6769,6770,6771,6772,6773,6774,6775,6776,6777,6778,6779,6780,6781,6782,6783,6784,6785,6786,6787,6788,6789,6790,6791,6792,6793,6794,6795,6796,6797,6798,6799,6800,6801,6802,6803,6804,6805,6806,6807,7851,7852,7853,7854,7855,7856,7857,7858,7859,7860,7861,7862,7863,7864,7865,7866,7867,7868,7869,7870,7871,7872,7873,7874,7875,7876,7877,7878,7879,7880,7881,7882,8554,8555,8556,8557,8558,8559,8560,8561,8562,8563,8564,8565,8566,8567,8568,8569,8570,8571,8572,8573,8574,8575,8576,8577,8578,8581,8582,8583,8584,8585,8586,8587,8588,8589,9263,9264,9265,9266,9267,9268,9269,9270,9271,9272,9273,9274,9275,9276,9277,9278,9279,9280,9281,9282,9283,9284,9285,9286,9287,9290,9291,9292,9293,9294,9295,9296,9297,9298,9677,9678,9679,9680,9681,9682,9683,9684,9685,9686,9687,9688,9689,9690,10270,10271,10272,10273,10274,10275,10276,10277,10278,10279,10280,10281,10282,10283,10284,10285,10286,10287,10288,10289,10290,10291,10292,10293,10294,10295,10296,10297,10298,10299,10300,10301,10302,10303,10304,11028,11029,11030,11031,11032,11033,11034,11035,11036,11037,11038,11039,11208,11209,11210,11211,11212,11213,11214,11215,11216,11217,11218,11219,11220,11221,11222,11223,11224,11225,11265,11266,11267,11268,11269,11270,11271,11272,11273,11274,11791,11792,11793,11794,11795,11796,11797,11798,11799,11800,11801,11802,11803,11804,11805,12474,12475,12476,12477,12478,12479,12480,12481,12482,12483,12484,12485,12486,12487,12488,12489,12490,12491,12492,12493,12494,12495,12496,12497,12498,12499,12500,12501,12502,12503,12504,12505,12506,12507,12508,12509,12510,12511,12512,12513,12514,12515,12955,12956,12963,12964,12971,12972,12979,12980,12987,12988,12995,12996,13031,13283,13632,13640,13659,13732,13755,13756,13771,13774,13824,13857,13900,13903,13905,13907,13938,13986,13987,13988,13989,13990,13991,13992,13993,13994,13995,13996,13997,14026,14027,14028,14029,14030,14031,14032,14033,14165,14166,14188,14189,14211,14212,14264,14297,14298,14356,14357,14358,14359,14423,14424,14425,14426,14514,14515,14516,14580,14581,14689,14690,14691,14692,14774,14775,14776,14839,14840,14958,14959,14960,14961,14992,14993,14994,15096,15107,15629,15630,15631,15632,15633,15634,15635,15636,15637,15638,15639,15640,15641,15642,15643,15644,15645,15646,15647,15648,15649,15650,15651,15652,15653,15654,15655,15656,16008,16243,16244,16245,16246,16247,16249,16250,16251,16253,16254,16255,16256,16257,16258,16259,16260,16261,16475,16500,17060,17061,17062,17063,17064,17065,17066,17067,17068,17069,17070,17071,17072,17073,17697,17698,17699,17700,17701,17702,17703,17704,17705,17706,17707,17708,17709,17710,17711,17712,17713,17714,17715,17716,17717,17718,17719,17720,17721,17722,17723,17724,17725,17726,17727,17728,17729,17730,17731,17732,17733,17734,17735,17736,17737,17738,17739,24153,24154,24155,24156,24157,24158,24159,24160,24161,24162,24163,24164,24165,24712,24713,24714,24715,24716,24717,24718,24719,24720,24721,24722,24723,24724,25167,25171,25177,25178,25184,25185,25187,25191,25193,25196,25354,25357,25367,25368,25369,25370,25371,25373,25374,25375,25376,25377,25378,25379,25950,25951,25952,25953,25954,25955,25956,25957,25958,25959,25960,25961,25962,25963,25964,25965,25966,25967,25968,25969,25970,25971,25972,25973,25974,25975,25976,25977,25978,25979,25980,25981,26564,26565,26566,26567,26568,26569,26570,26571,26572,26573,26574,26575,26576,26790,26939,26940,26941,26942,27024,27025,27026,27185,27186,27187,27188,27189,27190,27191,27192,27193,27194,27195,27298,27299,27359,27360,27363,27366,27369,27370,27371,27452,27453,27457,27458,27466,27478,27481,27620,12807,12822,12853,13055,13079,13080,13081,13095,13123,13125,13150,13236,13274,13275,13276,13277,13278,13282,13283,13287,13288,13289,13290,13291,13292,13293,13296,13298,13299,13300,13301,13302,13303,13304,13306,13307,13308,13309,13311,13320,13323,13324,13325,13359,13391,13394,13434,13513,13543,13551,13557,13580,14239,14240,13055,13079,13080,13081,13095,13100,13123,13125,13236,13274,13275,13276,13277,13278,13282,13287,13289,13290,13291,13292,13293,13296,13298,13299,13300,13301,13302,13303,13304,13306,13307,13308,13309,13311,13320,13323,13324,13325,13359,13391,13394,13434,13513,13543,13551,13557,13580,14239,14240) 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
Peugeot užvalkalai automobiliams internetu pigiau | autorolis.lt