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,10939571,10939572,10939573,10939574,10939585,10939736,7076078,7076079,10939882,10939883,10939884,10943685,10939913,7076226,7076268,7076279,7076312,7076341,7068354,7076363,7076365,7076366,7076393,8569414,7068612,10940332,10940333,10940334,10940335,10940337,10940338,10940339,10940341,7068641,7068644,7068646,7068651,7068652,7068653,7068655,7068659,7068662,7068663,7068664,7068665,8569642,7068666,8569643,7068668,7068669,7068670,10940406,4971029,7068728,8569706,8569707,7068736,7068752,7068776,7068784,7068792,7068793,7068799,7068804,7068812,7068813,7068814,7068815,7073960,7065997,7074086,8067325,7066587,7066670,8067748,7066708,7066709,7066710,7066711,7066713,7066716,7066717,7066718,7066719,10437702,7066765,7066766,7066767,7066808,7066809,7067277,7075292,7067421,7075434,7075667,7071863,6000260,10931516,7072081,7072452,7072612,7072613,7072714,10932193,10932195,7072763,10932218,10932224,7072813,7072860,7072880,7072907,7072908,8065991,8065997,8066070,7073017,7073053,7073303,7073330,8066455,8066456,8860733,7070856,7070869,7070870,7070871,7070872,7070873,7070874,7070875,7070876,7070877,7070882,7070946,7070948,7070950,7070951,7070953,7070955,7070956,7070957,7070958,7070959,7070991,8860902,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,3656234,7069585,7069638,7069727,3656622,3656653,3656667,10941707,10941711,10941787,10941788,10941797,10941801,7070091,10941809,10941810,10941813,10941846,10941897,10941903,10941907,3656909,3656910,3656911,3656912,3656913,3656914,3656915,3656916,3656917,3656918,10941990,10942025,10942029,10942030,8860327,8860398,10942308,7070639,8860564,7070738,10942461,10942462,7070791,10928507,10618040,10618041,10618042,10618043,10928577,10928581,10928591,10618104,10618105,10928625,10918663,10918664,10618240,10618241,10618242,10618243,10618244,10618245,10618253,10618254,10618255,10618256,10618281,10918890,10918891,10918892,10918893,10918894,10918895,10918896,10918897,10918898,10918899,10918900,10919281,10919282,10919283,10618979,10618984,10618985,10618986,10618987,10618988,10618989,10618990,10618991,10618992,10919603,10919604,10919605,10919606,10619357,10920145,10920147,10920148,10920149,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,10918031,10918162,10918163,10622657,10622658,10622659,10622660,10622663,10622664,10928227,10928228,10928229,10928230,10928231,10928232,10928234,10928235,10928236,10622734,10622735,10622820,10918348,10918349,10918350,10918351,10918352,10622899,10620002,10620096,10615100,10615101,10615108,10615112,10620119,10620120,10615133,10615134,10615137,10920767,10920768,10615274,10915784,10915785,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,10926693,10926714,10926729,10921775,10621448,10616473,10917128,10927199,10616730,10616731,10616732,10562124,10562125,10562126,10562127,10562128,10562129,10562130,10562131,10562132,10562133,10610987,10559233,10611135,10614188,10614193,10614232,10562400,10562401,10562402,10562403,10562404,10562405,10562406,10562407,10562408,10562409,10562410,10562411,10614404,10614406,10614475,10614477,10614478,10614486,10614489,10559660,10559661,10559662,10559663,10559664,10559665,10559666,10559667,10614563,10611772,10611774,10611906,10611907,10611908,10611911,10611918,10611923,10611924,10611928,10611932,10611938,10611955,10612088,10609115,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,10609707,10609825,10609826,10612940,10609944,10613000,10613012,10613063,10613119,10610120,10610190,10613208,10610282,10610289,10561582,10561584,10561586,10561587,10610440,10610441,10561592,10561593,10561594,10561595,10561597,10561599,10561600,10561601,10561602,10561603,10613455,10561606,10561608,10561609,10561610,10561611,10561612,10561613,10561614,10610464,10561615,10561621,10561625,10561626,10561627,10561631,10561632,10561633,10561634,10610488,10610489,10561640,10561641,10561644,10561645,10561646,10561647,10610497,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,10610732,10610773,10610795,10610823,10610834,10610915,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,10513435,10513436,10513437,10513438,10513439,10513440,10513441,10513442,10513443,10513444,10513445,10513446,10513447,10513448,10513449,10513450,10513451,10513452,10513453,10555454,10513454,10555455,10513455,10555456,10513456,10555457,10513457,10555458,10513458,10555459,10513459,10555460,10513460,10555461,10513461,10555462,10513462,10555463,10513463,10555464,10513464,10555465,10513465,10513466,10513467,10513468,10513469,10513470,10513471,10513472,10513473,10513474,10513475,10513476,10513477,10513478,10513479,10513480,10513481,10513482,10513483,10513484,10513485,10555495,10555496,10555497,10555498,10555499,10555500,10555501,10517593,10517594,10517595,10517596,10517597,10517598,10517599,10517600,10517601,10517602,10517603,10517604,10517605,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,10556303,10556304,10556305,10556306,10556307,10556450,10556451,10556540,10556541,10514626,10514627,10514628,10514629,10514630,10514631,10514637,10514648,10514649,10514650,10514651,10514652,10514653,10514654,10514655,10556710,10514782,10514810,10514811,10514821,10514822,10514823,10514829,10514857,10514858,10514859,10514860,10514891,10514895,10512964,10512965,10557062,10515103,10416259,10416272,10415331,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,10415462,10417471,10417741,10417819,10417820,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10417838,10417839,10417855,10417856,10417873,10417874,10415887,10415888,10415889,10417890,10417891,10415896,10415897,10415898,10417908,10417909,10416963,10420000,10420054,10420059,10417059,10417060,10417121,10417122,10420141,10420142,10420143,10420144,10418148,10463007,10463044,10463045,10467113,10467129,10467130,10471182,10467339,10467428,10467429,10467430,10467431,10467432,10471524,10471525,10471566,10463741,10463742,10463743,10463744,10463745,10463746,10463747,10463748,10463749,10463750,10463751,10463752,10463753,10463754,10463755,10463756,10463757,10463758,10463759,10463760,10463761,10463762,10463763,10463764,10463765,10463766,10463767,10465780,10463789,10463790,10463791,10465812,10465813,10465814,10465815,10465816,10465817,10465818,10465877,10465914,10469944,10464046,10464047,8563395,8563396,10466212,10466213,10462314,10466363,10466364,10466365,10466424,10466425,10462440,10462441,10462442,10470495,10462501,10470595,10462723,10462724,10462725,10462726,10462727,10462728,10466853,10466856) 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'