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(10263074,10263075,10263076,10263077,8628342,7076299,10859454,8569695,7065967,7066733,10251993,10251994,10251995,10251996,10251997,10251998,10197055,7067554,7067555,8594725,10221061,10221062,10221063,10221064,10221065,10221066,10221067,10221068,10221069,10221070,10221071,10221072,10221073,10221074,10221075,10221076,10221077,10221078,10221079,10221080,10221081,10221082,10221083,10221084,10856367,10856368,10856371,10856372,10856373,10856374,10856375,10856376,10856377,10856378,10856379,10856380,10856384,10856386,10856387,10856388,10856389,10856390,10856393,10856394,10856396,10856397,10856404,10856405,10856406,10856407,10856408,10856409,10856410,10856411,10856412,10856413,10856414,10856415,10856416,10856426,10856443,10856450,10856456,10856457,10856458,10856459,10856461,10856462,10856463,10856464,10856465,10856466,10856473,10856474,10856476,10856477,10856478,10856479,10856480,10856481,10856482,10856487,10248884,10870460,10272135,7070949,3924928,8614419,10867995,8624478,10839666,10207748,3925486,7071631,7071632,7071633,7071634,8615062,8615092,8542205,10218501,10853074,8612640,10231566,10231567,8907071,7157724,7070746,7070747,10863768,10229268,10229269,10229270,10229271,10229272,10229273,10229274,10229275,10229276,10229277,10229278,10229279,10229280,10229281,10229282,10229283,10229284,10229285,10229286,10229287,10229288,10229289,10229290,10229291,10229292,10229293,10229294,10229295,10229296,10229297,10229298,10850886,10850887,10850888,10850889,10850890,10850891,10850892,10850893,10850894,10850895,10850896,10850897,10850898,10850899,10850900,10850901,10850902,10850903,10850904,10850905,10850906,10850907,10850908,10850909,10850910,10850911,10850912,10850913,10850914,10850915,10850916,10850917,10850918,10850919,10850920,10850921,10850922,10850923,10850924,10850925,10850926,10850927,10850928,10850929,10850930,10850931,10850933,10850934,10850935,10850936,10850937,10850938,10850939,10850940,10850941,10850942,10850943,8576905,9217764,8611294,8611462,8541158,10243630,10243631,8541634,3230239,3230240,3230241,3230242,10850223,10850224,10850225,10850226,10850227,10850228,10850229,10850230,10850231,10850232,10850233,10850234,10850235,10850236,10850237,10850238,10850239,10850240,10850241,10850242,10850243,10850244,10850245,10850246,10850247,10850248,10850249,10850250,10850251,10850252,10850253,10850254,10850255,10850256,10850257,10850258,10850259,10850260,10850261,10850262,10850263,10850264,10850265,10850266,10850267,10850268,10850269,10850270,10850285,10850306,10850307,10850308,10850309,10850310,10850311,10850312,10850313,10850314,10850315,10850316,10850317,10850318,10850319,10850320,10850321,10850322,10850323,10850324,10850325,10850326,10850327,10850328,10850329,10850330,10850331,10850332,10850333,10850334,10850335,10850339,10850340,10850341,10850342,10850343,10850344,10850345,10850346,10850347,10850348,10850349,10850350,10850351,10850352,10850353,10850354,10850355,10850356,10850357,10850358,10850359,10850360,10850361,10850362,10850363,10850364,10850365,10850452,10622878,10447604,10213502,10213503,9214583,9214584,10616048,10616049,8575080,10201710,10201711,10201712,10201713,10201714,10201715,10714365,9181904,9181905,9181906,9181907,8542534,10119575,9171778,8851704,10563701,10563702,10563703,10563704,10563705,10563706,10563707,10563708,10563823,10563824,10563825,10612754,10563942,10563943,10563944,9172177,9172178,9172179,9172180,9172181,10564146,10564147,10564148,10564149,10564150,10564151,10564152,10564153,10564154,8862911,3653831,9204742,9915073,4974170,10117717,10117719,10117720,10117728,9185697,9185698,9185699,9185700,9185701,9185702,9185703,9185704,9185705,9185706,9185707,9185708,9185709,9185710,9185711,9185712,9185713,9185714,8849705,8849706,10513911,10513912,10514209,10514210,10514211,10514212,10514213,10514214,10514215,10514216,10514217,8850548,9202914,10417232,8848304,6680933,7014936,7014937,7014938,7014939,7014940,7014941,7014942,7014943,7014944,7014945,7014946,7014947,6670687,6670853,9182823,6666828,9175071,9175072,9175073,9175074,9175075,9175076,9175077,9175078,6667153,6667154,6679425,3963628,6679771,8917237,6679804,10115983,10116224,10116227,10116228,10116229,10116230,8593493,10903589,10170203,10170204,10884206,10884207,10170677,10170678,10899858,10899859,10899860,10899861,10899862,10170920,10885464,10877480,10877481,10877482,10877483,10877484,10877485,10877486,10877487,10917723,10917724,10917725,10917726,10183864,10183865,10915587,10915588,10915589,10915590,10915591,10906089,10906090,10906091,10906092,10172204,10876480,10876481,10626312,10626313,10177856,10177857,10917050,10183428,10611154,10598870,10598871,10598872,10598873,10598874,10598875,10573240,10610095,10604385,10648681,10648682,10533204,10533205,10533206,10533207,10533208,10533209,10521349,10521350,10533695,10529991,10529992,10529993,10529994,10529995,10529996,10529997,10529998,10529999,10530000,10530001,10530002,10530003,10530004,10530005,10530006,10530007,10530008,10530009,10530010,10530011,10530012,10530013,10530014,10530015,10530016,10530017,10530018,10530019,10530020,10530021,10530022,10530023,10530024,10530025,10530026,10530027,10530028,10530029,10530030,10530031,10530032,10530033,10530034,10530035,10530036,10530037,10530038,10530039,10530040,10530041,10530042,10530043,10530044,10530045,10530046,10530047,10530048,10530049,10530050,10530051,10530052,10530053,10530054,10530055,10530056,10530057,10530058,10530059,10422170,10411413,10411414,10411418,10411419,10411420,10411421,10411422,10411423,10411424,10411425,10411426,10411428,10411430,10411431,10411432,10411433,10411436,10411437,10411439,10411440,10411444,10411445,10411446,10411447,10411448,10411449,10411450,10411451,10411452,10411453,10411454,10411455,10411465,10411481,10411488,10411495,10411496,10411497,10411500,10411501,10411502,10411503,10411504,10411505,10411510,10411511,10411513,10411514,10411515,10411516,10411517,10411518,10411519,10411520,10411521,10411525,10407584,10407585,10407586,10407587,10407588,10407589,10407590,10407591,10407592,10407593,10407594,10407595,10407596,10407597,10407598,10407599,10407600,10407601,10407602,10407603,10407604,10407605,10407606,10407607,10407608,10407609,10407610,10407611,10407612,10407613,10407614,10407615,10407616,10407617,10407618,10407619,10407620,10407621,10407622,10407623,10407624,10407625,10407626,10407627,10407628,10407629,10407630,10407631,10407632,10407633,10407634,10407651,10407675,10407676,10407677,10407678,10407679,10407680,10407681,10407682,10407683,10407684,10407685,10407686,10407687,10407688,10407689,10407690,10407691,10407692,10407693,10407694,10407695,10407696,10407697,10407698,10407699,10407700,10407701,10407702,10407706,10407707,10407708,10407709,10407710,10407711,10407712,10407713,10407714,10407715,10407716,10407717,10407718,10407719,10407720,10407721,10407722,10407723,10407724,10407725,10407726,10407727,10407728,10407729,10407730,10407731,10407732,10407733,10408086,10408087,10408088,10408089,10408090,10408091,10408092,10408093,10408094,10408095,10408096,10408097,10408098,10408099,10408100,10408101,10408102,10408103,10408104,10408105,10408106,10408107,10408108,10408109,10408110,10408111,10408112,10408113,10408114,10408115,10408116,10408117,10408118,10408119,10408120,10408121,10408122,10408123,10408124,10408125,10408126,10408127,10408128,10408129,10408131,10408132,10408133,10408134,10408135,10408136,10408137,10408138,10408139,10408140,10408141,10408142) 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'