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 = '234' AND p.product_id IN (23427,23432,23433,23697,23698,23699,23700,23701,25073) 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 = '234' AND p.product_id IN (16674,16675,16676,16677,16678,16679,16680,16681,16682,16683,16684,16685,16686,16687,16688,16689,16691,16692,16693,16694,16695,16696,16698,16699,16700,16701,16702,16703,16704,16705,16706,16707,16708,16709,16710,16711,16712,16713,16714,16715,16716,16717,16718,16719,16720,16721,16722,16723,16724,16725,16726,16727,16728,16729,16730,16731,16732,16733,16734,16735,16736,16737,16738,16739,16740,16741,16742,16743,16744,16745,16746,16747,16748,16750,16751,16752,16753,16755,16756,16757,16758,16759,16760,16761,16762,16763,16764,16765,16766,16767,16768,16769,16770,16771,16772,16773,16774,16775,16776,16777,16778,16779,16780,16781,16782,16783,16784,16785,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,20169,20170,20171,20172,20173,20174,20175,20176,20177,20178,20214,20219,20220,20221,20222,20223,20224,20225,20227,20228,20230,20231,20232,20233,20234,20235,20236,20237,20238,20239,20240,20241,20242,20243,20244,20245,20246,20247,20248,20249,20250,20251,20252,20253,20254,20255,20256,20257,20258,20259,20261,20262,20263,20264,20265,20266,20267,20269,20270,20271,20272,20273,20274,20275,20276,20277,20278,20279,20280,20281,20282,20283,20284,20285,20286,20287,20288,20289,20290,20291,20292,20293,20294,20295,20296,20297,20298,20299,20300,20301,20302,20303,20304,20305,20306,20307,20309,20310,20311,20312,20314,20315,20316,20318,20319,20320,20322,20323,20324,20325,20326,20327,20328,20329,20330,20331,20332,20333,20334,20335,20336,20337,20338,20339,20340,20343,20344,20345,20346,20347,20348,20349,20350,20351,20353,20354,20355,20356,20357,20358,20359,20360,20361,20364,20365,20366,20367,20368,20369,20370,20371,20372,20373,20374,20375,20378,20379,20380,20381,20382,20383,20384,20385,20386,20390,20397,20400,20401,20404,20406,20408,20410,20412,20413,20415,20418,20419,20420,20421,20422,20423,20424,20425,20427,20428,20429,20431,20432,20433,20434,20437,20439,20440,20441,20442,20443,20445,20446,20448,20451,20452,20454,20455,20456,20459,20460,20461,20462,20463,20464,20465,20466,20467,20469,20470,20471,20472,20473,20474,20475,20476,20477,20478,20480,20481,20482,20483,20484,20485,20487,20488,20489,20490,20491,20492,20493,20494,20495,20499,20500,20501,20502,20503,20504,20505,20508,20509,20510,20511,20512,20513,20514,20515,20516,20517,20518,20519,20520,20521,20522,20523,20524,20525,20526,20527,20528,20529,20530,20531,20532,20533,20534,20535,20536,20537,20538,20540,20541,20542,20543,20544,20545,20546,20547,20548,20549,20551,20552,20553,20554,20555,20556,20557,20558,20559,20561,20562,20563,20564,20565,20566,20567,20568,20571,20572,20573,20574,20575,20576,20577,20578,20579,20580,20581,20582,20583,20584,20585,20586,20587,20588,20589,20590,20591,20592,20593,20594,20596,20597,20600,20601,20603,20605,20606,20608,20609,20612,20613,20615,20617,20622,20626,20632,20635,20636,20637,20638,20640,20641,20644,20646,20647,20648,20649,20650,20651,20654,20655,20656,20659,20662,20673,20674,20675,20676,20677,20679,20680,20681,20682,20683,20684,20686,20687,20688,20689,20690,20691,20692,20693,20694,20695,20696,20697,20698,20699,20700,20701,20702,20703,20704,20705,20706,20707,20710,20712,20713,20714,20715,20716,20717,20718,20719,20720,20721,20722,20723,20724,20725,20726,20727,20728,20729,20730,20733,20734,20735,20736,20738,20739,20740,20741,20743,20744,20745,20746,20747,20748,20749,20751,20752,20753,20754,20755,20756,20757,20758,20759,20760,20761,20762,20763,20764,20765,20766,20767,20768,20769,20770,20771,20772,20773,20774,20775,20776,20777,20778,20779,20780,20781,20782,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20804,20805,20806,20807,20808,20809,20810,20811,20812,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20832,20833,20834,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20881,20882,20884,20887,20888,20889,20890,20891,20893,20894,20895,20896,20898,20901,20902,20903,20904,20908,20909,20910,20911,20912,20913,20914,20916,20917,20918,20939,20940,20941,20942,20943,20944,20945,20946,20947,20948,20949,20950,20951,20952,20953,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20976,20978,20979,20981,20982,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21051,21106,21108,21109,21110,21113,21114,21115,21116,21118,21119,21120,21125,21126,21130,21131,21132,21136,21139,21142,21144,21145,21147,21148,21151,21153,21155,21159,21160,21163,21172,21173,21174,21175,21176,21177,21178,21180,21182,21187,21189,21190,21191,21192,21194,21195,21196,21198,21199,21201,21202,21203,21204,21205,21206,21207,21208,21209,21210,21211,21212,21213,21214,21215,21217,21218,21219,21220,21221,21222,21223,21224,21225,21226,21227,21228,21229,21230,21231,21232,21233,21234,21235,21236,21237,21238,21239,21240,21241,21242,21243,21245,21246,21247,21248,21249,21250,21252,21253,21255,21256,21257,21258,21259,21260,21261,21262,21263,21264,21265,21266,21267,21268,21270,21271,21272,21273,21274,21276,21277,21278,21279,21280,21281,21282,21283,21284,21285,21286,21287,21288,21289,21290,21291,21292,21293,21294,21295,21296,21297,21298,21299,21300,21301,21302,21303,21304,21305,21306,21307,21308,21309,21310,21311,21312,21313,21314,21315,21317,21318,21323,21324,21325,21326,21327,21328,21329,21330,21331,21332,21333,21334,21335,21336,21337,21338,21339,21340,21341,21342,21343,21344,21345,21346,21347,21348,21354,21361,21368,21369,21370,21371,21372,21373,21374,21375,21376,21377,21378,21379,21380,21381,21382,21383,21384,21385,21386,21387,21388,21390,21391,21392,21393,21394,21395,21396,21398,21399,21401,21402,21404,21405,21407,21409,21411,21413,21414,21416,21418,21419,21420,21423,21424,21426,21427,21431,21434,21436,21455,21456,21457,21458,21459,21463,21464,21466,21488,21489,21490,21492,21493,21495,21496,21498,21500,21501,21504,21506,21507,21509,21510,21512,21513,21514,21515,21516,21517,21519,21520,21521,21522,21523,21524,21525,21526,21527,21528,21529,21530,21531,21532,21533,21534,21535,21536,21537,21538,21539,21540,21541,21542,21543,21544,21545,21546,21547,21548,21549,21550,21551,21552,21553,21554,21555,21556,21557,21558,21559,21560,21561,21562,21563,21564,21565,21566,21573,21574,21575,21576,21577,21578,21580,21581,21582,21583,21584,21585,21586,21587,21593,21594,21598,21599,21600,21601,21602,21603,21604,21605,21606,21607,21608,21609,21610,21611,21612,21613,21614,21615,21616,21617,21618,21619,21620,21621,21623,21624,21627,21628,21629,21630,21631,21632,21633,21634,21635,21636,21637,21638,21639,21640,21642,21643,21644,21645,21646,21647,21648,21649,21650,21651,21652,21653,21654,21655,21656,21657,21658,21659,21660,21661,21662,21667,21669,21670,21671,21672,21673,21674,21675,21676,21677,21678,21679,21680,21681,21682,21683,21684,21685,21686,21687,21688,21689,21690,21691,21692,21693,21694,21695,21696,21697,21698,21699,21700,21702,21703,21704,21705,21706,21707,21708,21710,21712,21713,21714,21891,21896,21897,21898,21899,21900,21901,21902,21903,21904,21905,21906,21907,21908,21909,21912,21913,21931,21932,21933,21934,21935,21936,21937,21938,21939,21940,21941,21942,21943,21944,21945,21946,21947,21948,21949,21950,21951,21952,21953,21954,21955,21956,21958,21959,21960,21961,21962,21963,21964,21965,21966,21967,21968,21969,21970,21971,21972,21973,21974,21975,21976,21977,21978,21979,21980,21981,21982,21983,21984,21985,21986,21987,21988,21989,21990,21991,21992,21993,21994,21995,21996,21997,21998,21999,22000,22001,22003,22004,22005,22006,22007,22008,22009,22010,22011,22012,22013,22014,22015,22016,22017,22018,22019,22020,22022,22023,22024,22025,22027,22028,22029,22030,22031,22032,22033,22034,22035,22037,22038,22039,22040,22041,22042,22043,22044,22045,22046,22047,22048,22049,22050,22051,22052,22053,22054,22055,22056,22057,22058,22059,22060,22061,22062,22064,22065,22067,22068,22069,22070,22071,22072,22073,22074,22075,22076,22078,22079,22080,22081,22082,22083,22084,22085,22086,22087,22089,22090,22093,22095,22096,22097,22098,22099,22103,22104,22105,22106,22110,22111,22112,22116,22120,22121,22122,22123,22125,22126,22131,22133,22136,22137,22138,22140,22141,22142,22144,22145,22146,22147,22151,22152,22153,22157,22158,22159,22163,22164,22165,22166,22167,22168,22169,22170,22171,22172,22179,22180,22181,22182,22183,22184,22185,22186,22188,22189,22191,22192,22193,22194,22195,22196,22197,22198,22199,22200,22201,22202,22203,22204,22206,22207,22208,22209,22210,22211,22212,22213,22214,22215,22216,22217,22218,22219,22220,22221,22222,22223,22224,22225,22226,22227,22228,22229,22230,22231,22232,22233,22234,22235,22236,22237,22239,22240,22242,22243,22245,22246,22247,22248,22249,22250,22251,22252,22253,22254,22255,22256,22257,22258,22259,22260,22261,22262,22263,22264,22265,22266,22267,22268,22269,22270,22271,22272,22273,22274,22275,22276,22277,22278,22279,22280,22281,22282,22283,22284,22285,22286,22287,22289,22290,22291,22292,22293,22294,22295,22296,22297,22298,22299,22300,22301,22302,22303,22304,22305,22306,22307,22308,22309,22310,22311,22312,22313,22314,22315,22316,22317,22318,22319,22321,22323,22324,22325,22326,22327,22328,22329,22330,22331,22333,22334,22336,22337,22338,22340,22342,22343,22344,22346,22347,22349,22350,22351,22352,22353,22354,22355,22357,22358,22359,22360,22361,22362,22363,22365,22366,22367,22368,22369,22371,22372,22374,22375,22376,22377,22378,22380,22381,22382,22385,22386,22387,22388,22389,22391,22392,22394,22395,22399,22400,22401,22402,22403,22404,22405,22406,22407,22408,22409,22410,22411,22412,22413,22414,22415,22416,22417,22418,22419,22420,22421,22422,22423,22424,22425,22426,22427,22428,22429,22430,22431,22432,22433,22434,22435,22436,22437,22438,22439,22440,22441,22442,22443,22444,22445,22446,22448,22449,22450,22451,22452,22453,22454,22455,22456,22457,22458,22459,22460,22461,22462,22463,22464,22465,22466,22467,22468,22469,22470,22471,22472,22473,22474,22475,22476,22477,22478,22479,22480,22481,22482,22483,22484,22559,22564,22567,22568,22577,22579,22594,22597,22611,22612,22613,22614,22616,22617,22619,22620,22621,22622,22623,22625,22627,22631,22633,22635,22637,22638,22639,22640,22641,22642,22643,22644,22645,22649,22651,22652,22658,22662,22668,22672,22673,22688,22689,22692,22693,22699,22700,22705,22708,22709,22710,22711,22712,22713,22715,22716,22720,22723,22724,22725,22727,22728,22889,22890,22891,22892,22893,22894,22895,22896,22897,22898,22899,22900,22901,22902,22903,22904,22905,22907,22908,22909,22910,22911,22912,22913,22914,22915,22916,22917,22918,22919,22920,22921,22922,22923,22924,22925,22926,22927,23091,23092,23093,23094,23095,23096,23097,23098,23099,23100,23101,23102,23103,23249,23250,23251,23252,23253,23254,23255,23256,23257,23258,23260,23261,23262,23263,23264,23265,23266,23267,23268,23269,23270,23271,23272,23273,23274,23275,23276,23277,23278,23285,23287,23289,23290,23291,23292,23293,23294,23295,23296,23297,23298,23352,23353,23354,23355,23356,23357,23358,23359,23360,23361,23362,23365,23366,23367,23368,23369,23370,23409,23427,23432,23433,23697,23698,23699,23700,23701,23715,23716,23717,23718,25073,27661,27662,27728,27729,27730,27731,27732,27733,27734,27735,27736,27737,27738,27739,27740,27741,27742,27743,27744,27745,27746,27747,27748,27749,27750,27751,27752,27753,27754,27755,27756,27757,27758,27759,27760,27761,27762,27763,27764,27765,27766,27767,27768,27769,27770,27771,27772,27773,27787,27788,27789,27790,27791,27794,27795,27796,27797,27798,27799,27800,27802,27806,27807,27808,27809,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820,27821,27822,27823,27824,27827,27829,27830,27831,27832,27833,27834,27957,27958,27966,27967,27968,27969,27970,27971,27972,27973,27974,27975,27976,27977,27978,27979,27980,27981,27982,27983,27984,27985,27986,27987,27988,27989,27990,27991,27992,27993,27995,27996,27997,27998,27999,28000,28002,28003,28004,28005,28006,28007,28008,28009,28010,28011,28012,28013,28014,28015,28016,28017,28309,28312,28313,28314,28315,28316,28317,28318,28319,28320,28321,28322,28325,28326,28327,28328,28329,28330,28332,28333,28334,28335,28336,28337,28340,28341,28342,28343,28344,28345,28346,28347,28348,28349,28350,28352,28354,28356,28357,28359,28360,28361,28362,28363,28364,28365,28366,28367,28520,28523,28526,28530,28531,28532,28533,28534,28535,28536,28537,28538,28539,28540,28541,28542,28543,28544,28545,28546,28547,28548,28549,28550,28551,28552,28554,28555,28556,28557,28558,28559,28564,28565,28566,28567,28569,28570,28576,28577,28579,28591,28595,28597,28604,28611,28613,28614,28627,28629,28630,28631,28632,28633,28636,28637,28638,28639,28643,28644,28645,28646,28647,28648,28649,28650,28651,28652,28653,28655,28656,28657,28658,28659,28660,28661,28662,28663,28664,28665,28666,28669,28670,28671,28673,28674,28675,28678,28679,28682,28684,28685,28688,28689,28690,28692,28695,28697,28699,28700,28701,28702,28705,28706,28707,28708,28709,28710,28712,28714,28715,28716,28717,28718,28719,28721,28722,28723,28725,28726,28727,28728,28729,28730,28731,28732,28734,28735,28736,28737,28738,28739,28741,28742,28743,28744,28745,28746,28747,28749,28751,28752,28753,28755,28756,28758,28759,28760,28761,28763,28764,28765,28766,28767,28768,28770,28771,28772,28773,28774,28775,28778,28780,28781,28782,28783,28784,28785,28786,28788,28789,28790,28791,28792,28793,28794,28795,28796,28797,28799,28801,28802,28803,28804,28806,28807,28808,28809,28810,28811,28812,28813,28814,28815,28817,28818,28819,28820,28821,28822,28823,28824,28825,28826,28827,28828,28829,28830,28831,28832,28833,28834,28835,28836,28837,28838,28839,28840,28841,28842,28843,28844,28845,28847,28850,28857,28861,28863,28864,28865,28866,28867,28868,28869,28870,28871,28872,28873,28874,28875,28876,28877,28878,28879,28880,28881,28882,28883,28884,28887,29064,29065,29066,29067,29068,29069,29070,29071,29072,29073,29074,29075,29076,29077,29078,29079,29080,29081,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29093,29094,29095,29096,29097,29098,29099,29100,29101,29102,29103,29104,29105,29106,29107,29108,29109,29110,29111,29112,29113,29114,29115,29116,29117,29118,29119,29120,29121,29122,29123,29124,29125,29126,29127,29128,29129,29130,29131,29132,29133,29134,29135,29136,29137,29138,29139,29140,29141,29142,29143,29144,29145,29146,29164,29165,29166,29167,29168,29169,29170,29171,29172,29207,29208,29209,29210,29211,29212,29213,29214,29215,29216,29217,29218,29219,29220,29221,29222,29223,29224,29225,29226,29227,29383,29386,29392,29393,29394,29396,29403,29404,29409,29427,29466,29470,29472,29474,29476,29478,29480,29483,29484,29486,29488,29489,29490,29492,29494,29497,29498,29499,29500,29501,29502,29508,29511,29512,29513,29514,29515,29517,29518,29519,29520,29521,29522,29524,29525,29526,29527,29528,29529,29530,29531,29532,29533,29534,29535,29536,29537,29538,29539,29540,29541,29542,29543,29544,29545,29546,29547,29548,29549,29550,29551,29552,29554,29558,29559,29565,29566,29567,29568,29569,29570,29572,29574,29575,29576,29577,29579,29588,29589,29590,29591,29592,29593,29594,29595,29596,29597,29600,29601,29603,29604,29605,29606,29607,29608,29611,29613,29615,29617,29618,29619,29620,29621,29624,29625,29626,29627,29628,29629,29630,29631,29632,29633,29634,29635,29636,29637,29638,29639,29640,29641,29642,29643,29644,29645,29646,29648,29649,29650,29651,29652,29654,29655,29656,29658,29659,29660,29661,29662,29663,29664,29665,29666,29668,29669,29670,29671,29672,29673,29674,29675,29677,29678,29679,29680,29681,29682,29683,29684,29685,29687,29688,29692,29693,29694,29695,29697,29699,29700,29701,29703,29704,29705,29711,29712,29713,29714,29719,29720,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29737,29738,29739,29740,29741,29742,29743,29744,29745,29746,29747,29748,29749,29750,29751,29752,29753,29754,29755,29756,29757,29758,29759,29761,29763,29764,29765,29766,29768,29769,29770,29771,29772,29773,29774,29775,29776,29824,29829,29830,29831,29833,29834,29835,29836,29837,29838,29839,29849,29852,29853,29856,29857,29858,29859,29860,29861,29862,29863,29864,29865,29867,29868,29869,29872,29873,29874,29879,29881,29882,29883,29885,29886,29887,29888,29889,29890,29891,29892,29893,29894,29895,29896,29897,29898,29899,29900,29901,29902,29903,29904,29905,29906,29909,29910,29911,29912,29913,29914,29915,29916,29917,29918,29919,29920,29921,29922,29923,29924,29925,29926,29927,29928,29929,29986,29987,29988,29989,29990,29991,29992,29993,29994,29995,29996,30270,30271,30272,30273,30274,30275,30276,30277,30278,30279,30280,30281,30282,30283,30284,30285,30286,30289,30290,30291,30296,30297,30298,30299,30300,30301,30302,30303,30304,30305,30306,30307,30308,30309,30310,30311,30312,30313,30314,30315,30316,30317,30318,30319,30320,30321,30322,30323,30324,30325,30326,30327,30328,30329,30330,30331,30332,30333,30334,30335,30336,30337,30352,30353,30354,30355,30356,30357,30358,30359,30360,30361,30362,30363,30364,30365,30366,30367,30368,30369,30370,30371,30372,30373,30374,30375,30376,30386,30388,30392,30393,30407,30412,30417,30421,30422,30429,30442,30446,30465,30466,30467,30468,30469,30470,30471,30472,30473,30475,30476,30477,30478,30479,30480,30481,30482,30483,30484,30485,30486,30487,30488,30489,30490,30491,30492,30493,30494,30495,30496,30497,30498,30499,30500,30501,30502,30503,30504,30505,30506,30507,30508,30509,30510,30511,30512,30641,30642,30643,30644,30645,30646,30648,30649,30650,30651,30652,30653,30654,30658,30659,30660,30661,30662,30663,30665,30666,30667,30668,30670,30671,30672,30676,30678,30679,30680,30681,30682,30683,30686,30689,30690,30692,30693,30694,30695,30696,30697,30699,30700,30702,30704,30705,30706,30707,30708,30709,30712,30714,30716,30717,30718,30719,30721,30722,30723,30724,30725,30727,30728,30730,30731,30732,30734,30735,30736,30737,30738,30742,30745,30746,30747,30748,30749,30750,30753,30754,30755,30756,30757,30758,30759,30760,30761,30762,30763,30765,30769,30770,30771,30772,30773,30774,30775,30776,30779,30780,30783,30785,30788,30789,30790,30791,30794,30797,30800,30801,30802,30804,30805,30806,30807,30808,30811,30812,30813,30814,30817,30820,30821,30823,30824,30825,30826,30829,30830,30834,30837,30838,30840,30843,30845,30849,30852,30853,30854,30855,30856,30857,30858,30860,30861,30862,30863,30864,30865,30866,30867,30868,30869,30872,30873,30874,30875,30876,30877,30878,30879,30880,30881,30884,30885,30887,30888,30889,30890,30891,30892,30893,30894,30895,30896,30897,30898,30899,30900,30901,30902,30904,30905,30906,30907,30908,30911,30912,30913,30914,30915,30916,30917,30918,30919,30920,30922,30923,30924,30926,30927,30928,30929,30930,30931,30932,30933,30934,30935,30937,30938,30939,30941,30942,30943,30944,30945,30946,30947,30948,30949,30952,30953,30954,30955,30956,30957,30958,30959,30960,30961,30962,30963,30964,30965,30966,30967,30968,30969,30970,30971,30972,30973,30974,30975,30976,30977,30978,30979,30980,30981,30982,30983,30984,30985,30986,30987,30988,30989,30990,30991,30992,30993,30994,30995,30996,30997,31000,31002,31013,31014,31022,31027,31028,31029,31031,31032,31036,31038,31039,31040,31041,31047,31050,31052,31055,31056,31058,31059,31060,31061,31062,31063,31064,31066,31067,31068,31069,31070,31071,31072,31073,31074,31075,31076,31077,31078,31079,31080,31081,31082,31083,31084,31085,31086,31087,31088,31089,31090,31091,31092,31093,31095,31096,31097,31098,31101,31110,31111,31112,31117,31118,31128,31132,31134,31135,31136,31145,31150,31151,31152,31153,31154,31155,31156,31157,31158,31159,31160,31161,31162,31163,31164,31165,31166,31167,31168,31169,31170,31171,31172,31173,31174,31175,31176,31177,31178,31179,31180,31181,31182,31183,31184,31185,31186,31187,31188,31189,31190,31191,31192,31193,31194,31195,31196,31197,31198,31199,31200,31201,31202,31203,31204,31205,31206,31207,31208,31209,31210,31211,31212,31213,31214,31215,31216,31217,31219,31220,31221,31222,31223,31224,31225,31226,31227,31229,31230,31231,31232,31233,31234,31235,31236,31237,31238,31239,31240,31241,31242,31243,31244,31245,31246,31247,31248,31249,31250,31251,31348,31351,31353,31370,31381,31384,31387,31388,31389,31390,31391,31393,31395,31396,31402,31405,31406,31409,31413,31414,31415,31418,31419,31422,31423,31424,31425,31427,31428,31430,31436,31437,31439,31443,31444,31445,31447,31449,31452,31456,31462,31463,31466,31471,31472,31475,31476,31478,31484,31489,31492,31493,31494,31504,31507,31509,31510,31513,31515,31516,31517,31518,31519,31521,31522,31523,31527,31528,31531,31532,31533,31534,31535,31538,31539,31544,31546,31547,31548,31550,31554,31556,31558,31559,31560,31561,31562,31563,31564,31565,31567,31568,31569,31571,31572,31573,31574,31575,31576,31577,31578,31579,31581,31582,31584,31585,31586,31587,31588,31589,31590,31591,31592,31593,31594,31595,31596,31597,31598,31603,31604,31606,31608,31613,31614,31615,31617,31618,31619,31621,31623,31626,31627,31628,31629,31630,31633,31637,31639,31640,31645,31646,31647,31648,31649,31654,31655,31656,31659,31660,31661,31663,31664,31665,31669,31673,31674,31675,31677,31683,31685,31687,31690,31691,31692,31694,31695,31696,31697,31698,31700,31701,31703,31704,31705,31706,31707,31708,31709,31710,31711,31712,31715,31716,31717,31718,31719,31721,31723,31724,31726,31727,31730,31731,31732,31734,31735,31738,31745,31748,31751,31752,31759,31763,31765,31766,31767,31769,31770,31772,31775,31777,31778,31780,31781,31782,31784,31785,31787,31790,31791,31792,31793,31795,31796,31797,31798,31799,31800,31802,31807,31808,31809,31810,31811,31812,31813,31814,31815,31816,31820,31821,31825,31827,31828,31830,31831,31832,31834,31835,31839,31840,31845,31849,31851,31852,31854,31855,31856,31858,31859,31860,31861,31863,31865,31866,31867,31869,31870,31872,31873,31874,31875,31876,31877,31878,31879,31880,31882,31883,31885,31886,31888,31889,31891,31893,31894,31895,31896,31897,31898,31899,31903,31904,31905,31906,31907,31909,31910,31911,31912,31913,31915,31916,31918,31919,31920,31921,31922,31923,31924,31925,31926,31927,31928,31929,31931,31932,31933,31934,31935,31936,31937,31938,31939,31940,31941,31942,31943,31944,31945,31946,31947,31948,31949,31950,31951,31952,31953,31954,31955,31956,31957,31958,31959,31960,31961,31962,31964,31965,31966,31969,31972,31975,31976,31977,31979,31983,31987,31989,31991,31993,31996,31997,31998,31999,32012,32017,32025,32035,32312,32313,32314,32315,32316,32317,32318,32319,32320,32321,32322,32323,32324,32325,32326,32327,32328,32329,32330,32331,32332,32333,32334,32335,32336,32337,32338,32339,32340,32341,32342,32343,32344,32346,32347,32348,32349,32350,32351,32352,32353,32354,32355,32356,32357,32358,32359,32360,32361,32362,32363,32364,32365,32366,32367,32368,32369,32370,32371,32372,32373,32374,32375,32376,32377,32378,32379,32380,32381,32382,32383,32384,32385,32386,32387,32388,32389,32390,32391,32392,32393,32394,32395,32396,32397,32398,32399,32400,32401,32402,32403,32404) 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 žieminės padangos internetu pigiau | Autorolis.lt