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(8630753,8630756,8630787,8630912,8630918,8630993,8631003,8631070,8631476,8631477,8631478,8631479,8631480,8631481,8631482,8631487,8631490,8631491,8631492,8631496,8631497,8631498,8631502,8631506,8631507,8631508,8631630,8631677,8631678,8631679,8631712,8631856,8631857,8631858,8631859,8632190,8632191,8632192,8632193,8632241,8632246,8632248,8632252,8632270,8632382,8632464,8632466,8632468,8632470,8632471,8632472,8632474,8632475,8632476,8632478,8632480,8632481,8632483,8632485,8632487,8632489,8632490,8632495,8632496,8632497,8632500,8632502,8632503,8632538,8632540,8632566,8632567,8632568,8632570,8632571,8629585,8629617,8629618,8629619,8629620,8629621,8629622,8629623,8629626,8629627,8629628,8629631,8629632,8629633,8629670,8629672,8629673,8629741,8629742,8629745,8629746,8629747,8629748,8629754,8629755,8629756,8629832,8629834,8629836,8629838,8629841,8629843,8629849,8629852,8629854,8629856,8629861,8629862,8629863,8629865,8629868,8629870,8629873,8629877,8629881,8629890,8629913,8629915,8629917,8629920,8629921,8629923,8629925,8629927,8629930,8629932,8629934,8629936,8629938,8629939,8629942,8629945,8629947,8629950,8629953,8629957,8629958,8630280,8630282,8630283,8630305,8630306,8630307,8630308,8630309,8630310,8630311,8630312,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,8627793,8627795,8627796,8627797,8627801,8627802,8627821,10866570,10866571,10866572,10866573,10866574,10866577,10866578,8628060,8628061,8628062,8628063,8628064,8628065,8628066,8628067,8628068,8628069,8628070,8628283,8628284,8628285,8628521,8628522,8628523,8628524,8628525,8628526,8628527,8628528,8628529,8628530,8628531,8628532,8628626,8628627,8628634,8628724,8628725,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,8629093,8629094,8629095,8629096,8629099,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629227,8629228,8629229,8629230,8629231,8629232,8629233,8629234,8629235,8629236,8629237,8629250,8629258,8629303,8629393,8629396,8629439,8629472,8629523,8629525,8629559,10865236,10865237,10865238,10865239,8626749,8626750,8626751,8626752,8626753,8626825,8626834,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8627050,8627052,8627055,8627056,8627057,8627058,8627059,8627060,8627061,8627064,8627065,8627066,8627068,8627072,8627074,8627075,8627083,8627084,8627089,8627090,8627093,8627094,8627099,8627106,8627107,8627108,8627109,8627110,8627112,8627117,8627119,8627120,8627121,8627314,7200914,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8627530,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8624681,8624682,8624683,8624684,8624688,8624690,8624691,8624692,7198683,7198696,7198697,7198699,7198710,7198711,7198714,7198716,7198724,7198730,7198742,7198749,7198762,8626201,8626211,8626212,8626227,8626228,8626234,8626248,8626253,8626255,8626256,8626319,8626320,8626321,8626322,8626323,8626324,8626325,8626326,8626327,8626328,8626329,8626330,8626331,8626332,8626333,8626334,8626335,8626336,8626337,8626338,8626339,8626340,8626341,8626342,8626343,8626344,8626345,8626346,8626347,8626348,8626349,8626420,8626446,8626451,8626456,8626462,8626465,8626466,8626467,8626468,8626469,10853411,7197805,7197806,7197807,8624379,8624380,8624389,8624397,8624449,8624502,8624508,8624512,8634685,8634686,8634811,8634899,10617323,10617324,10617377,8635015,8635018,8635020,8635021,8635022,10954313,10425386,10425391,8632702,10620195,10620196,10620197,10620198,10620199,8632862,8632863,8632864,8632866,8632867,8632868,8632869,8632878,8632879,8632881,8632884,8632908,8632909,8632910,10850661,10850662,3581902,8633186,8633187,8633188,8633189,8633190,8633191,8633192,8633193,8633194,8633195,8633196,8633197,8633198,8633199,8633200,8633201,8633219,8633220,8633221,8633222,8633223,8633224,8633225,8633226,8633227,8633228,8633229,8633230,8633231,8633232,8633233,8633234,8633279,10615711,10615896,10616005,10616332,10616417,10616426,8634101,8634411,8634412,8634441,8634443,8634444,8634445,8634449,8634450,8634451,8634452,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,8634484,8634485,8634486,8634488,8634489,8634490,8634491,8634492,8634493,8634494,8634495,8634497,8634498,8634499,8634500,8634502,8634503,8634504,8634505,8634506,8634507,8634509,8634510,8634511,8634512,8634513,8634514,8634515,8634516,8634517,8634518,8634519,8634520,8634521,8634522,8634524,8634525,8634526,8634527,8634528,8634529,8634530,8634531,8634532,8634533,8634534,8634535,8634536,8634537,8634538,8634539,8634540,8634541,8634542,8634543,8634544,8634545,8634546,10611603,10612938,10612939,10613369,6673693,6674308,6674309,6674310,6674311,6674312,9913359,9913361,9910628,10418543,10418544,10418545,10418546,10471173,8550037,8550038,8847310,9168100,10893984,10893985,10893986,10893987,10893988,10889231,10890145,10890146,10890147,10886057,10886058,10886059,10886060,10626724,10626725,10602179,10590270,10590277,10601688,10601697,10407925) 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'