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(10939584,10939588,10939593,10939598,10939599,10939600,10939601,10939617,10939618,10939619,10939620,10939651,10939711,10939712,10939737,10939738,10939739,10939740,10939741,10939742,10939874,10939897,10939898,10939899,10939910,10939911,4970688,4970700,4970745,10940163,10940171,10940193,10940194,10940256,10940257,10940343,10940345,10940386,10940400,4971054,4971055,4971056,4971057,4971058,10940466,4971060,4971061,4971062,10940477,10940483,10940484,10940485,10940532,4971143,8066960,8066961,8066976,4968300,4968301,4968302,4968303,8067069,4968321,4968322,4968323,4968330,4968331,4968332,4968333,4968334,4968405,4968406,4968407,4968408,8067375,8067473,8067474,8067478,8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067490,8067491,8067492,8067493,8067494,8067495,8067496,8067497,8067498,8067499,8067500,8067501,8067502,8067503,8067504,8067505,4968859,8067636,8067637,8067639,8067640,8067641,8067642,8067643,8067644,8067651,8067652,8067653,8067719,8067720,8067739,8067804,10938701,10938702,10938703,10938752,10938936,4969619,4969620,4969621,4969622,10939072,10939177,10939178,10939202,10939411,10939415,8064931,8064932,8064933,8064977,4967027,4967028,4967045,8065815,8065831,8065866,8065867,8065868,8065917,8065941,8065960,8065982,8066011,8066093,8066094,8066191,8066211,8066212,8066233,8066234,8066235,8066236,8066237,8066238,8066239,8066240,8066241,8066274,8066275,8066276,8066277,8066278,8066294,8066295,8066309,8066310,8066311,8066312,8066313,8066314,8066315,8066339,8066340,8066341,8066359,8066360,8066380,8066381,8066382,8066383,8066384,8066385,8066386,8066387,8066388,8066389,8066390,8066391,8066392,8066429,8066430,8066431,8066432,8066507,8066511,4967997,4967998,4967999,4968000,4968001,4968002,4968003,8064276,8064277,8064647,8064648,8064649,3655529,3655575,3656217,3656218,3656219,3656220,3656221,3656222,3656223,3656224,3656225,3656226,3656227,3656228,3656229,3656230,3656309,3656310,3656318,3656319,3656320,3656321,3656322,3656323,3656324,3656325,3656326,3656370,8072535,3656371,8072536,8072537,8072562,8072563,8072564,3656451,3656452,3656453,3656454,3656455,3656456,3656468,3656470,3656627,3656628,3656630,3656631,3656632,3656634,3656653,3656654,3656655,3656656,3656661,3656669,3656670,3656671,3656717,3656718,3656719,3656720,3656721,3656722,3656729,3656730,3656731,3656732,3656733,3656736,3656816,3656834,3656835,3656836,3656837,3656838,3656839,3656840,3656841,3656842,3656887,3656888,3656889,3656890,3656891,3656892,3656900,3656901,3656902,3656903,3656934,3656935,3656936,3656989,3656990,3656991,3656992,3656993,3656994,11049627,11049628,11049629,11049630,8073538,10918651,10918652,10918653,10918654,10918655,10918656,10918657,10918658,10918659,10918660,10918661,10918662,10918663,10918664,10918665,10918666,10918667,10918668,10918669,10918670,10918671,10918672,10918673,10918674,10918675,10918676,10918677,10918678,10918679,10918680,10918681,10918682,10918683,10918684,10918685,10918686,10918687,10918688,10918689,10918690,10918691,10918692,10918693,10918694,10918695,10918696,10918697,10918698,10918699,10918700,10918701,10623215,10918746,10918747,10918748,10918749,10918750,10918751,10918752,10918753,10918754,10918755,10918756,10918757,10918758,10918759,10918760,10918761,10918762,10918763,10918764,10918765,10918766,10918767,10918768,10918769,10918770,10918771,10918772,10918773,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10918783,10918784,10918785,10918786,10918787,10918788,10918789,10918790,10918791,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10918801,10918802,10918803,10918804,10918805,10918806,10918807,10918808,10918809,10918810,10918811,10918812,10918813,10918814,10918815,10918816,10918817,10918818,10918819,10918820,10918821,10918822,10918823,10918824,10918825,10918826,10918827,10918828,10918829,10918830,10918831,10918832,10918833,10918834,10918835,10918836,10918837,10918838,10918839,10918840,10918841,10918842,10918843,10918844,10918845,10918846,10918847,10918848,10918849,10918850,10918851,10918852,10918853,10918854,10918855,10918856,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,10918867,10918868,10918869,10918870,10918871,10918872,10918873,10918874,10918875,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10918884,10918885,10918886,10918887,10918888,10918889,10918890,10918891,10918892,10918893,10918894,10918895,10918896,10918897,10918898,10918899,10918900,10918901,10918902,10918903,10918904,10918905,10918906,10918907,10918908,10918909,10918910,10918911,10918912,10918913,10918914,10918915,10918916,10918917,10918918,10918919,10918920,10918921,10918922,10918923,10918924,10918925,10918926,10918927,10918928,10918929,10918930,10918931,10918932,10918933,10918934,10918935,10918936,10918937,10918938,10918939,10918940,10918941,10918942,10918943,10918944,10918945,10918946,10918947,10918948,10918949,10918950,10918951,10918952,10918953,10918954,10918955,10918956,10918957,10918958,10918959,10918960,10918961,10918962,10918963,10918964,10918965,10918966,10918967,10918968,10918969,10918970,10918971,10918972,10918973,10918974,10918975,10918976,10918977,10918978,10918979,10918980,10918981,10918982,10918983,10918984,10918985,10918986,10918987,10918988,10918989,10918990,10918991,10918992,10918993,10918994,10918995,10918996,10918997,10918998,10918999,10919000,10919001,10919002,10919003,10919004,10919005,10919006,10919007,10919008,10919009,10919010,10919011,10919012,10919013,10919014,10919015,10919016,10919017,10919018,10919019,10919020,10919021,10919022,10919023,10919024,10919025,10919026,10919027,10919028,10919029,10919030,10919031,10919032,10919033,10919034,10919035,10919036,10919037,10919038,10919039,10919040,10919041,10919042,10919043,10919044,10919045,10919046,10919047,10919048,10623658,10623788,10623789,10624356,10624357,10624658,10621979,10621980,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622049,10622050,10622057,10622059,10622061,10622062,10622063,10622064,10622065,10622066,10622074,10622075,10622076,10622088,10622089,10622116,10622117,10622118,10622119,10622120,10622197,10622263,10622306,10622325,10622329,10622330,10622337,10622338,10622341,10622351,10622352,10622354,10622356,10622359,10622364,10622385,10622397,10622405,10622427,10622429,10622430,10622544,10622545,10622916,10619985,10619986,10619999,10620000,10620001,10620012,10620029,10620056,10620057,10620058,10620059,10620096,10620106,10620202,10620323,10620324,10620328,10620329,10620353,10620354,10620357,10620361,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620414,10620458,10620487,10620548,10620559,10620767,10620768,10621077,10621078,10621082,10621110,10621111,10621112,10621115,10621247,10621248,10621249,10621250,10621251,10621269,10621294,10621295,10621310,10621311,10621312,10621313,10621314,10621315,10621341,10621342,10621381,10621382,10621383,10621384,10621385,10621572,10621573,10621574,10621583,10621595,10621637,10621668,10621669,10565147,10565154,10565189,10565331,10565332,10565333,10565334,10565338,10565339,10565340,10565341,10565342,10565608,10565609,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10565648,10565700,10565712,10565713,10565714,10565715,10565716,10565717,10565718,10565859,10565860,10565861,10565862,10565863,10565864,10565865,10565866,10565867,10565868,10565869,10565870,10565871,10565872,10565873,10565874,10565877,10565885,10565886,10565887,10565888,10565889,10565890,10565891,10565892,10565927,10565937,10565938,10565957,10565958,10565959,10565963,10565964,10565965,10565966,10565967,10565968,10565969,10565970,10565971,10565972,10565973,10565974,10565975,10565976,10565977,10565978,10566006,10566007,10566008,10566013,10566016,10566017,10566018,10566019,10566020,10566021,10566022,10566023,10566039,10566057,10566063,10566064,10566065,10566073,10566074,10566075,10566084,10566095,10566096,10563603,10563604,10517242,10517243,10517256,10517257,10517258,10517309,10517310,10517317,10517318,10517325,10517660,10517661,10517662,10517663,10517664,10517665,10517666,10517667,10517668,10517670,10517671,10517682,10517683,10517684,10419287,10419288,10419404,10419436,10419462,10419568,10419681,10419682,10419693,10419698,10419699,10419700,10419701,10419702,10419829,10419831,10419894,10419904,10419911,10419925,10419929,10420014,10420039,10420056,10420058,10420066,10420072,10420104,10420105,10420108,10420109,10420110,10420160,10420161,10420171,10420172,10420178,10420179,10420206,10471033,10471128,10471132,10471219,10471537,10469911,10469957,10470194,10470345,10470346,10470347,10470355,10470647,10470648,10470729,10470770,10470781) 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'