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(7075851,10198157,10198158,10198159,10198160,10198161,10198166,10198167,7076078,7076079,10943685,7076226,10198484,10198485,10198486,10198487,7076268,7076279,7076312,7076341,7068354,7076363,7076365,7076366,7076393,8569414,7068612,7068641,7068644,7068646,7068651,7068652,7068653,7068655,7068659,7068662,7068663,7068664,7068665,8569642,7068666,8569643,7068668,7068669,7068670,4971029,7068728,8569706,8569707,7068736,7068752,7068776,7068784,7068792,7068793,7068799,7068804,7068812,7068813,7068814,7068815,7073960,7065997,7074086,10199470,7066587,7066670,7066708,7066709,7066710,7066711,7066713,7066716,7066717,7066718,7066719,10437702,7066765,7066766,7066767,7066808,7066809,7067277,7075292,10197545,7067421,7075434,10197761,10197762,10197763,7075667,7071863,6000260,10931516,7072081,7072452,7072612,7072613,7072714,10195953,10932193,10932195,7072763,10932218,10932224,7072813,7072860,7072880,7072907,7072908,10196232,7073017,7073053,10196452,7073303,7073330,10196679,10196680,10196681,8860733,7070856,7070869,7070870,7070871,7070872,7070873,7070874,7070875,7070876,7070877,7070882,7070946,7070948,7070950,7070951,7070953,7070955,7070956,7070957,7070958,7070959,7070991,8860902,10194241,10194242,10194243,7071007,8860917,10942731,10943127,10943152,10943171,10943181,8861391,10943219,10943220,10943299,10943300,10943305,7071590,7071591,10943307,8861496,7071599,7071602,7071609,7071614,7071627,7071628,7071629,7071630,8861539,7071653,7071654,7071655,7071656,7071657,7071658,7071659,7071660,7071661,7071662,7071663,10943384,10943402,10943408,10943410,10943424,10931205,7068823,10944349,10944350,7068878,7068899,7068901,7068911,7068918,7068930,7068984,7068985,10940747,7069049,7069050,7069051,7069052,7069053,7069184,10940929,7069220,7069221,7069222,7069367,7069377,7069378,7069381,7069382,7069391,7069585,7069638,7069727,10941707,10941711,10941787,10941788,10941797,10941801,7070091,10941809,10941810,10941813,10941846,10941897,10941903,10941907,10941990,10942025,10942029,10942030,8860327,8860398,10942308,7070639,8860564,7070738,10942461,10942462,7070791,10928507,10618040,10618041,10618042,10618043,10928577,10928581,10928591,10618104,10618105,10928625,10618240,10618241,10618242,10618243,10618244,10618245,10618253,10618254,10618255,10618256,10618281,10618979,10618984,10618985,10618986,10618987,10618988,10618989,10618990,10618991,10618992,10619357,10619869,10619870,10619871,10619924,10619925,10619926,10619927,10619928,10619933,10619934,10619939,10617063,10617064,10617068,10617099,10622103,10617162,10617163,10927929,10927930,10927931,10927932,10927933,10922943,10922944,10922945,10922946,10622657,10622658,10622659,10622660,10622663,10622664,10928227,10928228,10928229,10928230,10928231,10928232,10928234,10928235,10928236,10622734,10622735,10622820,10622899,10620002,8569838,8569839,8569840,8569841,8569911,10620096,10615100,10615101,10615108,10615112,10620119,10620120,10615133,10615134,10615137,10920767,10920768,10615274,10615320,10620347,10615371,10615372,10615391,10920918,10920919,10615439,10926005,10926080,10921086,10926170,10926205,10615830,10921349,10615897,10615898,10921418,10921419,10921420,10921421,10615922,10615971,10615972,10921500,10921501,10616057,10921618,10930972,10930982,10926693,10926714,10926729,10921775,10621448,10616473,10927199,10616730,10616731,10616732,10562124,10562125,10562126,10562127,10562128,10562129,10562130,10562131,10562132,10562133,10559233,10614188,10614193,10614232,10562400,10562401,10562402,10562403,10562404,10562405,10562406,10562407,10562408,10562409,10562410,10562411,8864209,10614404,10614406,10614475,10614477,10614478,10614486,10614489,10559660,10559661,10559662,10559663,10559664,10559665,10559666,10559667,10614563,8861897,8861898,8861899,10612088,10612178,10612265,10557486,10612507,10612508,10612509,10612510,10612513,10612517,10557667,10612577,10612578,10612587,10612588,10612599,10612622,10612638,10612652,10612659,10612678,10612681,10612682,10612683,10612702,10612703,8862684,8862691,10612940,8862850,8862851,8862852,8862853,8862854,10613000,10613012,10613063,8862953,8862954,8862955,8862956,10613119,10613208,8863112,8863120,10561582,10561584,10561586,10561587,10561592,10561593,10561594,10561595,10561597,10561599,10561600,10561601,10561602,10561603,10613455,10561606,10561608,10561609,10561610,10561611,10561612,10561613,10561614,10561615,10561621,10561625,10561626,10561627,10561631,10561632,10561633,10561634,10561640,10561641,10561644,10561645,10561646,10561647,10561648,10561649,10561650,10561651,10561652,10561653,10561654,10561655,10561656,10561657,10561662,10561663,10561664,10561665,10561666,10561667,10561668,10561670,10561671,10561674,10561675,10561676,10561677,10561684,10561685,10561686,10561687,10561688,10561689,10561690,10561691,10561692,10561693,10561699,10561701,10561702,10561703,10561706,10561707,10561708,10561709,10561711,10561726,10561727,10561728,10561729,10561731,10561738,10561742,10561743,10561744,10561746,8863462,8863463,8863464,8863465,8863466,8863467,10515130,10513142,10513143,10513193,10513194,10513195,10513196,10513197,10513198,10513199,10513200,10513201,10513202,10513203,10513204,10513205,10513206,10513207,10513208,10513209,10513210,10513211,10513212,10513213,10513214,10513215,10513216,10517261,10517262,10517263,10515352,10515353,10515354,10515355,10515356,10515357,10515358,10515359,10515360,10515361,10515362,10515363,10515364,10515365,10515366,10515367,10515368,10515369,10515370,10515371,10515372,10515373,10515374,10515375,10515376,10515377,10515378,10515379,10515380,10515381,10515382,10515383,10515384,10515385,10515386,10515387,10515388,10515389,10515390,10515391,10515392,10515393,10515394,10515395,10515396,10515397,10515398,10515399,10515400,10515401,10515402,10515403,10515404,10515405,10515406,10515407,10515408,10515409,4974471,10513435,10513436,10513437,10513438,10513439,10513440,10513441,10513442,10513443,10513444,10513445,10513446,10513447,10513448,10513449,10513450,10513451,10513452,10513453,10513454,10513455,10513456,10513457,10513458,10513459,10513460,10513461,10513462,10513463,10513464,10513465,10513466,10513467,10513468,10513469,10513470,10513471,10513472,10513473,10513474,10513475,10513476,10513477,10513478,10513479,10513480,10513481,10513482,10513483,10513484,10513485,10515495,10515496,10515579,10515580,10515581,10515582,10515583,10515584,10515585,10515586,10515587,10515588,10515589,10515590,10515591,10515592,10517593,10517594,10517595,10517596,10517597,10517598,10517599,10517600,10517601,10517602,10517603,10517604,10517605,4974653,10515739,10515740,10515741,10515802,10515803,10515804,10515805,10515806,10515807,10515808,10515809,10515810,10515811,10515817,10515818,10515833,10513885,10513911,10513912,10513913,10513914,10513915,10513926,10513927,10513928,10513929,10513930,10513931,10513932,10513933,10513934,10513935,10513936,10513937,10513938,10513939,10513940,10513941,10513942,10513943,10513944,10513945,10513946,10513947,10513948,10513951,10513954,10513989,10514000,10514015,10514020,10514024,10514035,10514047,10514048,10514060,10516066,10516070,10516071,10516072,10516073,10516074,10516075,10516076,10516077,10516078,10516079,10516080,10516081,10516082,10516083,10516084,10516085,10516086,10516087,10516088,10516089,10516090,10516091,10516092,10516093,10516094,10516095,10516096,10514626,10514627,10514628,10514629,10514630,10514631,10514637,10514648,10514649,10514650,10514651,10514652,10514653,10514654,10514655,10514782,10514810,10514811,10514821,10514822,10514823,10514829,10514857,10514858,10514859,10514860,10514891,10514895,10512964,10512965,10515103,10416259,10418263,10416272,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,10417471,4973408,10418509,10417741,4973682,4973683,10417819,10417820,10417838,10417839,10417855,10417856,10417873,10417874,10417890,10417891,10417908,10417909,10416963,10418983,10420000,10420054,10420059,10417059,10417060,10417121,10417122,10420141,10420142,10420143,10420144,10418148,4971334,4971339,4971340,10467113,10467129,10467130,10471182,4971481,4971482,4971491,4971492,4971493,4971614,10467339,10467428,10467429,10467430,10467431,10467432,10471524,10471525,10471566,4971936,10465780,10465812,10465813,10465814,10465815,10465816,10465817,10465818,10465877,10465914,10469944,10464046,10464047,10468142,10468143,10468158,10466212,10466213,10466363,10466364,10466365,10466424,10466425,10468487,10470495,10470595,10466853,10466856,10627979,10628100,10628154,10629450,10629451,10629541,10629694,10629695,10629696,10629757,10629758,10629878,10629879,10627024,10627025,10627049,10627050,10627051,10627052,10627053,10627054,10627073,10627074,10627075,10627076,10627077,10627078,10627079,10627281,10627283,10627284,10627344,10627783,10627786,10627796,10627797,10627800,10627801,10627813,10627819,10627838,10627839,10627848,10627854,10627863) 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'