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(10939647,8574521,10848641,10848653,10848654,8621459,8631278,8631279,8631280,8621471,8631281,8631282,8631283,8631284,8631285,8631480,10868247,9215645,8583479,8583488,7074192,10849559,10849560,8067423,10437433,8067749,10938630,11013730,11013731,8573343,8573344,10103267,7201526,7201529,10103560,7064520,10866807,10866808,10866856,10960308,11012364,11012365,11012366,11012378,11012479,11012509,11012510,11012511,11012515,11012516,11012517,11012518,11012519,11012545,11012546,11012547,11012548,11012549,11012550,10843687,10960653,10960654,10960655,10960656,10960657,10960658,10960659,10960660,10960661,10960662,10960663,10960664,10960665,11012758,11012837,8628818,8628819,8628820,8628821,8628822,8628823,8628824,8628825,8628826,8628836,8628837,7202504,11012959,11012960,11012961,11012977,11012978,11012979,11012980,11012981,4967517,4967523,11013010,11013011,11013012,11013013,11013014,11013015,11013029,11013030,10867670,10867671,10867672,10867673,10867674,10867675,7202716,8560472,8560474,8560475,11013332,11013473,11013616,7071227,7071229,10958966,10958967,8064354,7200645,7200707,10959365,8910891,10998519,8624655,8624657,8624659,10855440,8624945,7069301,11008998,11008999,11035023,3236285,11022930,8626063,3926972,10971280,10971281,10971285,10971440,10971441,8073533,11010608,10980633,10980634,10980635,10980636,10980637,10980638,10980639,10980640,10980641,10980642,10980643,11019644,10980644,11019645,10980645,10980646,10980647,10980648,10980649,7196213,11019677,10623061,3233527,7196440,8554209,8554214,8554217,8554221,8554260,10838107,10838108,10918928,8554401,7196937,7196951,7196952,8554788,10854135,8906905,8554809,8907097,8907098,8907099,10619144,10619145,8614031,3234863,10995142,10995143,7197708,10995154,10920183,10920184,10920185,10917526,10917527,10617035,8905106,10922699,7155756,10622267,10836996,10836998,11044991,10622409,10852704,10852705,10951721,10990793,10990794,10990795,10990796,10990797,10425552,3230618,10847953,10850489,10915933,3581941,10991258,10991291,10991292,10991297,10991298,7154475,10426344,10426345,10926703,10991862,10616302,10616303,10616304,10616305,10616306,10616311,10616312,10616313,10616314,10616315,10616316,10616321,10616323,10616324,10616326,8611271,8904520,10953199,10953200,10953210,10621575,8552531,8541143,10851999,10852000,10616791,8552725,8552727,10852120,10616889,10565158,9197462,9197463,9197464,8853317,8853318,8853332,9213516,8853343,8853387,6669783,10565445,10565446,10565447,10565448,10565449,9189653,9915872,8853543,8853547,10611406,10611407,10611408,10611412,10559622,9173837,9189844,10611567,7019643,6670322,6670344,6670345,6670346,6670347,6670357,6670358,6670359,9916376,8851174,6675556,9211384,8851213,8851235,8861980,8861981,8851299,8851314,8851378,8851392,8851405,8851406,9171590,9171591,9171592,7057799,10612326,10557529,10557530,8851546,8851548,9211791,3653012,9914027,7017775,7017776,10612823,10561108,10610303,10120852,8852610,8852611,8852613,8852615,8852617,8852621,8852624,8852625,7018480,7018490,9172919,10613648,8567515,9197097,9197098,6677340,8567793,8567794,8567795,8567796,10660160,9169483,8849331,9911799,10125997,9912097,9912098,7023673,9912321,9912322,9912323,6674352,3285809,10118382,9170263,9170264,9170265,9170266,9170267,9170268,9170269,9170270,9170271,9170272,9202289,10514114,10118499,10514115,10118663,8850351,3651836,6674908,6674963,8850651,8850674,8850678,8850683,8850696,8850697,8850710,8850743,8850748,8850755,8850760,8850773,8850782,8850794,8850801,8850802,8850804,8850814,8850823,8850939,8850942,8850943,8850947,8850948,8850951,8850952,8850956,8850961,8850963,8850964,8850965,8850967,8850968,8850974,8850975,8850979,8851033,8851040,10517042,10517043,10517044,10517045,10517046,10517047,10517048,10517049,10517050,10517051,8851063,10517052,8851064,10517053,10517054,10517055,8851067,10517056,10517057,10517058,10517059,10517060,10517061,10517062,10517063,10517064,10517065,7024907,10517066,10517067,10517068,10517069,10517070,10517071,10517072,10517073,10517074,10517075,10517076,10517077,10517078,10517079,10517080,10517081,10517082,10517083,10517084,10517085,10517086,10517087,10517088,10517089,10517090,10517091,10517092,10517093,10517094,10517095,10517096,7057450,8851111,8851112,8851120,6680606,9910682,9910683,9910684,9910685,7014149,7014150,9176546,4973434,9910872,9910874,10419671,10419672,9176807,10419733,9184853,8848848,8848849,8848850,10419109,9193263,8864988,10463065,8865024,10463081,10463090,8549825,10471476,9206947,9917174,10463750,10463756,10463768,10465774,10465775,10465778,10465779,10465796,10465798,10465800,10465857,10465912,10463917,10463918,6667451,10464041,9207665,10115929,10466313,10466314,10466315,10466338,10466357,10466391,10466400,10462447,10462454,10462455,10462484,9207912,9207913,9207914,8847782,8847784,10462536,9176038,10462615,6680303,10116393,9200266,9200298,10169576,10154630,10154631,10154632,10154633,10154634,10154649,10154650,10154651,10154652,10154653,10154654,10154655,10154670,10154671,10154672,10154673,10154674,10154675,10154676,10154677,10154678,10883672,10908675,10159798,10159799,10888884,10888900,10889134,10889135,10889136,10889158,10889167,10889230,10889231,10879266,10160306,10914482,10884604,10894657,10894658,10879869,10166318,10166319,10166320,10166321,10166322,10166323,10166334,10890345,10880384,10905427,10905428,10166449,10166455,10166456,10887654,10882732,10164003,10945812,10945813,10945814,10945815,10945816,10945817,10945818,10945819,10945830,10913275,10913276,10913277,10154397,10910704,10910705,10910706,10910707,10876096,10876097,10876098,10876099,10876112,10876113,10162280,10177447,10172540,10172541,10172542,10167969,10887196,10178232,10178233,10652363,10601353,10583485,10583486,10580527,10568685,10643893,10643900,10643901,10643902,10571927,10568953,10569045,10569046,10569047,10569048,10569049,10569052,10569053,10569054,10569055,10569056,10569057,10569058,10569059,10569060,10569061,10569243,10569244,10569245,10569246,10569247,10569248,10569249,10569250,10569251,10569252,10584254,10584255,10584256,10584257,10603217,10603220,10603244,10603245,10603246,10603247,10603248,10569512,10569558,10569559,10569566,10569567,10569568,10569569,10590621,10590622,10569746,10569747,10575854,10575855,10569864,10604042,10654253,10570653,10570654,10573800,10573801,10543209,10543210,10543211,10543212,10543213,10543214,10543215,10543216,10543217,10543218,10543219,10541358,10521653,10529718,10539842,10539843,10539844,10548138,10548139,10548140,10548141,10548142,10548143,10548144,10548145,10548146,10548147,10522258,10548395,10548396,10548397,10548398,10538917,10523075,10509523,10509524,10509525,10509526,10509527,10509528,10509529,10509530,10509531,10509532,10509533,10509534,10509535,10509536,10509537,10509538,10509539,10509540,10509541,10509542,10509543,10509544,10509545,10509546,10509547,10509548,10509549,10509550,10509551,10509552,10509553,10509554,10509555,10509556,10509557,10420848,8562621,8562622,8562623,10483422,10486837,10486838,10486839,10410615,10408673,10408674,10408768,10480433,10480434,10480435,10495495,10406902,10406915,10406916,10409099,10409100,10409101,10407143,10407144,10407145) 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'