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(10939590,10939737,10939746,10940186,10940187,10940188,10940189,10940190,10940343,10940345,10940347,10940350,10940413,10940414,10940420,10940421,10940429,10940462,10940463,10940464,10940469,10940481,10940482,10940489,10940513,10940515,10940521,10940522,10940524,10940531,4971138,8066938,8066940,8066941,8066942,8066943,8066944,8066945,8066946,8066948,8066949,8066954,8066955,8066956,8066957,8066958,8066959,8066964,8067174,8067183,8067184,8067324,8067325,8067519,8067639,8067640,8067642,8067643,8067645,8067646,8067647,8067648,8067651,10437557,8067961,8067962,8067963,8067964,8067965,8067966,8068000,8068001,8068003,8068004,8068005,8068006,8068007,8068008,8068009,8068010,8068011,8068012,8068026,8068027,8068028,8068029,8068031,8068043,8068075,8068076,8068077,8068078,8068079,8068080,8068081,8068082,8068083,8068084,8068085,8068139,8068141,8068143,8068144,8068145,8068146,8068147,8068148,8068149,8068150,8068151,8068152,8068154,8068155,8068156,8068157,8068158,8068159,8068161,8068162,8068163,8068164,8068166,8068167,8068168,8068169,8068170,8068180,8068256,8068259,8068260,8068261,8068263,8068264,8068266,8068301,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8068318,8068319,8068320,8068321,8068322,8068323,8068325,8068326,8068329,8068330,8068331,8068332,8068333,8068352,8068365,8068370,8068399,8068400,8068401,8068402,8068403,8068404,8068405,8068406,8068413,8068419,8068426,8068438,8068494,8068515,8068524,8068525,8068526,8068527,8068528,8068584,8068594,8068603,8068604,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,10939380,10939381,8068680,8068681,8068683,8068685,8068686,8068697,8068700,8068701,8068702,8068703,8068715,8068746,8068747,8068761,8068762,8068763,8068764,8068765,8068766,10931959,8065636,8066166,10932571,8066214,8066216,8066224,8066225,8066226,8066227,8066228,8066229,8066230,8066254,8066255,8066256,8066257,8066260,8066261,8066272,8066289,8066292,8066293,8066296,8066305,8066308,8066328,8066329,8066330,8066331,8066332,8066333,8066334,8066335,8066336,8066337,8066354,8066357,8066369,8066370,8066371,8066372,8066373,8066374,8066375,8066377,8066421,8066422,8066423,8066424,8066429,8066433,8066507,8066508,8066509,8066510,8066512,8066556,8066562,8066564,8066565,8066566,8066567,8066568,8066569,8066570,8066572,8066573,8066574,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066637,8066639,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066650,8066651,8066652,8066653,8066656,8066657,8066658,8066758,8066759,8066760,8066761,8066762,8066767,8066807,8066820,8066821,8066823,8066830,8066832,8066884,8066889,8066894,8066896,8066897,8066908,8066909,8066910,10942928,10942932,10942937,10942940,10942941,10942943,10942944,10942945,10943049,10943062,10943073,10943135,10943142,10943150,10943151,8064533,8064542,10940562,10940709,10940712,10940713,10940715,10940727,10940840,10941053,3656451,3656454,8072674,8072675,8072676,8072677,10941696,10941699,10941713,3656661,10941724,10941725,10941752,10941753,10941838,8073505,11049621,10942437,10918574,10923634,10923638,10923645,10923646,10923647,10923648,10923649,10923650,10923651,10923652,10923653,10923654,10923657,10923658,10923659,10923660,10923661,10923666,10923667,10923668,10923670,10923671,10923672,10923673,10923680,10923681,10923685,10923686,10923687,10923688,10923689,10923690,10923691,10923692,10923693,10923698,10923699,10918700,10923700,10923701,10923702,10923703,10923704,10923705,10923708,10923709,10923710,10923711,10923712,10923713,10918713,10923714,10923721,10923722,10923723,10923724,10923725,10923726,10918726,10923727,10923728,10923729,10923730,10923731,10923734,10923735,10923736,10923737,10923742,10918742,10923743,10923753,10923754,10923755,10923756,10923757,10923759,10923760,10923761,10923762,10623257,10923772,10923773,10923774,10923775,10923778,10923779,10923780,10923781,10923784,10923785,10923786,10923787,10923788,10923789,10923790,10923791,10923797,10923798,10923799,10923801,10923802,10923803,10923804,10923805,10923806,10923807,10923811,10923812,10923814,10923815,10923816,10923818,10923819,10923820,10923821,10923822,10923823,10923824,10923825,10923826,10923829,10923830,10923833,10923834,10923837,10923843,10923847,10923848,10923849,10923851,10923852,10923854,10923855,10923856,10923858,10923860,10923862,10923864,10923865,10923866,10923873,10923874,10923875,10923876,10923877,10923878,10923879,10923880,10923881,10923882,10923883,10923884,10923887,10923888,10923889,10923890,10923904,10923905,10923906,10923907,10923914,10923915,10923916,10923917,10923918,10923919,10923924,10923925,10923927,10923928,10923929,10923930,10923932,10923933,10923936,10623491,10919207,10919506,10919507,10919508,10919564,10919887,10919895,10919913,10917474,10917475,10917476,10917477,10917478,10917480,10917481,10917482,10917483,10917484,10917485,10917486,10621979,10621990,10621991,10621992,10622014,10622106,10622107,10622108,10622109,10622110,10622125,10622131,10917704,10917705,10917706,10917707,10917708,10917709,10917730,10917731,10917732,10917733,10917852,10917853,10917854,10917855,10917856,10917857,10917858,10917859,10917860,10917861,10917862,10917863,10917864,10917865,10917866,10917867,10917868,10917869,10917870,10917871,10917872,10917873,10917874,10917875,10619965,10620072,10915629,10915630,10915631,10915632,10915633,10915634,10915635,10915636,10915637,10915638,10915639,10915640,10915641,10915642,10915643,10915644,10915645,10915646,10915647,10915648,10915649,10915650,10915652,10915653,10915654,10915655,10915656,10915657,10915658,10915659,10915660,10915661,10915662,10915663,10915664,10915665,10915666,10915667,10915668,10915669,10620373,10620374,10620377,10620378,10620528,10621124,10621147,10621148,10621161,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621258,10621260,10621264,10621267,10621281,10621292,10621293,10621305,10621306,10621307,10621308,10621309,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621386,10621390,10621396,10621427,10621428,10621429,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10917001,10621496,10621500,10621501,10917027,10917028,10917029,10621529,10621530,10621531,10621532,10621543,10917057,10917058,10917059,10917060,10917061,10917062,10917063,10917064,10917065,10621571,10621573,10621581,10621582,10621589,10621594,10621634,10621657,10621658,10621659,10621661,10621663,10621664,10621665,10621666,10621689,10621692,10621693,10621694,10621701,10621704,10621705,10621708,10621710,10621713,10621714,10621715,10621735,10621745,10917420,10917421,10917422,10565316,10565317,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10611386,10565536,10565537,10611387,10565538,10611388,10565539,10611389,10565540,10611390,10565541,10611391,10565542,10611392,10565543,10565544,10565545,10565546,10565547,10565548,10611406,10611407,10611408,10611438,10611440,10611441,10611476,10611477,10611486,10611497,10611504,10611506,10611507,10611508,10611559,10611567,10611604,10611615,10611657,10611658,10609313,10563827,10563828,10563829,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10609870,10609984,10610780,10610781,10610791,10517149,10517150,10555350,10555351,10555354,10555424,10517592,10517683,10517684,10555831,10556291,10556292,10556293,10556294,10556531,10556532,10556533,10556534,10415269,10415270,10415271,10415272,10415483,10419917,10416087,10416088,10416128,10416129,10420157,10420158,10416158,10470990,10463027,10463031,10463034,10463043,10463044,10463324,10463340,10463360,10463396,10463398,10463430,10463653,10463731,10463748,10463749,10463750,10463751,10463752,10463753,10463758,10463759,10463763,10463772,10463780,10463782,10463783,10463784,10463785,10463786,10463787,10463789,10463806,10463826,10463832,8563415,10462398,10462409,10462411,10462412,10462413,10462427,10462431,10462434,10462435,10462438,10462439,10462462,10462463,10462484,10462485,10462488,10462491,10462492,10462493,10462494,10462496,10462497,10462498,10462500,10462501,10462502,10462504,10462505,10462518,10462585,10462586,10462587,10462588,10462589,10462590,10462591,10462592,10462593,10462594,10462595,10462596,10462597,10462598,10462607,10462612,10462724,10462725) 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'