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(10861439,10861440,8630911,8630913,8630914,8630915,8630917,8630918,8630919,8630993,8631003,8839038,8631480,8631481,8631482,8631487,8631490,8631491,8631492,8631496,8631497,8631498,8631502,8631506,8631507,8631508,8631630,8583488,8631677,8631678,10459918,10459922,10459927,10459928,10459960,10459964,10459969,10459970,8067396,10460000,10460004,10460009,10460010,10460040,10460044,10460049,10460050,10460080,10460081,10460089,10460090,10460120,10460124,10460129,10460130,10460160,10460164,8632241,10460169,10460170,8632246,8632248,8632252,8632270,10460200,10460204,10460209,10460210,10460240,10460244,10460249,10460250,10460280,10460284,10460289,10460290,8632382,10460320,10460324,10460328,10460330,10460360,10460364,10460369,10460370,8632464,8632466,8632468,8632470,8632471,8632472,8632474,8632475,8632476,8632478,8632480,8632481,8632483,8632485,8632487,8632489,8632538,8629673,8067943,8629741,8629742,8629746,8629747,8629748,8629890,8629938,8629958,8630280,8630282,8630283,8630306,8630308,8630310,8630312,8630406,8630420,8630442,8630443,8630445,8630446,8630449,8630451,8630452,8627581,8627582,8627583,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,8627707,8627708,8627709,8627710,8627711,8627712,8627713,7201319,7201384,7201385,8627793,8627795,8627796,8627797,8627798,8627799,8627800,8627801,8627802,8627821,10866538,10866541,10866546,10866547,8628284,7202077,8065957,8628627,7064985,8628634,8628729,8628823,8628826,8628832,8628835,8628843,8628844,8628849,8628850,8628855,8628856,8628865,8628866,8628871,8628872,8628876,8628879,8628882,8628885,8628888,8628890,8628892,8628894,8628898,8628901,8628904,8628907,8628910,8628913,8628916,8628919,8628922,8628925,8628928,8628931,8628934,8628937,8628942,8628945,8628948,8628953,8628954,8628960,8628961,8628966,8628967,8628972,8628973,8628978,8628979,8628984,8628985,8628990,8628991,8629236,8629237,8629250,8629258,8629303,8629523,8629525,8629559,8626825,7200527,7200528,7200529,8626932,8627109,8627120,8627121,7200911,7200912,7200913,7200914,8627530,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8071687,8071695,8071705,8071707,8071752,8071760,8071770,8624682,8071772,8624683,8624688,8624690,8624691,8624692,8071817,8071822,8071835,8071837,8071882,8071890,8071900,8071902,8071947,8071955,8071965,8071967,8072012,8072020,8072030,8072032,8072077,8072085,8072095,8072097,8072142,8072150,8072160,8072162,7198681,7198683,7198696,7198697,7198699,8625106,7198710,7198711,7198714,7198716,8072207,7198719,7198724,8072215,7198728,7198730,8072224,8072227,7198742,7198743,7198750,7198762,7198772,8072272,8072280,8072290,8072292,8625879,8626201,8626228,8626248,8626253,8626255,8626256,7200121,8834368,11045725,3923672,3923673,4937292,4937300,4937311,4937313,4937361,7196890,4937369,7196891,7196892,4937379,4937381,4937426,3234127,4937434,4937444,4937446,4937491,4937499,4937509,4937511,4937556,4937561,4937574,4937576,4937621,4937629,4937639,4937641,4937686,4937694,4937704,4937706,4937751,4937759,4937769,4937771,4937816,4937824,4937834,4937836,4937881,4937889,4937899,4937901,4937946,4937954,4937963,4937966,4938011,4938019,4938029,4938031,3234901,3234902,3234904,3234905,3234906,7197805,7197806,7197807,8624380,8071554,8071562,8071573,8071575,8624524,8071622,8071630,8071640,8071642,8634615,8634616,8634617,8634677,8634678,8634680,8634681,8634682,8634684,8634769,8634770,10617322,10617377,10617378,10617384,10617403,10617404,10617405,10617409,10617417,10617422,10617423,10617426,10617427,10617428,10617429,10617430,10617431,10617432,10617433,10617434,10617435,10617438,10617442,10617443,10617445,8542254,10853155,8632627,10425386,10425391,10425553,10425555,10615229,10425577,10848006,8632908,8632909,8632910,3581902,8633272,8633273,8633274,8633275,8633276,8633277,8633278,10848408,10848409,8540530,8634101,8634441,8634443,8634444,8634445,8634453,8634454,8634455,8634456,8634457,8634458,8634459,8634460,8634461,8634462,8634463,8634464,8634465,8634466,8634467,8634468,8634469,8634470,8634471,8634472,8634473,8634474,8634475,8634476,8634477,8634478,8634479,8634480,8634481,8634482,8634483,8634485,8634486,8634489,8634491,8634493,8634494,8634495,8634498,8634499,8634503,8634505,8634506,8634507,8634510,8634511,8634512,8634513,8634515,8634516,8634518,8634520,8634521,8634524,8634526,8634527,8634530,8634531,8634534,8634535,8634537,8634538,8634540,8634542,8634543,8634545,10610995,10611408,6666259,10611969,8565891,8565947,9212315,10609988,10613736,6673506,8849319,8849320,8849321,8849322,8849323,8849330,8849332,10515422,10515423,9169951,9169952,9169953,6674309,6674310,6674327,6674328,6674329,6674330,6674331,10118375,4975237,9912966,8552227,9913359,9913361,8848127,8848195,10415375,10415376,10419468,8848719,8848725,8848726,8848728,8848730,8848741,8848744,8848746,8848747,8848756,8848758,8848760,8848761,8848767,8848782,8848829,8848843,8848845,8848866,8848877,8848889,8848909,8848911,8848920,10471173,8549957,8550037,8550038,8550266,8847310,8847476,8847493,8847496,8847500,8847541,8847542,8847584,8847613,9168100,8848002,8848003,8848006,8848014,8848021,8848033,8848034,8848036,8848037,8848046,8848062,8848103,10883568,10883624,10883627,10883629,10893986,10893987,10893988,10155731,10890085,10890141,10890144,10890145,10890146,10890147,10890148,10890149,10890154,10890155,10890158,10890160,10632166,7001400,7001401,10886057,10886058,10886059,10886060,10602171,10602176,10602182,10583441,10602696,10602697,10602700,10602704,10647703,10603684,10601693,10601702,10601704,10529398,10529399,10529409,10529412,10529413,10550384,10550385,10550386,10550445) 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'