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(10858870,8628257,8628260,10843625,7202352,10859526,10859527,10859528,10859529,8573049,8573062,8573067,8067938,8910580,8910593,8910594,7200795,7201077,10103159,8908521,7198731,7198746,7198751,7198767,10855896,8626239,10196489,10857106,10857115,10857116,7200578,8907412,7197604,8624473,8908276,3232891,3232892,10853070,10853071,10853072,10853073,10853257,10853259,3923424,3923473,10866577,10866578,10866604,7196610,10866900,10866901,8613644,10867288,10867289,10867290,10838921,10838922,10838923,10838924,10850644,10850646,10425910,8633276,8633277,10863923,10848536,10864263,10864283,10864288,10864343,10864365,10864373,8540635,8540636,10864436,3231591,8904317,8904320,8611308,10851958,10851959,10851960,10851961,10851962,10851963,10851964,10851965,10865031,10865032,10865033,10865034,10865035,10865036,10865037,8634698,8634699,8634703,8634704,8634705,8634706,8634707,8634708,8634709,8634710,8634711,8634714,8634798,8634799,8634800,8634801,8634802,8634803,8634804,8634805,8634806,8634807,8634808,8634809,8634810,8634811,10852494,10852497,10852499,10852502,10617151,10862979,8575870,8575871,10622424,9216841,9216845,9216849,10425591,10190005,10860797,10615411,10615598,10615602,10615608,10615609,10615616,10615617,10615647,10615651,10615664,10615666,10615669,8630795,8630796,8630797,8630800,8630803,8630833,8630834,8630835,8574467,8574469,8574474,8574489,8574491,8574495,8574498,8574511,8574513,8574514,8574519,8574523,10861712,8583128,10861959,10616334,10616335,10616336,10616337,10616338,10616339,10616340,10616341,10616342,10616343,10616344,10616345,10616346,10616347,10616348,10616349,10616350,10616351,10616352,10616353,10616354,10616355,10616356,10616357,10616358,10616359,10616360,10616361,10616362,10616363,10616364,10616365,10616366,10616367,10616368,10616369,10616370,10616371,3229178,8631677,8631678,8631679,8631691,8583524,8631716,8631735,8631736,8631737,8631738,8631739,8631740,8631741,8631742,8631743,8631744,8631745,10431685,10849428,10849429,10849436,8631863,8631864,8631865,8631866,10616942,10616943,8853317,8853324,8853361,10714021,8853369,8853381,8853386,8853395,10614503,10614504,10122062,10614690,10614691,10614695,10614702,10614710,10614711,10614713,10614714,8851124,8851125,8851126,8851127,8851128,8851129,8851130,8851131,8851132,8851133,8851134,8851135,8851136,8851137,8851138,8851139,8851140,8851141,8851142,8851143,8851144,8851145,8851146,8851147,8851148,8851149,8851150,8851151,8851152,8851153,8851154,8851155,8851156,8851157,8851158,8851159,8851160,8851161,8851162,8851163,8851164,8851165,8851166,8851167,8851168,8851169,8851170,8851171,8851172,8851173,8851174,8851175,8851176,8851177,8851178,8851179,8851180,8851181,8851182,8851183,8851184,8851185,8851186,8851187,8851188,8851189,8851190,8851191,8851192,8851193,8851194,8851195,8851196,8851197,8851198,8851199,8851200,8851201,8851202,8851203,8851204,8851205,8851206,8851207,8851208,8851209,8851210,8851211,8851212,8851213,8851214,8851215,8851216,8851217,8851218,8851219,8851220,8851221,8851222,8851223,8851224,8851225,8851226,8851227,8851228,8851229,8851230,8851231,8851232,8851233,8851234,8851235,8851236,8851237,8851238,8851239,8851240,8851241,8851242,8851243,8851244,8851245,8851246,8851247,8851248,8851249,8851250,8851251,8851252,8851253,8851254,8851255,8851256,8851257,8851258,8851259,8851260,8851261,8851262,10612320,10612321,8566542,8852017,8852225,10613193,8852391,10613326,8852631,8852632,8852633,8852634,8852635,8852636,8852637,8852638,8852639,8852640,8852641,8852642,8852643,10939393,10117604,10117650,10117651,10117654,9169923,6674168,6674248,8849893,8065847,9912545,9912838,9913051,9913052,8565743,8565744,8565745,8565747,8851121,8851122,8851123,9910590,6672598,10418316,10418317,10418318,10418319,10418320,10418321,10418322,10116736,6672770,10419487,10416544,10417594,10417612,9160691,9160692,10417616,9160705,9160706,10417661,10417685,10417693,10417747,8848664,8848674,10419780,10419781,6673224,6673231,8848862,9911271,10420114,10420115,10420116,9166406,10467067,10469533,10469534,10467917,9168015,9168017,10470671,8848001,10908624,10908625,10888672,10883675,10888697,10888709,10889253,10884393,10889481,10884499,10890166,10877572,10632107,10632108,10882657,10882660,10945485,10882958,10887989,10886123,10876814,10882025,10882026,10611520,10611521,10611522,10611523,10611524,10611525,10611526,10611527,10611528,10611529,10611530,10611531,10611532,10611533,10611534,10611535,10611536,10611537,10611538,10611539,10611540,10611541,10611542,10611543,10611544,10611545,10611546,10611547,10608547,10611548,10611549,10608549,10608550,10611550,10611551,10611552,10611553,10611554,10611555,10611556,10611557,10611558,10611559,10611560,10611561,10611562,10611563,10611564,10611565,10611566,10611567,10611568,10611569,10611570,10611571,10611641,10611681,10602859,10602990,10602991,10590192,10647424,10609392,10603874,10610014,10610025,10610690,10610736,10610737,10610738,10498250,10498251,10498252,10508262,10508263,10508452,10415583,10507626,10507662,10507902,10508013,10409307,10409308,10409309,10409310,10413399,10413403,10409448,10483192,10494354,10494355,10494356,10407916,10407918,10411944,10413982,10413983,10413984,10413985,10486641,10486672,10410171,10408643,10408644,10408645,10408646,10408647,10408648,10408649,10408650,10408962,10408965,10408967,10408970,10407025,10407026,10407032) 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'