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(7201648,10858850,10858851,8595288,7202108,7202109,7202110,7202111,7202112,7202113,7202114,7202115,10859161,10859162,10859279,10859286,10859288,10859457,7202707,7202708,7202709,7202710,10859992,10859993,10859994,7066209,7066248,7066249,7066250,7066266,10860085,10860086,10860101,10860105,10860106,10860131,10860132,3227423,10860406,8573332,8910452,8067919,7201361,7201362,7201363,7201364,3235778,7198693,7199666,7199667,7199668,7199669,7199670,7199671,7199672,7199673,7199674,7199675,7199676,7199677,7199678,7199679,7199680,7199681,7199682,7199683,7199684,7199685,7199686,7199687,7199688,7199689,7199690,7199691,7199692,7199693,7199694,7199695,10101580,7199696,7199697,7199698,7199699,7199700,7199701,7199702,7199703,7199704,7199705,7199706,7199707,7199708,7199709,7199710,7199711,7199712,7199713,7199714,7199715,7199716,7199717,7199718,7199719,7199720,7199721,7199722,7199723,7199724,7199725,7199726,7199727,7199728,7199729,7199730,7199731,7199732,7199733,7199734,7199735,7199736,7199737,7199738,7199739,7199740,7199741,7199742,7199743,7199744,7199745,3237338,3237339,3925519,10865790,8905595,8905596,10865926,10865927,10865928,10865929,10865930,10865931,10865932,10865933,10865934,10865935,10865936,10865937,10865938,10865939,10865940,10865941,10865942,10865943,10865944,10865945,10865946,10865947,10865948,10865949,10865950,10865951,10865952,10865953,10865954,10865955,10865956,10865957,8905826,8905827,10866177,8906035,10866616,10866617,10866745,8906567,8906568,8906569,8906570,8906571,8906572,8906573,8906574,8906575,8906576,8906577,8906578,8906579,8906580,8906581,8906737,8906799,8906800,8906801,8907090,10838913,10838929,10838930,10838931,10838932,10838933,10838934,10838935,10838936,10863927,10863928,10863929,10618275,10863980,10863981,10863982,10863983,10863984,10863985,10863986,10863987,8633376,10864071,10864331,8540594,8611288,8611451,8634376,8634377,8634378,8634379,10865154,10617047,8632425,8632426,10617454,8632561,8632562,8632563,8632564,8632565,10615024,10615091,10620121,10615166,10615170,10615268,10615270,10861039,10615603,10615605,10615606,10615609,10615614,10615620,10615630,10615631,10615639,10615640,10615641,10615642,10615645,10615646,10615647,10615648,10615652,10615654,10615656,10615658,10861354,10861355,10861363,10930631,10861587,10615951,10615958,10615959,10615960,10615961,10615962,10615973,10615974,10615980,10616060,3229183,3229184,3229185,3229188,3229189,3229190,3229191,3229192,3229193,3229194,3229195,3229196,3229197,3229198,3229199,3229200,3229201,3229305,10849389,10431693,10616844,10616845,10616846,10616847,10616848,10616849,10616850,10616851,10616852,10616853,10616854,10614204,10614274,10614282,10614291,10614292,10614301,10614304,10714149,10614327,10614328,10614329,10714179,10614516,10614656,10614658,10614669,10611965,10611966,10611967,10612263,10612265,10612267,10612344,10612755,7017808,7017809,7017810,7017811,7017812,7017813,7017814,7017815,7017816,7017817,7017818,7017819,10612910,10612911,10612912,10612913,10612914,10613184,10613187,10613348,10613801,10613808,10613809,10939419,6673556,7055657,10515335,9169568,9169674,9169675,9169676,9169677,9169678,9169679,9169680,9169681,9169682,9911939,9911940,9169822,9169823,9169824,9169825,9169826,9169827,9912048,6674166,6674167,6674169,6674288,10118591,10118592,9912738,9912739,9912740,9912811,9912812,9913276,9913277,9913278,9913279,9913280,9913281,6672563,10419288,10417358,10417359,10417360,10417386,10417387,10417388,10417389,10417390,10417391,10417392,10417393,6672706,6672707,6672724,10417448,10418470,10418473,10419497,10419498,10417650,9168861,10418996,6673331,6673332,6673333,6673334,10419097,10419098,10419099,10419100,10419101,10419102,10419103,10419104,10419105,10419106,10419107,10419108,10419109,10419110,10419111,10419112,10419113,10419114,10419115,10419116,10419117,10419118,10419119,10419120,10471104,10471105,10471106,10471107,10471108,10471109,10471110,10471111,10471112,10471113,10471114,10471115,10471116,10471117,10471118,10471119,10471120,10471175,8549990,8550242,8550243,8550244,8550245,8550246,8916797,976472,976473,976548,10470693,10470694,10470695,10470696,10470697,10470698,10470699,10470700,10470701,10470702,10470703,10470704,10470705,10427642,10888681,10888688,10888694,10888710,10888886,10888888,10888997,10888998,10888999,10889000,10889001,10889002,10889003,10889004,10889005,10889006,10889007,10889008,10889009,10889010,10889023,10889699,10889700,10889701,10889702,10889703,10889704,10889705,10889706,10889707,10889708,10889709,10889710,10885026,10875057,10890102,10890169,10890170,10890171,10890244,10890245,10627298,10627301,10627303,10627304,10627307,10627308,10627309,10627312,10627313,10887976,10885578,10885580,10885614,10885624,10885625,10885626,10885627,10885798,10162221,10162222,10162223,10162224,10162225,10897016,10897049,10897079,10897080,10897092,10887157,10887435,10602294,10602310,10609230,10647499,10647506,10647647,10647687,10610268,10610298,10610408,10610414,10610666,10610674,10610675,10610676,10604692,10610915,10610916,10415315,10415316,10415323,10508472,10508473,10508474,10508527,10508530,10508531,10508532,10508533,10413383,10413384,10413651,10413652,10413915,10414388,10414389,10414390,10414391,10414473,10414475,10414491,10414494,10414496,10414497,10414498,10414515,10414707,10415059,10415060) 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'