QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(10971620,10971621,10971622,10971623,10971624,10971625,10971626,10971627,10971628,10971629,10971630,10971631,10971632,10971633,10971634,10971635,10971636,10971637,10971638,10971639,10971640,10971641,10971642,10971643,10971644,10971645,10971646,10971647,10971648,10971649,10971650,10971651,10971652,10971653,10971654,10971655,10971656,10971657,10971658,10971659,10971660,10971661,10971662,10971663,10971664,10971665,10971666,10971667,10971668,10971669,10971670,10971671,10971672,10971673,10971674,10971675,10971676,10971677,10971678,10971679,10971680,10971681,10971682,10971683,10971684,10971685,10971686,10971687,10971688,10971689,10971690,10971691,10971692,10971693,10971694,10971695,10971696,10971697,10971698,10971699,10971700,10971701,10971702,10971703,10971704,10971705,10971706,10971707,10971708,10971709,10971710,10971711,10971712,10971713,10971714,10971715,10971716,10971717,10971718,10971719,10971720,10971721,10971722,10971723,10971724,10971725,10971726,10971727,10971728,10971729,10971730,10971731,10971732,10971733,10971734,10971735,10971736,10971737,10971738,10971739,10971740,10971741,10971742,10971743,10971744,10971745,10971746,10971747,10971748,10971749,10971750,10971751,10971752,10971753,10971754,10971755,10971756,10971757,10971758,10971759,10971760,10971761,10971762,10971763,10971764,10971765,10971766,10971767,10971768,10971769,10971770,10971771,10971772,10971773,10971774,10971775,10971776,10971777,10971778,10971779,10971780,10971781,10971782,10971783,10971784,10971785,10971786,10971787,10971788,10971789,10971790,10971791,10971792,10971793,10971794,10971795,10971796,10971797,10971798,10971799,10971800,10971801,10971802,10971803,10971804,10971805,10971806,10971807,10971808,10971809,10971810,10971811,10971812,10971813,10971814,10971815,10971816,10971817,10971818,10971819,10971820,10971821,10971822,10971823,10971824,10971825,10971826,10971827,10971828,10971829,10971830,10971831,10971832,10971833,10971834,10971835,10971836,10971837,10971838,10971839,10971840,10971841,10971842,10971843,10971844,10971845,10971846,10971847,10971848,10971849,10971850,10971851,10971852,10971853,10971854,10971855,10971856,10971857,10971858,10971859,10971860,10971861,10971862,10971863,10971864,10971865,10971866,10971867,10971868,10971869,10971870,10971871,10971872,10971873,10971874,10971875,10971876,10971877,10971878,10971879,10971880,10971881,10971882,10971883,10971884,10971885,10971886,10971887,10971888,10971889,10971890,10971891,10971892,10971893,10971894,10971895,10971896,10971897,10971898,10971899,10971900,10971901,10971902,10971903,10971904,10971905,10971906,10971907,10971908,10971909,10971910,10971911,10971912,10971913,10971914,10971915,10971916,10971917,10971918,10971919,10971920,10971921,10971922,10971923,10971924,10971925,10971926,10971927,10971928,10971929,10971930,10971931,10971932,10971933,10971934,10971935,10971936,10971937,10971938,10971939,10971940,10971941,10971942,10971943,10971944,10971945,10971946,10971947,10971948,10971949,10971950,10971951,10971952,10971953,10971954,10971955,10971956,10971957,10971958,10971959,10971960,10971961,10971962,10971963,10971964,10971965,10971966,10971967,10971968,10971969,10971970,10971971,10971972,10971973,10971974,10971975,10971976,10971977,10971978,10971979,10971980,10971981,10971982,10971983,10971984,10971985,10971986,10971987,10971988,10971989,10971990,10971991,10971992,10971993,10971994,10971995,10971996,10971997,10971998,10971999,10972000,10972001,10972002,10972003,10972004,10972005,10972006,10972007,10972008,10972009,10972010,10972011,10972012,10972013,10972014,10972015,10972016,10972017,10972018,10972019,10972020,10972021,10972022,10972023,10972024,10972025,10972026,10972027,10972028,10972029,10972030,10972031,10972032,10972033,10972034,10972035,10972036,10972037,10972038,10972039,10972040,10972041,10972042,10972043,10972044,10972045,10972046,10972047,10972048,10972049,10972050,10972051,10972052,10972053,10972054,10972055,10972056,10972057,10972058,10972059,10972060,10972061,10972062,10972063,10972064,10972065,10972066,10972067,10972068,10972069,10972070,10972071,10972072,10972073,10972074,10972075,10972076,10972077,10972078,10972079,10972080,10972081,10972082,10972083,10972084,10972085,10972086,10972087,10972088,10972089,10972090,10972091,10972092,10972093,10972094,10972095,10972096,10972097,10972098,10972099,10972100,10972101,10971459,10971460,10971461,10971462,10971463,10971464,10971465,10971466,10971467,10971468,10971469,10971470,10971471,10971472,10971473,10971474,10971475,10971476,10971477,10971478,10971479,10971480,10971481,10971482,10971483,10971484,10971485,10971486,10971487,10971488,10971489,10971490,10971491,10971492,10971493,10971494,10971495,10971496,10971497,10971498,10971499,10971500,10971501,10971502,10971503,10971504,10971505,10971506,10971507,10971508,10971509,10971510,10971511,10971512,10971513,10971514,10971515,10971516,10971517,10971518,10971519,10971520,10971521,10971522,10971523,10971524,10971525,10971526,10971527,10971528,10971529,10971530,10971531,10971532,10971533,10971534,10971535,10971536,10971537,10971538,10971539,10971540,10971541,10971542,10971543,10971544,10971545,10971546,10971547,10971548,10971549,10971550,10971551,10971552,10971553,10971554,10971555,10971556,10971557,10971558,10971559,10971560,10971561,10971562,10971563,10971564,10971565,10971566,10971567,10971568,10971569,10971570,10971571,10971572,10971573,10971574,10971575,10971576,10971577,10971578,10971579,10971580,10971581,10971582,10971583,10971584,10971585,10971586,10971587,10971588,10971589,10971590,10971591,10971592,10971593,10971594,10971595,10971596,10971597,10971598,10971599,10971600,10971601,10971602,10971603,10971604,10971605,10971606,10971607,10971608,10971609,10971610,10971611,10971612,10971613,10971614,10971615,10971616,10971617,10971618,10971619,10620321,10620322,10620323,10620324,10620325,10620326,10930728,10930729,10930730,10930731,10930732,10930733,10930734,10930735,10930736,10930737,10930738,10930739,10930740,10930741,8863172,8863173,8863174,7056221,7056222,7056223,7056224,7056225,9176841,9176842,9176843,9176844,9176845,9176846,9176847,9176848,9176849,9176850,9176851,9176852,9176853,9176854,9176855,9176856,9176857,9176858,9176859,9176860,9176861,9176862,9176863,9176864,9176865,9176866,9176867,9176868,9176869,9176870,9176871,9176872,9176873,9176874,9176875,9176876,9176877,9176878,9176879,9176880,9176881,9176882,9176883,9176884,9176885,9176886,4971646,4971647,10166529,10166530,10166531,10166532,10166533,10166534,10166535,10166536,10166537,10166538,10166539,10166540,10166541,10166542,10166543,10166544,10166545,10166546,10166547,10166548,10166549,10166550,10166551,10166552,10166553,10166554,10166555,10166556,10166557,10166558,10166559,10166560,10166561,10166562,10166563,10166564,10166565,10166566,10166567,10166568,10166569,10166570,10166571,10166572,10166573,10166574,10166575,10166576,10166577,10166578,10166579,10166580,10166581,10166582,10166583,10166584,10166585,10166586,10166587,10166588,10166589,10166590,10166591,10166592,10166593,10166594,10166595,10166596,10166597,10166598,10166599,10166600,10166601,10166602,10166603,10166604,10166605,10166606,10166607,10166608,10166609,10166610,10166611,10166612,10166613,10166614,10166615,10166616,10166617,10166618,10166619,10166620,10166621,10166622,10166623,10166624,10166625,10166626,10166627,10166628,10166629,10166630,10166631,10166632,10166633,10166634,10166635,10166636,10166637,10166638,10166639,10166640,10166641,10166642,10166643,10166644,10166645,10166646,10166647,10166648,10166649,10166650,10166651,10166652,10166653,10166654,10166655,10166656,10166657,10166658,10166659,10166660,10166661,10166662,10166663,10166664,10166665,10166666,10166667,10166668,10166669,10166670,10166671,10166672,10166673,10166674,10166675,10166676,10166677,10166678,10166679,10166680,10166681,10166682,10166683,10166684,10166685,10166686,10166687,10166688,10166689,10166690,10166691,10166692,10166693,10166694,10166695,10166696,10166697,10166698,10166699,10166700,10166701,10166702,10166703,10166704,10166705,10166706,10166707,10166708,10166709,10166710,10166711,10166712,10166713,10166714,10166715,10166716,10166717,10166718,10166719,10166720,10166721,10166722,10166723,10166724,10166725,10166726,10166727,10166728,10166729,10166730,10166731,10166732,10166733,10166734,10166735,10166736,10166737,10166738,10166739,10166740,10166741,10166742,10166743,10166744,10166745,10166746,10166747,10166748,10166749,10166750,10166751,10166752,10166753,10166754,10166755,10166756,10166757,10166758,10166759,10166760,10166761,10166762,10166763,10166764,10166765,10166766,10166767,10166768,10166769,10166770,10166771,10166772,10166773,10166774,10166775,10166776,10166777,10166778,10166779,10166780,10166781,10166782,10166783,10166784,10166785,10166786,10166787,10166788,10166789,10166790,10166791,10166792,10166793,10166794,10166795,10166796,10478218,10478219,10478220,10478221,10478222,10478223,10478224,10478225,10478226,10478227,10478228,10478229,10478230) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'