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 = '232' AND p.product_id IN (23434,23435,23686,23694,23695,23696,23761,23762,23763,23764,23765,23766,23767,23768,23769,23770,23771,23772,23774) 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 = '232' AND p.product_id IN (16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,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,16587,16588,16589,16590,16591,16592,16593,16594,16595,16596,16597,16598,16599,16600,16601,16605,16606,16607,16608,16609,16610,16611,16612,16613,16614,16615,16616,16617,16618,16619,16620,16621,16622,16697,16717,16718,16723,16724,16728,16729,16735,16740,16741,16742,16743,16744,16745,16746,16747,16748,16749,16750,16751,16752,16753,16755,16756,16757,16758,16759,16760,16761,16762,16763,16764,16765,16766,16767,16768,16769,16770,16771,16772,16773,16775,16780,18030,18031,18032,18033,18034,18035,18037,18038,18041,18043,18045,18046,18047,18049,18050,18052,18053,18056,18059,18061,18062,18077,18078,18079,18080,18081,18082,18083,18084,18085,18086,18087,18088,18089,18090,18091,18092,18093,18094,18095,18096,18097,18098,18099,18100,18101,18102,18103,18104,18105,18106,18107,18108,18109,18110,18111,18112,18113,18114,18116,18119,18120,18121,18122,18123,18125,18126,18127,18128,18129,18130,18131,18132,18133,18134,18135,18136,18138,18139,18140,18141,18142,18143,18144,18145,18146,18147,18148,18149,18150,18151,18152,18153,18154,18157,18162,18165,18186,18187,18188,18189,18190,18200,18201,18203,18206,18208,18211,18212,18213,18214,18215,18216,18217,18218,18219,18220,18221,18222,18225,18226,18232,18233,18238,18239,18244,18246,18271,18272,18273,18274,18275,18276,18277,18278,18279,18280,18281,18282,18283,18284,18287,18289,18291,18293,18295,18296,18297,18299,18301,18304,18305,18326,18342,18360,18366,18429,18439,18444,18445,18446,18447,18448,18449,18450,18453,18454,18455,18456,18457,18458,18459,18460,18461,18462,18463,18464,18465,18466,18467,18468,18469,18470,18472,18473,18474,18475,18476,18477,18478,18479,18481,18482,18483,18484,18485,18487,18488,18489,18490,18491,18492,18493,18494,18495,18496,18498,18499,18503,18506,18510,18511,18512,18514,18519,18521,18522,18524,18525,18526,18527,18528,18529,18530,18532,18534,18536,18537,18538,18540,18543,18544,18545,18546,18549,18550,18551,18552,18553,18554,18555,18556,18557,18564,18565,18622,18623,18624,18625,18627,18635,18636,18637,18639,18643,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18658,18659,18660,18661,18662,18663,18664,18665,18666,18667,18683,18684,18689,18691,18692,18693,18694,18696,18697,18715,18725,18727,18729,18732,18733,18736,18737,18738,18742,18747,18749,18750,18754,18757,18759,18765,18766,18771,18773,18774,18775,18779,18780,18781,18783,18788,18789,18790,18792,18795,18797,18801,18804,18810,18811,18812,18813,18815,18820,18821,18824,18827,18828,18829,18832,18834,18835,18837,18838,18839,18845,18848,18849,18850,18853,18854,18855,18856,18858,18860,18866,18868,18870,18873,18883,18885,18888,18890,18893,18895,18896,18898,18899,18900,18901,18902,18903,18904,18905,18906,18907,18909,18910,18911,18912,18913,18915,18916,18917,18920,18921,18923,18929,18930,18934,18943,18944,18948,18949,18952,18953,18956,18960,18967,18968,18969,18970,18971,18972,18973,18975,18976,18977,18978,18979,18980,18981,18983,18984,18985,18986,18990,18991,18995,18996,18997,18998,19001,19002,19003,19008,19009,19010,19012,19013,19014,19015,19016,19017,19018,19019,19020,19021,19022,19025,19026,19029,19034,19042,19048,19061,19062,19063,19064,19065,19070,19071,19072,19073,19074,19075,19076,19084,19085,19087,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19108,19109,19132,19141,19142,19143,19145,19146,19147,19148,19149,19150,19151,19152,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19172,19173,19174,19176,19183,19184,19185,19186,19187,19188,19193,19197,19198,19199,19200,19201,19215,19217,19218,19220,19221,19222,19224,19225,19237,19238,19241,19243,19245,19246,19247,19248,19249,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19286,19288,19301,19317,19368,19370,19394,19405,19412,19416,19448,19562,19563,19564,19565,19566,19567,19568,19575,19577,19580,19582,19583,19584,19585,19586,19588,19589,19590,19591,19614,19615,19616,19617,19618,19619,19620,19621,19622,19623,19624,19625,19626,19628,19629,19630,19635,19647,19648,19650,19651,19653,19654,19655,19656,19657,19659,19660,19663,19664,19666,19667,19668,19669,19693,19700,19708,19709,19711,19713,19714,19715,19719,19720,19722,19725,19729,19732,19734,19735,19736,19737,19738,19739,19740,19741,19743,19744,19747,19748,19750,19754,19755,19756,19757,19760,19762,19766,19772,19775,19783,19785,19787,19789,19791,19794,19795,19796,19801,19804,19808,19810,19815,19821,19823,19824,19826,19828,19829,19831,19832,19833,19836,19837,19838,19839,19844,19845,19846,19847,19848,19850,19852,19853,19854,19856,19857,19860,19861,19862,19863,19875,19876,19877,19879,19880,19882,19898,19902,19921,19922,19923,19924,19927,19928,19929,19930,19931,19932,19933,19934,19935,19940,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,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,20003,20004,20005,20006,20007,20008,20009,20010,20011,20012,20013,20014,20015,20016,20020,20021,20023,20024,20028,20031,20034,20035,20039,20042,20050,20063,20064,20066,20068,20072,20073,20074,20076,20077,20079,20086,20087,20090,20091,20094,20095,20096,20097,20104,20106,20108,20109,20110,20111,20112,20115,20116,20118,20122,20123,20124,20130,20131,20132,20133,20135,20140,20141,20142,20143,20144,20146,20147,20148,20149,20150,20151,20152,20153,20154,20155,20156,20157,20158,20159,20160,20161,20162,20163,20164,20165,20166,20167,20168,20211,20223,20224,20227,20231,20232,20235,20238,20243,20244,20245,20247,20248,20249,20250,20252,20254,20257,20258,20261,20262,20263,20264,20267,20271,20272,20273,20276,20277,20282,20283,20284,20285,20286,20289,20290,20291,20292,20293,20294,20296,20307,20310,20315,20316,20320,20329,20332,20334,20335,20336,20337,20338,20339,20340,20345,20346,20348,20349,20350,20351,20354,20359,20360,20364,20365,20366,20367,20368,20369,20370,20371,20372,20373,20376,20378,20381,20382,20383,20384,20385,20427,20429,20430,20438,20439,20441,20443,20445,20447,20449,20450,20455,20456,20457,20464,20466,20467,20469,20471,20472,20474,20475,20481,20482,20485,20487,20488,20489,20492,20509,20521,20524,20526,20527,20528,20529,20534,20535,20538,20541,20542,20543,20544,20546,20548,20551,20552,20555,20556,20557,20558,20559,20560,20565,20566,20567,20568,20569,20570,20571,20572,20573,20574,20575,20580,20581,20584,20586,20590,20591,20592,20593,20596,20597,20598,20599,20600,20601,20603,20604,20605,20608,20612,20621,20631,20632,20633,20634,20637,20644,20645,20646,20648,20655,20656,20657,20658,20659,20661,20662,20663,20669,20670,20672,20677,20681,20684,20686,20700,20701,20703,20706,20710,20715,20727,20744,20757,20758,20760,20761,20762,20763,20764,20766,20769,20772,20773,20774,20777,20778,20786,20789,20792,20794,20797,20801,20803,20811,20812,20813,20816,20817,20818,20821,20822,20824,20826,20831,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20866,20867,20868,20870,20871,20872,20905,20907,20917,20929,20930,20937,20939,20940,20942,20944,20947,20950,20959,20963,20965,20970,20974,20979,20983,20989,21011,21031,21034,21035,21039,21040,21046,21048,21054,21056,21060,21061,21062,21063,21064,21065,21066,21067,21069,21071,21072,21073,21074,21076,21077,21080,21081,21084,21086,21087,21088,21090,21091,21092,21093,21094,21096,21098,21099,21100,21101,21102,21103,21124,21125,21131,21132,21133,21168,21169,21171,21200,21203,21210,21215,21218,21219,21221,21223,21226,21227,21229,21246,21247,21251,21256,21258,21266,21310,21313,21314,21315,21318,21355,21358,21359,21360,21362,21363,21367,21409,21414,21434,21466,21488,21489,21490,21498,21505,21509,21511,21513,21515,21520,21523,21524,21532,21575,21577,21594,21602,21603,21610,21615,21619,21624,21627,21630,21631,21633,21634,21635,21638,21639,21640,21641,21642,21643,21647,21650,21651,21652,21656,21657,21667,21670,21671,21672,21674,21675,21676,21720,21740,21743,21744,21745,21746,21750,21751,21753,21754,21756,21757,21758,21759,21760,21761,21762,21763,21764,21765,21767,21768,21769,21771,21772,21773,21775,21776,21777,21778,21779,21780,21782,21784,21786,21787,21790,21791,21792,21793,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,21829,21830,21831,21832,21833,21834,21835,21836,21837,21838,21839,21842,21846,21859,21862,21863,21867,21868,21869,21870,21871,21896,21897,21898,21899,21900,21901,21902,21903,21904,21905,21906,21907,21908,21909,21960,21965,21969,21970,21975,21991,22024,22026,22030,22077,22083,22181,22185,22187,22188,22189,22192,22193,22194,22195,22196,22197,22199,22200,22201,22202,22204,22205,22206,22207,22208,22210,22211,22213,22214,22215,22217,22218,22219,22221,22222,22226,22231,22249,22250,22251,22252,22253,22254,22255,22256,22257,22258,22259,22260,22261,22262,22263,22264,22265,22266,22267,22269,22270,22271,22272,22273,22274,22275,22276,22277,22278,22279,22280,22281,22443,22485,22486,22487,22488,22489,22490,22491,22492,22493,22494,22495,22496,22497,22498,22526,22529,22530,22531,22532,22533,22534,22536,22537,22539,22542,22546,22547,22555,22607,22614,22617,22618,22627,22654,22655,22656,22657,22658,22661,22667,22669,22670,22683,22688,22697,22698,22700,22701,22702,22703,22704,22705,22707,22708,22709,22710,22711,22712,22713,22714,22715,22716,22718,22722,22724,22725,22726,22727,22729,22730,22731,22732,22733,22735,22736,22737,22739,22740,22741,22744,22745,22756,22757,22759,22760,22761,22762,22763,22764,22767,22768,22771,22772,22773,22777,22778,22780,22783,22793,22794,22798,22800,22801,22802,22803,22804,22806,22807,22808,22809,22811,22813,22814,22815,22817,22818,22819,22822,22823,22824,22826,22827,22830,22831,22832,22836,22837,22838,22839,22844,22845,22848,22849,22850,22851,22852,22853,22854,22855,22856,22857,22858,22859,22860,22866,22869,22871,22872,22875,22876,22877,22878,22879,22880,22881,22882,22883,22884,22885,22886,22887,22888,22908,22912,22915,22928,22930,22931,22933,22934,22935,22936,22937,22941,22942,22943,22944,22945,22946,22947,22948,22949,22950,22951,22952,22953,22954,22955,22956,22957,22958,22959,22960,22961,22962,22963,22964,22969,22970,22971,22974,22975,22976,22977,22978,22979,22980,22981,22982,22983,22984,22985,22988,22994,22999,23001,23002,23006,23007,23008,23010,23011,23012,23013,23014,23015,23016,23017,23018,23019,23020,23036,23037,23038,23039,23040,23041,23042,23043,23044,23045,23053,23054,23057,23058,23060,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,23134,23138,23139,23140,23142,23154,23155,23156,23157,23158,23161,23194,23195,23196,23197,23228,23239,23240,23241,23242,23243,23287,23300,23312,23313,23314,23315,23316,23347,23357,23358,23360,23361,23362,23363,23364,23365,23367,23368,23369,23374,23375,23376,23377,23378,23379,23380,23381,23382,23383,23384,23385,23386,23394,23396,23397,23398,23399,23400,23401,23403,23404,23406,23407,23408,23410,23411,23414,23416,23417,23418,23419,23434,23435,23486,23487,23488,23489,23490,23498,23499,23500,23502,23503,23504,23509,23510,23511,23512,23513,23514,23515,23516,23517,23518,23519,23523,23524,23525,23526,23527,23528,23537,23538,23539,23540,23541,23542,23543,23545,23574,23575,23576,23578,23579,23580,23591,23592,23593,23594,23595,23596,23597,23598,23605,23606,23607,23609,23611,23616,23617,23618,23619,23621,23622,23623,23624,23625,23626,23643,23644,23645,23647,23648,23654,23655,23674,23675,23677,23678,23686,23694,23695,23696,23705,23706,23707,23708,23709,23710,23711,23712,23713,23714,23715,23716,23717,23718,23721,23722,23723,23724,23725,23726,23727,23728,23729,23730,23731,23732,23733,23734,23735,23736,23737,23738,23740,23741,23742,23743,23744,23745,23746,23747,23748,23749,23750,23751,23752,23753,23754,23755,23761,23762,23763,23764,23765,23766,23767,23768,23769,23770,23771,23772,23774,24921,24928,24929,24930,24931,24932,24933,24934,24935,24936,24937,24938,24939,24940,24941,24942,24943,24944,24945,24946,24947,24948,24949,24950,24951,24952,24953,24954,24955,24956,24957,24958,24959,24960,24961,24962,24963,24967,24968,24969,24970,24971,24972,24973,24974,24978,24979,24980,24981,24982,24985,24989,24990,24991,24992,25003,25008,25010,25011,25013,25014,25016,25017,25018,25019,25022,25023,25024,25025,25026,25058,25059,27491,27492,27494,27495,27497,27499,27500,27502,27503,27508,27513,27514,27515,27516,27517,27518,27519,27520,27521,27522,27523,27524,27525,27526,27527,27528,27529,27530,27531,27532,27533,27534,27535,27536,27537,27538,27539,27540,27557,27558,27559,27560,27561,27562,27563,27564,27565,27566,27567,27568,27569,27570,27571,27572,27573,27574,27575,27576,27577,27578,27579,27580,27581,27582,27583,27584,27585,27586,27587,27588,27589,27590,27591,27592,27593,27594,27595,27596,27597,27598,27599,27600,27601,27602,27603,27604,27605,27606,27607,27608,27609,27610,27611,27612,27613,27614,27615,27616,27617,27723,27777,27778,27779,27780,27781,27782,27783,27784,27785,27786,27787,27788,27789,27790,27791,27792,27793,27794,27795,27796,27797,27798,27799,27802,27803,27804,27805,27806,27807,27808,27809,27810,27811,27812,27813,27814,27815,27816,27826,27827,27828,27829,27830,27831,27832,27833,27834,27837,27839,27840,27841,27843,27844,27845,27846,27847,27855,27858,27859,27863,27864,27865,27868,27869,27873,27874,27875,27876,27879,27881,27882,27883,27885,27886,27887,27888,27893,27894,27896,27897,27899,27902,27903,27904,27905,27911,27913,27914,27916,27917,27918,27919,27920,27921,27922,27923,27924,27925,27926,27927,27928,27929,27930,27931,27932,27933,27934,27935,27936,27937,27938,27939,27940,27941,27942,27943,27944,27945,27946,27947,27948,27949,27950,27951,27952,27953,27954,27955,27956,27957,27958,27959,27960,27961,27962,27963,27964,27965,27966,27967,27968,27969,27970,27971,27972,27973,27974,27975,27976,27977,27978,27979,27980,27981,27982,27994,27995,27996,27997,27998,28000,28001,28007,28011,28014,28016,28026,28031,28036,28037,28038,28039,28040,28042,28043,28044,28045,28046,28047,28048,28049,28064,28065,28066,28067,28068,28069,28070,28071,28072,28073,28074,28075,28076,28077,28078,28079,28080,28081,28082,28083,28084,28087,28091,28092,28093,28094,28095,28097,28103,28104,28105,28106,28107,28108,28109,28123,28128,28129,28130,28132,28137,28138,28139,28140,28141,28142,28144,28145,28148,28149,28150,28151,28152,28154,28155,28156,28157,28158,28159,28162,28163,28164,28165,28166,28168,28186,28187,28188,28189,28190,28191,28192,28193,28194,28195,28196,28197,28198,28199,28200,28201,28202,28203,28204,28205,28206,28207,28208,28209,28210,28211,28212,28213,28214,28215,28216,28217,28218,28219,28220,28221,28222,28223,28224,28225,28226,28227,28228,28229,28230,28232,28233,28234,28235,28236,28237,28278,28279,28280,28281,28282,28283,28284,28285,28286,28287,28288,28289,28290,28291,28292,28293,28294,28296,28297,28298,28299,28300,28302,28303,28305,28307,28311,28315,28317,28319,28328,28331,28334,28335,28336,28337,28340,28342,28343,28346,28347,28352,28368,28414,28415,28416,28417,28418,28419,28420,28421,28422,28423,28424,28425,28426,28427,28428,28429,28431,28432,28433,28434,28436,28438,28439,28441,28456,28457,28458,28463,28472,28479,28484,28494,28498,28499,28500,28501,28502,28503,28514,28515,28516,28556,28561,28570,28571,28575,28576,28577,28594,28596,28598,28609,28615,28618,28619,28621,28623,28659,28661,28662,28667,28668,28697,28702,28780,28781,28784,28786,28789,28791,28792,28793,28795,28796,28797,28799,28801,28806,28847,28848,28849,28852,28853,28855,28858,28886,28888,28889,28890,28895,28896,28897,28898,28901,28902,28904,28906,28907,28909,28913,28914,28917,28920,28921,28923,28924,28925,28926,28927,28928,28933,28935,28936,28939,28940,28949,28950,28951,28953,28954,28955,28956,28957,28958,28959,28960,28961,28962,28964,28965,28966,28973,29012,29013,29014,29015,29016,29017,29018,29019,29020,29021,29022,29023,29033,29034,29035,29036,29037,29038,29039,29040,29041,29042,29043,29044,29045,29046,29047,29048,29064,29065,29066,29067,29068,29069,29070,29071,29072,29073,29154,29155,29161,29203,29204,29205,29206,29230,29231,29233,29234,29235,29236,29282,29283,29284,29285,29286,29287,29288,29289,29290,29291,29292,29293,29294,29295,29296,29297,29298,29299,29300,29301,29302,29303,29304,29305,29306,29307,29308,29309,29310,29311,29312,29313,29314,29315,29316,29317,29318,29319,29320,29321,29322,29323,29324,29325,29326,29327,29328,29329,29330,29331,29332,29333,29334,29335,29336,29337,29338,29339,29342,29343,29344,29345,29346,29347,29348,29349,29350,29351,29352,29353,29354,29355,29356,29357,29358,29359,29360,29403,29408,29428,29476,29494,29498,29505,29510,29552,29569,29575,29588,29590,29592,29596,29600,29601,29603,29604,29605,29606,29607,29608,29611,29613,29615,29619,29620,29622,29623,29624,29625,29626,29627,29628,29629,29630,29632,29633,29635,29636,29653,29685,29687,29692,29693,29694,29695,29697,29721,29728,29730,29731,29734,29735,29737,29738,29739,29740,29741,29742,29782,29783,29784,29785,29786,29787,29788,29789,29790,29791,29792,29795,29797,29798,29801,29815,29816,29817,29818,29819,29821,29823,29833,29835,29838,29839,29840,29842,29844,29847,29848,29852,29853,29856,29858,29860,29870,29882,29884,29885,29888,29890,29896,29909,29910,29911,29914,29915,29916,29921,29925,29926,29933,29934,29937,29946,29947,29949,29954,29955,29956,29957,29958,29980,29981,29982,29983,29984,29985,30046,30047,30048,30049,30050,30165,30166,30204,30205,30206,30207,30208,30209,30210,30211,30212,30249,30283,30285,30296,30297,30298,30299,30300,30301,30302,30303,30304,30305,30306,30308,30309,30310,30313,30316,30323,30328,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,30441,30444,30445,30446,30447,30448,30449,30450,30460,30462,30487,30489,30495,30500,30506,30507,30532,30533,30536,30538,30557,30575,30587,30630,30631,30649,30667,30668,30669,30673,30674,30675,30680,30682,30685,30686,30687,30691,30694,30697,30701,30702,30705,30708,30719,30748,30759,30767,30775,30794,30861,30863,30866,30867,30868,30870,30872,30875,30878,30879,30880,30881,30883,30884,30885,30888,30889,30890,30891,30892,30894,30895,30896,30897,30898,30899,30900,30901,30902,30904,30905,30906,30907,30908,30910,30911,30912,30913,30914,30915,30916,30917,30918,30919,30920,30921,30923,30924,30926,30927,30928,30929,30930,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,30999,31000,31001,31003,31004,31005,31007,31008,31009,31010,31011,31012,31013,31014,31040,31148,31151,31182,31251,31252,31253,31254,31255,31256,31257,31258,31261,31262,31292,31293,31294,31301,31302,31303,31304,31305,31306,31307,31308,31309,31310,31311,31312,31314,31315,31316,31317,31318,31320,31321,31322,31323,31324,31353,31355,31387,31388,31391,31403,31408,31456,31460,31461,31463,31467,31468,31469,31470,31472,31473,31474,31477,31479,31482,31483,31484,31485,31487,31504,31505,31508,31509,31511,31512,31515,31524,31535,31536,31538,31539,31545,31546,31616,31630,31653,31657,31665,31673,31674,31684,31685,31716,31720,31726,31742,31752,31766,31767,31788,31790,31792,31795,31806,31810,31811,31820,31832,31853,31869,31871,31876,31879,31880,31881,31882,31884,31886,31887,31888,31899,31900,31905,31910,31911,31912,31913,31918,31964,31965,31967,31968,31969,31970,32000,32001,32002,32004,32025,32029,32031,32035,32043,32044,32045,32049,32053,32062,32065,32073,32074,32075,32081,32118,32119,32120,32121,32122,32123,32124,32125,32126,32127,32128,32129,32130,32131,32132,32133,32134,32135,32136,32137,32138,32139,32140,32141,32142,32143,32144,32145,32146,32147,32148,32149,32150,32151,32152,32153,32154,32155,32156,32157,32158,32159,32160,32161,32162,32163,32177,32178,32179,32180,32181,32182,32183,32184,32202,32203,32225,32226,32227,32228,32229,32230,32231,32232,32233,32234,32235,32236,32237,32238,32239,32254,32260,32262,32263,32265,32266,32267,32268,32269,32270,32271,32272,32273,32274,32292,32293,32349,32352,32353,32354,32356,32357,32358,32389,32395,32400,32402,32403,32404,32411,32421,32422,32423,32424) 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 padangos internetu pigiau | Autorolis.lt