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 (18884,18889,18891,18914,18922,18925,18926,18927,18928,18931,18932,18933,18935,18936,18937,18938,18939,18941,18942,18945,18946,18947,18950,18954,18955,18957,18958,18959,18961,18962,18963,18965,18974,18982,18987,18988,18989,18993,18994,18999,19000,19006,19023,19024,19027,19028,19030,19031,19035,19036,19037,19038,19039,19043,19044,19045,19046,19049,19050,19051,19054,19057,19059,19060,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19175,19177,19178,19179,19180,19181,19182,21580,21593,21598,21604,21607,21608,21611,21612,21616,21617,21620,21628,21636,21637,21644,21645,21646,21648,21649,21653,21654,21655,21658,21659,21662,21668,21673,21677,21678,21680,21682,21684,21685,21687,21688,21692,21695,21696,21697,21698,21702,21703,21710,21711,21715,21716,19032,21599,21613,21605,21701,29228,29229,29232,29237,29238,29239,29240,29241,29242,29243,29244,29245,29246,29247,29248,29249,29250,29251,29340,29341,29361,29362,29363,29364,29365,29366,29367,29368,29369,29427,29448,29449,29450,29451,29452,29453,29454,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29567,29578,29594,29637,29638,29639,29640,29641,29642,29643,29645,29646,29648,29649,29650,29651,29652,29654,29655,29656,29658,29659,29660,29661,29662,29663,29664,29665,29666,29668,29669,29684,29700,29703,29705,29744,29745,29746,29748,29749,29750,29751,29752,29753,29754,29755,29756,29757,29758,29760,29762) 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,10000TestTSELECT 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 (16602,16603,16604,16774,16776,16777,16778,16779,16781,16782,16783,16784,16785,16786,16787,16788,16789,16790,16791,16792,16793,16794,16795,16796,16797,16798,16800,16801,16802,16803,16804,16805,16806,16807,16808,16809,16810,16811,16812,16813,16814,16815,16816,16817,16818,16819,16820,16821,16822,16823,16824,16825,16826,16827,16828,16829,16830,18036,18039,18040,18042,18044,18048,18051,18054,18055,18057,18058,18060,18063,18065,18066,18067,18069,18070,18071,18072,18115,18117,18118,18124,18137,18155,18156,18158,18160,18161,18164,18166,18167,18168,18169,18170,18171,18172,18173,18174,18175,18176,18177,18178,18179,18180,18182,18183,18184,18224,18227,18230,18234,18235,18236,18237,18240,18242,18243,18245,18248,18250,18252,18253,18257,18258,18259,18260,18261,18267,18268,18270,18285,18286,18288,18290,18292,18294,18298,18300,18302,18306,18403,18404,18405,18406,18407,18408,18409,18410,18411,18412,18413,18414,18415,18416,18417,18418,18419,18420,18421,18422,18423,18424,18425,18426,18427,18428,18558,18559,18560,18561,18562,18563,18567,18568,18626,18628,18629,18630,18631,18632,18633,18634,18638,18668,18669,18670,18671,18672,18673,18674,18675,18676,18677,18678,18679,18743,18746,18756,18772,18784,18786,18787,18794,18796,18799,18800,18802,18803,18807,18846,18847,18851,18871,18874,18879,18884,18889,18891,18914,18922,18925,18926,18927,18928,18931,18932,18933,18935,18936,18937,18938,18939,18941,18942,18945,18946,18947,18950,18954,18955,18957,18958,18959,18961,18962,18963,18965,18974,18982,18987,18988,18989,18993,18994,18999,19000,19006,19023,19024,19027,19028,19030,19031,19032,19035,19036,19037,19038,19039,19043,19044,19045,19046,19049,19050,19051,19054,19057,19059,19060,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19175,19177,19178,19179,19180,19181,19182,19189,19190,19191,19192,19194,19195,19196,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19216,19219,19223,19226,19227,19270,19390,19452,19474,19492,19627,19631,19652,19753,19759,19764,19765,19767,19768,19769,19778,19786,19790,19792,19809,19825,19840,19841,19843,19925,19936,19937,19976,20002,20022,20025,20029,20032,20033,20036,20037,20038,20040,20043,20044,20045,20046,20047,20048,20049,20051,20088,20092,20105,20119,20120,20125,20126,20127,20134,20145,20215,20230,20233,20234,20236,20237,20239,20240,20241,20242,20251,20275,20287,20288,20295,20377,20386,20468,20476,20480,20483,20484,20486,20490,20491,20493,20494,20495,20496,20497,20498,20499,20500,20501,20502,20503,20504,20505,20508,20510,20511,20512,20513,20536,20576,20577,20578,20579,20582,20587,20588,20589,20595,20602,20609,20610,20611,20613,20616,20617,20618,20642,20673,20683,20685,20687,20688,20689,20690,20692,20698,20699,20702,20704,20705,20708,20709,20713,20714,20716,20717,20719,20720,20723,20724,20725,20728,20729,20731,20732,20740,20742,20749,20750,20752,20756,20765,20768,20770,20771,20780,20781,20782,20783,20785,20787,20788,20790,20791,20795,20796,20802,20804,20806,20808,20809,20810,20819,20820,20823,20825,20827,20828,20829,20830,20832,20833,20834,20975,20984,20995,21002,21004,21017,21020,21022,21038,21051,21068,21070,21075,21082,21089,21095,21097,21104,21123,21129,21170,21192,21214,21228,21235,21272,21273,21274,21316,21580,21593,21598,21599,21604,21605,21607,21608,21611,21612,21613,21616,21617,21620,21628,21636,21637,21644,21645,21646,21648,21649,21653,21654,21655,21658,21659,21662,21668,21673,21677,21678,21680,21682,21684,21685,21687,21688,21692,21695,21696,21697,21698,21701,21702,21703,21710,21711,21715,21716,21741,21742,21747,21766,21770,21774,21781,21783,21785,21788,21789,21794,21843,21845,21847,21848,21849,21850,21851,21852,21853,21856,21971,21996,21998,22004,22007,22011,22091,22092,22093,22096,22097,22099,22101,22102,22103,22104,22106,22107,22109,22112,22113,22114,22115,22118,22119,22120,22123,22124,22126,22127,22128,22129,22130,22131,22132,22133,22134,22135,22136,22165,22166,22172,22173,22178,22239,22243,22244,22248,22268,22482,22538,22540,22541,22543,22544,22549,22689,22769,22770,22774,22779,22781,22784,22785,22787,22788,22789,22790,22791,22792,22797,22810,22812,22828,22829,22834,22835,22840,22841,22846,22847,22889,22890,22891,22892,22893,22894,22895,22896,22897,22898,22899,22900,22901,22902,22903,22929,22932,22938,23021,23022,23023,23024,23025,23026,23027,23028,23029,23030,23031,23032,23033,23034,23035,23091,23092,23093,23094,23095,23096,23097,23098,23099,23100,23101,23102,23103,23136,23137,23179,23244,23289,23290,23293,23294,23296,23387,23388,23412,23501,23520,23521,23544,23599,23600,23601,23602,23603,23604,23650,23652,23653,23697,23698,23701,24964,24965,24966,24983,24984,25004,25005,25055,25073,27878,27880,27884,27908,27909,27910,27915,27983,27984,27985,27986,27987,27988,27989,27990,27991,27992,27993,27999,28002,28003,28004,28005,28006,28008,28009,28010,28012,28013,28051,28052,28053,28054,28055,28056,28057,28058,28059,28063,28102,28167,28338,28339,28341,28348,28349,28350,28351,28366,28367,28447,28448,28449,28450,28451,28452,28453,28454,28504,28505,28506,28507,28508,28509,28510,28511,28563,28572,28573,28574,28616,28617,28622,28670,28707,28718,28800,28802,28803,28804,28807,28808,28809,28887,28932,28934,28938,28941,28942,28967,28968,28969,28970,28971,28972,28974,28975,28976,29049,29050,29051,29052,29053,29054,29055,29056,29057,29058,29061,29062,29063,29074,29075,29076,29077,29078,29079,29080,29081,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29228,29229,29232,29237,29238,29239,29240,29241,29242,29243,29244,29245,29246,29247,29248,29249,29250,29251,29340,29341,29361,29362,29363,29364,29365,29366,29367,29368,29369,29427,29448,29449,29450,29451,29452,29453,29454,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29567,29578,29594,29637,29638,29639,29640,29641,29642,29643,29645,29646,29648,29649,29650,29651,29652,29654,29655,29656,29658,29659,29660,29661,29662,29663,29664,29665,29666,29668,29669,29684,29700,29703,29705,29744,29745,29746,29748,29749,29750,29751,29752,29753,29754,29755,29756,29757,29758,29760,29762,29859,29861,29886,29887,29889,29891,29892,29893,29894,29895,29897,29898,29899,29900,29901,29903,29917,29918,29919,29920,29922,29923,29924,29927,29929,29935,29936,29959,30045,30051,30052,30053,30054,30055,30213,30214,30215,30216,30217,30292,30293,30294,30295,30493,30571,30627,30629,30637,30640,30709,30711,30712,30713,30714,30715,30806,30807,30808,30809,30810,30811,30812,30813,30814,30815,30816,30817,30818,30819,30820,30821,30822,30823,30824,30825,30826,30827,30828,30829,30830,30831,30832,30833,30834,30835,30836,30837,30838,30839,30840,30841,30842,30843,30844,30845,30846,30847,30848,30849,30850,30851,30852,30853,30854,30855,30856,30857,30858,30859,30860,30940,30950,31017,31038,31043,31044,31045,31046,31047,31048,31049,31050,31051,31054,31055,31057,31059,31247,31250,31260,31313,31319,31491,31492,31493,31494,31495,31496,31497,31498,31499,31500,31501,31502,31503,31506,31507,31513,31514,31516,31517,31518,31519,31520,31531,31532,31533,31534,31537,31540,31542,31543,31544,31547,31551,31555,31556,31559,31560,31567,31678,31780,31807,31823,31825,31837,31838,31848,31850,31851,31861,31872,31873,31875,31885,31890,31891,31892,31894,31896,31897,31914,31915,31916,31966,31972,32003,32042,32046,32069,32070,32350,32351,32355,32401,32405,32406,32407,32408,32409,32410) 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