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(10861808,10861813,10861814,10861815,3228943,10861820,10861821,10861826,10861829,3229036,10862014,7065982,10860223,10860224,10860225,10860226,10860227,10860228,10860229,10860230,10860231,10860232,10860233,10860234,10860235,10860236,10860237,10860238,10860239,10860240,10860241,8573239,8573240,8573241,10860724,7201491,7201510,10866625,10866626,10866627,7201843,7201846,8065799,5654562,10860136,10860137,10860138,10860139,10860140,10860141,10860142,10860143,10860144,10860145,10860146,10860147,10860148,10860149,10860150,10860151,10860152,10860153,10860154,10860155,10860156,10860157,10860158,10860159,10860160,10860161,10860162,10860163,10860164,10860165,10860166,10860167,10860168,10860169,10860170,10860171,10860172,10860173,10860174,10860175,10860176,10860177,10860178,10860179,10860180,10860181,10860182,10860183,10860184,10860185,10860186,10860187,10860188,10860189,10860190,10860191,10860192,10860193,10860194,10860195,10860196,10860197,10868197,10868198,10860198,10860199,10868199,10860200,10868200,10860201,10868201,10868202,10860202,10860203,7065916,10860204,7065917,10860205,10860206,10860207,10860208,10860209,10860210,10860211,10860212,10860213,10860214,10860215,10860216,10860217,10860218,10860219,10860220,10860221,10860222,10857283,8626822,8626823,8626824,8626825,8626826,10863837,10863840,10863841,8625273,8625274,8625275,8625276,10864604,10864606,10864609,10864612,10864614,10101456,10864615,10864616,10864617,10864618,10864621,10864627,10864632,10864633,10864634,10864635,10864636,10864637,10864638,10864639,7199778,7199861,7199862,7199863,7199864,7199865,7199866,7199867,7199868,10853404,10853461,7197238,7197239,7197240,7197241,7197242,7197243,7197244,7197245,10854368,10854369,10854370,10854371,10854372,10854373,10854374,10854375,10854376,10854377,10854378,10854379,10854380,10854381,10854382,10854383,10854384,10854385,10854386,10854387,10854388,10854389,10854390,10854391,10854392,10854393,10854394,10854395,10854396,10854397,10854398,10854399,10854400,10854401,10854402,10854403,10854404,10854405,10854406,10854407,10854408,10838937,8624259,3235073,3235074,3235075,10855095,10855096,10855097,10855098,10855099,10855100,10855101,10855102,8905062,8905063,8905064,8905065,10622197,3581883,10616003,10616047,8540600,8611288,8611445,10714114,10122049,10122050,10122051,10614571,10612228,10609375,8566536,10609837,10609838,10609839,10609840,10609841,10609842,10609843,10609844,10609845,10610116,10610117,10610118,10610119,10610120,10610121,10610122,10610123,10610124,10610125,10610126,10613290,10613291,10613292,10117534,10117535,10117536,10117537,10117538,10117539,10117540,9169498,9169499,9911797,9911798,9911799,9911800,9911801,9911802,9911803,9911804,9911805,9911806,9911807,9911879,9911880,9911881,9911882,9911883,9911884,10118151,10118383,8850120,8850121,10118593,9912638,9168363,10417287,10417289,10417291,10417292,6672600,6672653,6672654,6672655,6672656,6672657,6672658,10419504,10415656,10415661,10415662,10415663,10415666,10415671,10415674,10417920,10417924,10417928,10417936,10417940,10417941,10417942,10417943,10417944,10417945,9169031,9169032,9169033,10117397,10117398,10117399,10117493,8550085,8550087,10467601,10467602,10467603,10467767,10467768,10467769,10467770,10467771,10469967,10469968,10469969,10469970,10469971,10469972,10469973,10469974,10469975,10469976,10469977,10469978,10469979,10469980,10469981,10469982,10469983,10469984,10469985,10469986,10469987,10469988,10469989,10469990,10469991,10469992,10469993,10469994,10469995,10469996,10469997,10469998,10469999,10470000,10470001,10470002,10470003,10470004,10470005,10470006,10470007,10470008,10470009,10470010,10470011,10470012,10470013,10470014,10470015,10470016,10470017,10470018,10470019,10470020,10470021,10470022,10470023,10470024,10470025,10470026,10470027,10470028,10470029,10470030,10470031,10470032,10470033,10470034,10470035,10470036,10470037,10470038,10470039,10470040,10470041,10470042,10470043,10470044,10470045,10470046,10470047,10470048,10470049,10470050,10470051,10470052,10470053,10470054,10470055,10470056,10470057,976430,976446,976447,976448,976449,976450,976451,976530,976531,9167818,9167819,9167820,9167821,9167822,9167823,9167824,9167825,9167826,9167827,9167828,9167829,9167830,9167903,9167904,9168012,9168016,9168017,9168018,10889134,10889135,10889136,10889137,10889138,10889139,10889140,10889141,10889142,10889143,10889144,10889145,10889146,10887661,10882895,10882896,10882897,10882898,10882899,10882900,10883215,10883216,10883217,10883218,10883219,10883220,10883221,10627776,10888444,10888445,10647347,10647348,10647361,10647362,10647363,10647364,10647365,10647537,10647538,10508345,10420798,10420799,10420800,10420801,10420802,10420803,10507805,10508046,10409561,10409606,10410098,10410099,10410100,10410101,10410102,10410103,10410104,10410105,10410106,10410107,10410108,10410109,10410110,10410111,10410112,10410113,10410114,10410115,10410116,10410117,10410118,10410119,10410120,10410121,10410122,10410123,10496779,10410124,10410125,10410126,10410127,10410128,10410129,10410130,10410131,10410132,10410133,10410296,10410297,10410298,10410299,10410300,10410301,10410302,10410303,10410304,10414522,10414523,10414524,10414525,10414526,10414527,10414528,10414529,10414530,10414531,10414532,10414533,10414534,10414535,10414536,10414537,10414538,10414539,10414540,10414541,10414542,10414543,10414544,10414545,10414546,10414547,10414548,10414549,10414550,10414551,10414552,10414553,10414554,10414555,10414556,10414557,10414558,10414559,10414560,10414561,10414562,10414563,10414564,10414565,10414566,10414567,10414568,10414569,10414570,10414571,10414572,10414573,10414574,10414575,10414576,10414577,10414578,10414579,10414580,10414581,10414582,10414583,10414584,10414585,10414586,10414587,10414588,10414589,10414590,10414591,10414592,10414593,10414594,10414595,10414596,10414597,10414598,10414599,10414600,10414601,10414602,10414603,10414604,10414605,10414606,10414607,10414608,10414609,10414610,10414611,10414612,10414613,10414614,10414615,10414961) 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'