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 (23392,23394,23396,23397,23398,23399,23401,23402,23403,23404,23405,23406,23407,23409,23410,23411,23412,23413,23414,23415,23416,23417,23418,23702,23703,23704,23705,23707,23709,23710,23711,23713,24922,24923,24924,24925,24926,24927,24928,24929,24930,24932,24934,24936,24937,24938,24939,24940,24941,24942,24945,24947,24949,24950,24951,24952,24953,24954,24955,24956,24957,24958,24959,24960,24961,24963,24964,24965,24966,24967,24968,24969,24970,24971,24972,24973,24974) 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 (16522,16525,16526,16527,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16554,16555,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579,16580,16581,16582,16583,16584,16585,16586,16588,16590,16591,16592,16593,16594,16595,16596,16597,16598,16599,16600,16601,16602,16603,16604,16605,16606,16607,16608,16609,16610,16611,16612,16613,16614,16615,16616,16617,16618,16619,16620,16621,16622,16623,16624,16625,16626,16628,16629,16630,16631,16632,16633,16635,16636,16637,16638,16639,16640,16641,16642,16644,16646,16647,16648,16649,16661,16671,16684,16769,18037,18040,18043,18060,18061,18063,18082,18091,18104,18107,18108,18117,18118,18120,18121,18131,18139,18142,18144,18149,18157,18192,18193,18194,18195,18197,18198,18200,18202,18203,18205,18208,18213,18227,18233,18234,18277,18278,18279,18282,18285,18287,18288,18295,18296,18299,18301,18302,18305,18307,18308,18309,18403,18404,18405,18406,18407,18410,18413,18414,18415,18417,18418,18424,18431,18440,18448,18468,18469,18486,18487,18510,18521,18526,18527,18528,18533,18568,18570,18571,18572,18573,18574,18577,18578,18579,18584,18586,18587,18589,18597,18598,18599,18605,18607,18608,18609,18615,18617,18622,18624,18625,18626,18627,18628,18629,18630,18631,18632,18633,18634,18635,18636,18637,18638,18639,18640,18641,18642,18643,18644,18645,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18658,18659,18660,18661,18662,18663,18664,18665,18666,18668,18669,18670,18671,18672,18673,18674,18675,18676,18677,18678,18679,18680,18681,18682,18686,18689,18706,18750,18751,18756,18757,18760,18763,18766,18767,18768,18776,18809,18810,18814,18815,18820,18821,18822,18830,18833,18839,18853,18861,18884,18887,18888,18889,18891,18893,18895,18896,18898,18899,18900,18901,18902,18903,18904,18905,18906,18907,18910,18914,18915,18916,18918,18921,18922,18923,18924,18925,18927,18928,18932,18933,18937,18939,18940,18943,18944,18945,18948,18949,18966,18967,18969,18971,18972,18973,18974,18977,18978,18980,18983,18987,18989,18990,18991,18992,18994,19000,19011,19041,19056,19066,19067,19069,19077,19078,19079,19080,19082,19083,19086,19088,19089,19093,19101,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19133,19134,19135,19136,19137,19138,19139,19140,19141,19142,19143,19144,19145,19148,19151,19155,19158,19169,19170,19171,19173,19178,19180,19183,19184,19185,19186,19188,19189,19190,19191,19192,19193,19194,19195,19196,19197,19198,19199,19200,19201,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19251,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19285,19286,19288,19289,19290,19291,19294,19295,19296,19297,19298,19299,19300,19304,19305,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19317,19319,19320,19321,19329,19330,19331,19332,19335,19347,19369,19370,19382,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19409,19410,19411,19412,19413,19415,19416,19425,19429,19430,19431,19432,19433,19434,19439,19446,19454,19457,19458,19460,19464,19473,19493,19516,19562,19563,19564,19565,19566,19567,19570,19571,19572,19573,19574,19575,19576,19577,19578,19579,19580,19581,19582,19583,19587,19589,19592,19593,19608,19612,19613,19614,19632,19633,19634,19635,19636,19637,19638,19639,19640,19643,19644,19645,19646,19647,19648,19650,19651,19652,19653,19654,19655,19657,19660,19661,19662,19669,19676,19677,19678,19680,19681,19682,19683,19684,19685,19686,19687,19688,19689,19690,19691,19692,19693,19694,19695,19696,19697,19698,19699,19700,19701,19702,19703,19704,19705,19706,19707,19708,19709,19710,19711,19712,19713,19714,19715,19717,19718,19719,19720,19721,19722,19723,19724,19725,19726,19727,19728,19729,19731,19732,19733,19734,19735,19736,19737,19738,19739,19740,19741,19742,19743,19744,19745,19746,19747,19748,19749,19751,19752,19753,19754,19755,19760,19761,19762,19763,19764,19765,19769,19770,19771,19772,19773,19774,19775,19776,19777,19778,19779,19780,19781,19784,19785,19786,19787,19789,19790,19792,19794,19795,19796,19797,19798,19799,19800,19801,19802,19803,19804,19805,19806,19807,19808,19809,19810,19811,19812,19813,19814,19815,19816,19817,19818,19819,19820,19821,19822,19823,19824,19825,19826,19827,19828,19829,19830,19831,19832,19833,19835,19837,19838,19840,19841,19842,19843,19852,19854,19864,19865,19867,19868,19869,19870,19871,19872,19873,19874,19875,19885,19887,19889,19890,19891,19892,19893,19894,19895,19896,19897,19899,19900,19902,19928,19929,19930,19931,19932,19933,19934,19935,19936,19937,19938,19939,19940,19941,19942,19943,19944,19945,19946,19947,19948,19949,19950,19951,19952,19953,19954,19955,19956,19957,19958,19959,19960,19961,19962,19963,19964,19965,19966,19967,19968,19969,19970,19971,19972,19973,19974,19975,19976,19977,19978,19979,19980,19981,19982,19983,19984,19985,19986,19987,19988,19989,19990,19991,19992,19993,19994,19995,19996,19997,19998,19999,20000,20001,20002,20003,20004,20005,20006,20007,20008,20009,20010,20011,20012,20013,20014,20052,20059,20062,20066,20085,20087,20088,20090,20091,20092,20096,20097,20146,20147,20148,20149,20150,20151,20152,20153,20154,20155,20156,20158,20159,20160,20161,20162,20163,20164,20165,20166,20167,20168,20179,20189,20190,20191,20192,20194,20195,20196,20197,20199,20200,20201,20202,20203,20204,20206,20209,20230,20231,20243,20244,20245,20246,20247,20248,20249,20250,20251,20252,20523,20587,20589,20591,20592,20595,20596,20599,20602,20604,20619,20620,20627,20630,20632,20633,20636,20637,20638,20642,20645,20647,20650,20655,20665,20666,20667,20668,20669,20670,20671,20672,20673,20674,20683,20685,20686,20688,20690,20693,20696,20697,20701,20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20713,20714,20715,20717,20718,20719,20720,20721,20722,20724,20725,20727,20728,20729,20730,20731,20732,20733,20734,20735,20736,20737,20738,20739,20741,20742,20743,20745,20746,20747,20750,20754,20757,20758,20759,20760,20761,20762,20763,20764,20765,20766,20767,20768,20769,20770,20771,20772,20773,20774,20775,20776,20778,20779,20780,20781,20782,20783,20784,20785,20786,20787,20788,20789,20790,20791,20792,20793,20801,20805,20806,20807,20809,20810,20817,20819,20820,20824,20825,20827,20828,20830,20919,20921,20923,20924,20925,20928,20932,20933,20934,20936,20937,20938,20951,20952,20956,20957,20958,20963,20984,20994,21060,21061,21062,21063,21064,21065,21081,21082,21084,21087,21093,21101,21106,21107,21108,21111,21112,21113,21114,21115,21116,21133,21139,21140,21147,21152,21155,21163,21165,21168,21170,21195,21229,21230,21234,21237,21238,21239,21242,21243,21246,21247,21250,21253,21258,21308,21310,21313,21314,21315,21316,21317,21318,21322,21350,21352,21355,21438,21439,21442,21446,21447,21451,21475,21476,21480,21481,21483,21486,21492,21493,21564,21565,21566,21572,21574,21576,21577,21598,21600,21631,21637,21645,21661,21720,21721,21722,21723,21724,21725,21726,21727,21728,21729,21730,21731,21732,21733,21734,21735,21736,21737,21738,21739,21740,21741,21742,21743,21744,21745,21746,21747,21748,21749,21750,21751,21752,21753,21754,21755,21756,21757,21758,21759,21760,21761,21762,21763,21764,21765,21766,21767,21768,21769,21770,21771,21772,21773,21774,21775,21776,21777,21778,21779,21780,21782,21783,21784,21785,21786,21787,21788,21789,21790,21791,21792,21793,21794,21795,21796,21797,21798,21799,21800,21801,21802,21803,21804,21805,21806,21807,21808,21809,21810,21811,21812,21813,21814,21815,21816,21817,21818,21819,21820,21821,21822,21823,21824,21825,21826,21827,21828,21829,21830,21831,21832,21833,21834,21835,21836,21837,21838,21839,21840,21841,21842,21843,21844,21845,21846,21847,21848,21849,21850,21851,21852,21853,21854,21855,21856,21857,21858,21859,21860,21861,21862,21863,21864,21865,21866,21867,21868,21869,21870,21871,21872,21873,21874,21876,21878,21880,21881,21883,21884,21885,21887,21891,21892,21893,21894,21895,21993,21994,21996,21998,21999,22000,22001,22002,22003,22005,22006,22009,22010,22012,22013,22014,22015,22030,22037,22039,22040,22041,22042,22043,22044,22045,22046,22051,22070,22088,22101,22102,22107,22108,22109,22113,22114,22115,22118,22119,22127,22128,22137,22138,22139,22141,22142,22143,22144,22145,22146,22147,22148,22149,22150,22151,22153,22154,22156,22160,22161,22162,22164,22165,22166,22172,22173,22174,22175,22176,22177,22178,22180,22181,22184,22234,22235,22238,22241,22246,22247,22286,22287,22293,22312,22444,22445,22446,22447,22449,22450,22452,22453,22454,22455,22460,22463,22470,22475,22484,22485,22486,22487,22488,22489,22496,22498,22500,22501,22502,22503,22505,22506,22512,22513,22517,22528,22530,22535,22560,22566,22570,22571,22574,22575,22583,22584,22598,22616,22623,22628,22631,22632,22633,22635,22636,22642,22643,22644,22646,22647,22648,22649,22659,22673,22674,22686,22687,22708,22719,22739,22740,22743,22744,22745,22746,22747,22748,22749,22750,22751,22752,22753,22754,22755,22756,22757,22758,22759,22760,22761,22762,22763,22764,22765,22766,22767,22768,22769,22770,22771,22772,22773,22774,22777,22778,22779,22780,22781,22783,22784,22785,22787,22788,22789,22790,22791,22792,22793,22794,22795,22797,22800,22801,22802,22803,22804,22806,22807,22808,22809,22810,22811,22812,22813,22814,22815,22817,22818,22819,22822,22823,22824,22826,22827,22828,22829,22830,22831,22832,22834,22835,22836,22837,22838,22839,22840,22841,22844,22845,22846,22847,22856,22857,22858,22859,22860,22862,22863,22864,22865,22866,22867,22868,22869,22870,22871,22872,22873,22874,22877,22878,22880,22881,22882,22883,22884,22885,22886,22887,22888,22898,22901,23002,23021,23022,23023,23024,23025,23026,23027,23028,23029,23030,23031,23032,23033,23034,23035,23036,23037,23038,23039,23040,23041,23042,23043,23044,23045,23046,23047,23048,23049,23050,23051,23052,23053,23054,23055,23056,23057,23058,23059,23060,23061,23062,23063,23064,23065,23066,23067,23068,23069,23070,23071,23072,23073,23074,23075,23076,23077,23078,23079,23080,23081,23082,23083,23084,23085,23086,23087,23088,23089,23090,23095,23167,23185,23194,23195,23196,23197,23213,23228,23287,23288,23289,23290,23291,23292,23293,23294,23295,23296,23297,23298,23365,23366,23367,23368,23369,23370,23392,23394,23396,23397,23398,23399,23401,23402,23403,23404,23405,23406,23407,23409,23410,23411,23412,23413,23414,23415,23416,23417,23418,23436,23461,23462,23463,23464,23492,23495,23496,23497,23501,23503,23504,23505,23506,23507,23508,23510,23511,23512,23513,23527,23528,23529,23530,23531,23532,23533,23534,23535,23536,23537,23538,23539,23540,23541,23542,23543,23544,23545,23557,23558,23561,23562,23563,23564,23565,23566,23567,23568,23569,23570,23571,23572,23573,23581,23582,23583,23584,23585,23586,23608,23609,23610,23611,23613,23614,23615,23616,23617,23618,23620,23627,23629,23630,23632,23633,23635,23636,23637,23638,23639,23640,23641,23642,23644,23646,23647,23648,23649,23651,23658,23659,23660,23661,23662,23663,23664,23665,23666,23667,23668,23669,23670,23671,23672,23673,23697,23702,23703,23704,23705,23707,23709,23710,23711,23713,23719,23720,23739,23740,23741,23745,23746,23748,23756,23757,23758,23759,23760,23761,23762,23763,23764,23765,23766,23767,23768,23769,23770,23771,23772,23773,23774,24899,24909,24910,24911,24920,24922,24923,24924,24925,24926,24927,24928,24929,24930,24932,24934,24936,24937,24938,24939,24940,24941,24942,24945,24947,24949,24950,24951,24952,24953,24954,24955,24956,24957,24958,24959,24960,24961,24963,24964,24965,24966,24967,24968,24969,24970,24971,24972,24973,24974,24975,24976,24977,24978,24979,24980,24981,24982,24983,24984,24985,24993,24994,24995,24996,24997,24998,24999,25006,25010,25012,25014,25015,25016,25017,25018,25019,25020,25021,25027,25029,25033,25036,25037,25038,25039,25040,25041,25042,25043,25044,25045,25046,25047,25048,25049,25050,25051,25052,25053,25054,25056,25058,25073,27501,27507,27509,27510,27516,27527,27538,27541,27542,27543,27544,27545,27546,27547,27548,27549,27550,27552,27553,27554,27556,27558,27559,27560,27561,27562,27564,27565,27566,27567,27572,27626,27627,27628,27629,27630,27631,27632,27633,27634,27635,27637,27638,27639,27640,27641,27642,27643,27644,27645,27650,27651,27652,27655,27657,27658,27659,27660,27661,27662,27664,27665,27666,27668,27669,27672,27673,27696,27697,27698,27699,27700,27701,27702,27703,27704,27705,27706,27707,27708,27709,27710,27711,27712,27713,27714,27715,27718,27719,27720,27721,27722,27723,27724,27725,27726,27727,27774,27775,27801,27802,27803,27804,27806,27808,27809,27810,27836,27838,27839,27840,27842,27848,27849,27850,27851,27852,27853,27854,27856,27857,27860,27861,27862,27863,27864,27866,27867,27870,27871,27877,27882,27889,27890,27891,27892,27893,27894,27895,27896,27897,27898,27899,27900,27901,27902,27903,27904,27905,27906,27907,27909,27910,27911,27912,27913,27914,27915,27916,27917,27918,27919,27947,27950,27957,27958,27959,27960,27966,27967,27970,27974,27975,27976,27977,27983,27984,27986,27991,27994,27996,28000,28001,28003,28004,28006,28007,28008,28010,28012,28019,28022,28023,28024,28025,28027,28035,28042,28043,28047,28056,28063,28064,28065,28066,28068,28071,28072,28073,28074,28082,28084,28085,28086,28087,28088,28089,28090,28091,28092,28093,28094,28095,28096,28097,28098,28099,28100,28101,28111,28112,28113,28114,28115,28116,28117,28118,28119,28120,28122,28124,28125,28128,28129,28130,28131,28137,28138,28139,28140,28141,28154,28160,28168,28171,28172,28173,28174,28175,28176,28177,28178,28180,28182,28184,28186,28187,28188,28190,28193,28198,28199,28205,28207,28210,28231,28233,28235,28238,28239,28240,28241,28242,28243,28244,28245,28246,28247,28249,28250,28251,28252,28253,28254,28255,28256,28257,28258,28259,28260,28262,28264,28265,28267,28268,28269,28270,28271,28273,28274,28275,28277,28278,28279,28282,28284,28285,28286,28288,28290,28291,28298,28299,28300,28304,28305,28306,28307,28316,28317,28321,28328,28329,28332,28336,28347,28349,28358,28375,28390,28391,28393,28414,28415,28416,28417,28418,28419,28420,28421,28422,28438,28441,28446,28448,28451,28455,28456,28457,28459,28460,28461,28462,28463,28464,28465,28466,28467,28468,28469,28470,28471,28473,28474,28475,28476,28477,28478,28479,28480,28481,28482,28483,28487,28488,28489,28490,28492,28493,28494,28495,28496,28497,28498,28500,28502,28506,28512,28513,28514,28515,28545,28546,28547,28548,28549,28553,28555,28559,28560,28561,28562,28564,28567,28568,28584,28593,28597,28602,28616,28617,28623,28626,28637,28652,28718,28719,28780,28781,28784,28786,28789,28791,28792,28793,28794,28795,28796,28797,28799,28800,28801,28802,28803,28806,28807,28808,28809,28810,28811,28812,28814,28886,28889,28891,28896,28910,28935,28936,28940,28941,28954,28955,28956,28957,28958,28959,28960,28961,28962,29033,29064,29065,29066,29068,29070,29074,29075,29077,29080,29093,29094,29102,29103,29109,29120,29121,29122,29123,29124,29126,29147,29148,29149,29151,29152,29153,29164,29165,29166,29171,29172,29173,29174,29175,29186,29191,29194,29195,29196,29198,29199,29200,29201,29202,29207,29208,29209,29210,29213,29228,29229,29230,29231,29232,29233,29234,29235,29236,29238,29239,29240,29241,29242,29243,29244,29245,29251,29263,29264,29265,29266,29267,29268,29270,29271,29273,29274,29275,29278,29282,29283,29285,29295,29300,29371,29372,29376,29384,29400,29412,29413,29414,29418,29420,29421,29425,29429,29431,29438,29440,29441,29444,29448,29449,29450,29451,29452,29453,29454,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29472,29473,29506,29552,29558,29559,29560,29561,29562,29565,29566,29568,29569,29578,29595,29600,29606,29621,29625,29626,29639,29648,29657,29659,29673,29685,29777,29778,29779,29780,29782,29803,29805,29806,29807,29808,29809,29816,29817,29819,29820,29822,29826,29827,29829,29840,29842,29843,29844,29847,29849,29852,29853,29854,29855,29856,29857,29858,29859,29860,29861,29862,29906,29909,29910,29911,29912,29913,29914,29915,29916,29917,29918,29919,29920,29921,29922,29923,29924,29925,29926,29927,29928,29929,29930,29931,29937,29956,29980,29981,29982,29983,29985,29987,29989,29999,30015,30016,30023,30044,30045,30046,30047,30048,30049,30050,30052,30053,30055,30057,30058,30059,30062,30063,30064,30065,30066,30069,30070,30073,30075,30152,30153,30154,30155,30156,30157,30158,30159,30160,30161,30162,30165,30168,30169,30170,30172,30175,30176,30177,30178,30182,30196,30199,30205,30206,30210,30212,30232,30233,30234,30235,30236,30237,30238,30239,30240,30241,30242,30243,30244,30245,30246,30247,30249,30250,30251,30252,30270,30275,30276,30279,30283,30286,30287,30289,30290,30291,30292,30295,30296,30303,30307,30308,30311,30312,30313,30314,30317,30318,30324,30333,30454,30513,30516,30517,30518,30519,30521,30524,30525,30528,30530,30532,30533,30534,30537,30539,30540,30541,30542,30545,30550,30556,30557,30576,30577,30578,30584,30585,30601,30609,30620,30625,30626,30634,30642,30644,30646,30647,30649,30650,30651,30652,30653,30670,30672,30692,30700,30702,30703,30716,30717,30718,30719,30720,30722,30723,30725,30726,30727,30728,30729,30733,30734,30736,30737,30738,30739,30741,30743,30744,30754,30755,30756,30757,30758,30759,30761,30766,30767,30770,30771,30773,30774,30777,30778,30781,30786,30789,30792,30794,30795,30798,30799,30806,30807,30809,30810,30811,30815,30816,30823,30824,30827,30828,30831,30833,30835,30839,30841,30842,30846,30847,30848,30850,30863,30864,30865,30887,30890,31019,31020,31021,31022,31023,31024,31025,31026,31027,31028,31029,31030,31031,31032,31033,31034,31035,31036,31037,31038,31039,31040,31042,31043,31044,31045,31046,31047,31048,31051,31053,31058,31059,31063,31066,31093,31218,31219,31220,31222,31225,31226,31227,31228,31234,31237,31239,31240,31242,31245,31249,31252,31258,31259,31260,31261,31262,31278,31279,31288,31290,31291,31292,31293,31294,31299,31300,31301,31302,31303,31304,31305,31306,31307,31308,31309,31310,31311,31312,31314,31315,31316,31317,31318,31319,31320,31321,31322,31323,31324,31341,31342,31345,31350,31360,31361,31362,31365,31366,31368,31369,31373,31379,31382,31385,31386,31397,31398,31408,31460,31461,31463,31464,31465,31466,31467,31468,31472,31473,31474,31475,31476,31478,31481,31482,31488,31489,31490,31491,31492,31493,31494,31495,31496,31497,31498,31499,31500,31501,31503,31504,31505,31507,31509,31515,31518,31519,31522,31532,31535,31536,31541,31543,31546,31547,31549,31551,31556,31557,31561,31571,31574,31575,31576,31580,31582,31606,31659,31675,31683,31691,31700,31702,31703,31704,31707,31708,31710,31711,31716,31717,31718,31720,31746,31747,31749,31752,31753,31754,31758,31762,31763,31777,31788,31789,31790,31798,31801,31804,31808,31814,31815,31822,31824,31826,31836,31837,31838,31843,31844,31851,31861,31866,31868,31871,31872,31875,31882,31883,31884,31885,31887,31892,31896,31900,31908,31915,31917,31963,31964,31965,31966,32000,32001,32002,32003,32035,32049,32050,32051,32052,32053,32054,32055,32059,32062,32063,32064,32065,32069,32070,32073,32074,32075,32081,32111,32112,32113,32114,32115,32116,32117,32118,32120,32121,32125,32149,32150,32151,32152,32153,32155,32159,32160,32161,32162,32163,32197,32198,32199,32200,32201,32202,32203,32204,32205,32208,32210,32211,32223,32225,32226,32227,32228,32229,32230,32231,32232,32233,32234,32235,32236,32237,32238,32240,32241,32242,32243,32252,32253,32254,32255,32256,32257,32258,32259,32260,32261,32262,32263,32264,32265,32266,32267,32268,32269,32270,32271,32272,32273,32274,32289,32290,32291,32292,32293,32312,32313,32315,32316,32318,32319,32323,32324,32329,32340,32342,32343,32344,32345,32346,32347,32349,32350,32354,32358,32359,32360,32361,32362,32364,32365,32367,32368,32374,32401,32405,32406,32407,32408,32409,32410,32411,32412,32413,32414,32415) 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