SELECT 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, (SELECT ps.date_end 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' AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special_price_valid_until, 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 (18034,18043,18056,18067,18077,18092,18095,18105,18106,18111,18138,18139,18148,18155,18165,18169,18170,18176,18188,18227,18234,18249,18254,18263,18273,18275,18276,18282,18283,18286,18290,18302,18303,18304,18030,18031,18035,18036,18037,18040,18041,18044,18047,18049,18050,18051,18055,18057,18059,18060,18061,18062,18071,18073,18075,18078,18080,18081,18082,18083,18084,18085,18088,18089,18090,18091,18093,18096,18097,18101,18102,18103,18104,18107,18108,18109,18110,18114,18115,18118,18119,18121,18125,18126,18128,18129,18134,18141,18142,18143,18144,18149,18150,18151,18153,18156,18157,18162,18164,18168,18174,18175,18177,18178,18183,18184,18187,18190,18214,18224,18229,18233,18235,18236,18239,18240,18241,18245,18246,18248,18250,18255,18258,18261,18267,18269,18270,18271,18272,18277,18281,18284,18285,18287,18288,18289,18291,18292,18293,18294,18295,18296,18297,18298,18299,18301,18305,18306,18256,18274,18268,18243,18253,18076,18264,18228,18421,18242) 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,10000SELECT 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, (SELECT ps.date_end 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' AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special_price_valid_until, 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 (16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,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,16602,16603,16604,16605,16606,16607,16608,16609,16610,16611,16612,16613,16614,16615,16616,16617,16618,16619,16620,16621,16622,16623,18030,18031,18034,18035,18036,18037,18040,18041,18043,18044,18047,18049,18050,18051,18055,18056,18057,18059,18060,18061,18062,18067,18071,18073,18075,18076,18077,18078,18080,18081,18082,18083,18084,18085,18088,18089,18090,18091,18092,18093,18095,18096,18097,18101,18102,18103,18104,18105,18106,18107,18108,18109,18110,18111,18114,18115,18118,18119,18121,18123,18125,18126,18128,18129,18134,18138,18139,18141,18142,18143,18144,18148,18149,18150,18151,18153,18155,18156,18157,18162,18164,18165,18168,18169,18170,18174,18175,18176,18177,18178,18183,18184,18186,18187,18188,18190,18214,18224,18227,18228,18229,18233,18234,18235,18236,18239,18240,18241,18242,18243,18245,18246,18248,18249,18250,18253,18254,18255,18256,18258,18261,18263,18264,18267,18268,18269,18270,18271,18272,18273,18274,18275,18276,18277,18281,18282,18283,18284,18285,18286,18287,18288,18289,18290,18291,18292,18293,18294,18295,18296,18297,18298,18299,18301,18302,18303,18304,18305,18306,18421,18511,18512,18514,18515,18516,18517,18520,18521,18522,18524,18526,18527,18532,18534,18538,18540,18543,18544,18546,18548,18555,18556,18557,18560,18561,18562,18564,18567,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,18667,18668,18669,18670,18671,18672,18673,18674,18675,18676,18677,18678,18679,18705,18751,18752,18753,18760,18775,18776,18777,18785,18786,18787,18789,18792,18795,18797,18798,18803,18804,18806,18817,18819,18825,18829,18838,18839,18847,18852,18853,18855,18856,18858,18859,18860,18861,18864,18865,18875,18877,18879,18883,18884,18886,18887,18888,18889,18890,18891,18893,18895,18896,18898,18899,18900,18901,18903,18904,18905,18906,18907,18909,18910,18911,18912,18913,18914,18915,18917,18918,18920,18921,18922,18923,18924,18925,18926,18927,18928,18929,18931,18932,18933,18934,18936,18937,18938,18939,18940,18941,18942,18943,18944,18945,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19197,19198,19199,19200,19201,19285,19286,19288,19289,19290,19291,19292,19293,19297,19301,19305,19374,19382,19394,19405,19406,19428,19429,19430,19432,19433,19434,19437,19439,19440,19441,19442,19444,19445,19446,19450,19452,19453,19454,19457,19458,19460,19461,19462,19463,19464,19466,19467,19468,19469,19470,19471,19472,19473,19474,19475,19476,19477,19478,19479,19480,19481,19482,19483,19484,19486,19487,19489,19490,19491,19492,19585,19586,19588,19589,19590,19591,19592,19593,19594,19595,19596,19597,19598,19599,19600,19601,19602,19603,19604,19605,19606,19607,19608,19609,19610,19611,19612,19613,19614,19616,19617,19619,19621,19622,19623,19628,19632,19633,19634,19635,19636,19637,19638,19639,19640,19641,19642,19643,19644,19645,19646,19647,19648,19649,19650,19651,19653,19654,19656,19657,19658,19659,19660,19661,19662,19663,19664,19665,19666,19667,19668,19676,19677,19719,19720,19721,19722,19723,19724,19725,19726,19727,19728,19729,19731,19732,19733,19734,19737,19739,19740,19741,19742,19743,19744,19745,19746,19747,19748,19749,19750,19751,19752,19754,19755,19756,19757,19758,19759,19760,19761,19762,19763,19764,19765,19766,19767,19768,19769,19770,19771,19774,19775,19777,19778,19779,19780,19782,19783,19784,19786,19790,19791,19792,19793,19794,19795,19796,19797,19798,19801,19803,19804,19806,19809,19810,19811,19818,19820,19821,19822,19825,19826,19827,19832,19833,19835,19838,19840,19843,19844,19845,19846,19847,19848,19850,19852,19853,19854,19857,19859,19860,19861,19862,19863,19884,19885,19886,19887,19888,19889,19890,19891,19892,19893,19894,19896,19897,19898,19899,19900,19901,19902,19920,19922,19923,19926,19927,19928,19930,19931,19932,19933,19934,19935,19937,19938,19939,19941,19942,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,20146,20147,20148,20149,20150,20151,20152,20153,20154,20155,20156,20157,20158,20159,20160,20161,20162,20163,20164,20165,20166,20167,20168,20212,20900,20924,20932,20938,21060,21061,21062,21063,21064,21065,21111,21140,21146,21150,21320,21403,21429,21437,21441,21444,21446,21475,21476,21480,21481,21483,21484,21485,21486,21579,21588,21589,21592,21595,21597,21641,21701,21715,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,21773,21774,21775,21776,21777,21778,21780,21781,21782,21783,21784,21785,21786,21787,21788,21789,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,21833,21840,21841,21842,21843,21844,21845,21846,21847,21848,21849,21851,21852,21853,21854,21855,21856,21857,21858,21859,21860,21861,21862,21863,21864,21873,21875,21876,21877,21879,21880,21881,21883,21884,21885,21886,21887,21889,21894,21895,22127,22128,22244,22485,22490,22491,22492,22493,22494,22495,22497,22498,22558,22560,22563,22565,22566,22574,22581,22584,22608,22628,22630,22659,22660,22666,22691,22733,22734,22736,22737,22739,22743,22744,22745,22746,22747,22748,22749,22750,22751,22752,22753,22765,22767,22768,22769,22770,22771,22772,22773,22774,22777,22778,22779,22780,22781,22783,22784,22785,22787,22788,22789,22790,22791,22792,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,22861,22862,22863,22864,22865,22866,22867,22868,22869,22870,22871,22872,22873,22874,22875,22876,22877,22878,22879,22880,22881,22882,22883,22884,22885,22886,22887,22888,23002,23019,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,23138,23140,23141,23142,23144,23145,23146,23147,23148,23149,23150,23151,23152,23153,23154,23155,23156,23157,23158,23161,23209,23228,23245,23246,23247,23248,23259,23279,23286,23288,23300,23301,23302,23303,23304,23305,23306,23307,23308,23309,23310,23311,23312,23313,23314,23315,23316,23322,23327,23328,23330,23331,23349,23351,23363,23364,23392,23394,23396,23397,23398,23399,23401,23402,23404,23405,23406,23407,23410,23411,23412,23413,23414,23415,23416,23417,23418,23431,23461,23462,23463,23464,23465,23466,23467,23468,23469,23470,23471,23472,23473,23474,23475,23476,23477,23478,23479,23480,23481,23482,23483,23484,23485,23486,23487,23488,23489,23490,23491,23495,23496,23497,23498,23499,23500,23501,23508,23509,23510,23511,23512,23513,23514,23515,23516,23517,23518,23519,23520,23521,23522,23527,23528,23530,23533,23539,23540,23561,23562,23563,23564,23565,23566,23567,23568,23569,23570,23571,23572,23575,23576,23577,23578,23579,23580,23591,23592,23593,23594,23595,23596,23597,23598,23599,23600,23601,23602,23603,23604,23619,23643,23644,23645,23646,23647,23648,23649,23650,23651,23652,23653,23655,23656,23657,23658,23659,23687,23688,23689,23690,23691,23702,23703,23704,23705,23706,23707,23708,23709,23710,23711,23712,23713,23714,23719,23720,23721,23739,24899,24909,24910,24911,24912,24913,24914,24915,24916,24920,24921,24922,24923,24924,24925,24926,24927,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,24964,24965,24966,24967,24968,24969,24970,24971,24972,24973,24974,24975,24976,24977,24978,24979,24980,24981,24982,24983,24984,24985,25003,25004,25005,25055,27510,27511,27512,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,27541,27542,27543,27544,27545,27546,27547,27548,27549,27550,27551,27552,27553,27554,27555,27556,27557,27558,27559,27560,27561,27562,27563,27564,27565,27566,27567,27568,27569,27570,27571,27572,27573,27685,27686,27687,27688,27689,27690,27691,27692,27695,27835,27836,27837,27838,27839,27840,27841,27842,27843,27844,27845,27846,27847,27848,27849,27850,27851,27852,27853,27854,27855,27856,27857,27858,27859,27860,27861,27862,27863,27864,27865,27866,27867,27868,27869,27870,27871,27872,27873,27874,27875,27876,27877,27878,27879,27880,27881,27882,27883,27884,27885,27886,27887,27888,27889,27890,27891,27892,27894,27895,27896,27898,27899,27900,27901,27904,27905,27906,27907,27908,27909,27910,27911,27913,27914,27915,27916,28018,28042,28043,28044,28045,28046,28047,28048,28049,28050,28051,28052,28053,28054,28055,28056,28057,28058,28059,28060,28061,28062,28063,28064,28065,28066,28067,28068,28069,28070,28071,28072,28073,28074,28075,28076,28077,28078,28079,28080,28081,28082,28083,28097,28098,28099,28100,28101,28102,28103,28104,28105,28106,28107,28108,28109,28110,28111,28112,28171,28172,28173,28174,28175,28176,28177,28178,28179,28180,28181,28182,28183,28184,28185,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,28231,28232,28233,28234,28235,28236,28237,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,28296,28297,28299,28304,28305,28306,28391,28455,28456,28457,28459,28460,28461,28462,28467,28468,28469,28470,28471,28472,28473,28474,28475,28476,28477,28478,28479,28480,28481,28482,28484,28485,28486,28487,28488,28489,28490,28581,28588,28623,28626,28889,28891,28896,28902,28915,28919,28928,28932,28939,28942,28954,28955,28956,28957,28958,28959,28960,28961,28962,28964,28965,28966,28967,28968,28969,28970,28971,28972,28973,28974,28975,28976,28998,28999,29000,29001,29002,29003,29004,29005,29006,29007,29008,29009,29010,29011,29012,29013,29014,29015,29016,29017,29018,29019,29020,29021,29022,29023,29024,29025,29026,29027,29028,29029,29030,29031,29032,29033,29034,29035,29036,29037,29038,29039,29040,29041,29042,29043,29044,29045,29046,29047,29048,29049,29050,29051,29052,29053,29054,29147,29148,29149,29150,29151,29152,29153,29154,29155,29156,29157,29158,29159,29160,29161,29162,29163,29173,29174,29193,29194,29195,29196,29197,29198,29199,29200,29201,29202,29203,29204,29205,29206,29228,29229,29232,29241,29249,29251,29263,29264,29269,29273,29372,29385,29400,29410,29412,29418,29420,29421,29425,29429,29431,29437,29438,29440,29441,29444,29446,29447,29448,29449,29450,29451,29452,29453,29454,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29581,29582,29583,29584,29587,29622,29623,29653,29760,29804,29805,29808,29809,29811,29812,29813,29814,29815,29816,29817,29819,29820,29821,29822,29825,29842,29843,29844,29847,29848,29851,29854,29930,29931,29933,29934,29935,29936,29937,29997,29998,29999,30004,30015,30016,30017,30018,30019,30020,30021,30022,30023,30024,30025,30026,30027,30028,30029,30030,30031,30032,30033,30034,30035,30036,30037,30038,30039,30040,30041,30042,30043,30045,30055,30165,30166,30240,30245,30246,30247,30253,30254,30255,30451,30452,30453,30454,30455,30456,30457,30458,30459,30460,30461,30462,30463,30464,30516,30526,30527,30528,30537,30544,30548,30551,30561,30562,30563,30564,30565,30566,30567,30575,30576,30578,30579,30580,30581,30584,30585,30586,30588,30589,30590,30591,30592,30594,30597,30598,30599,30600,30601,30602,30604,30605,30606,30607,30608,30609,30610,30611,30614,30615,30616,30617,30618,30619,30620,30621,30622,30623,30624,30626,30627,30629,30631,30632,30633,30634,30635,30637,30638,30639,30835,30844,30850,31024,31042,31044,31048,31053,31252,31253,31254,31255,31256,31257,31258,31278,31299,31300,31301,31302,31303,31304,31305,31306,31307,31308,31309,31310,31311,31312,31313,31314,31315,31316,31317,31318,31319,31320,31321,31322,31323,31324,31328,31359,31377,31600,31967,31970,32006,32034,32036,32045,32084,32111,32112,32113,32114,32115,32116,32117,32118,32119,32120,32121,32122,32123,32159,32160,32161,32162,32163,32164,32165,32166,32167,32168,32169,32170,32171,32172,32173,32174,32175,32176,32177,32178,32179,32180,32181,32182,32183,32184,32197,32198,32199,32200,32201,32202,32203,32204,32205,32225,32226,32227,32228,32229,32230,32231,32232,32233,32234,32235,32236,32237,32238,32239,32247,32248,32289,32290,32291,32292,32293,32416,32417,32418,32419,32420,32421,32422,32423,32424,32425,32426,32427,32428,32429,32430) 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