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(10447883,10870636,10448228,8631097,10868287,10868289,10868290,10868292,10868294,10868295,8631658,8631659,8631666,8631667,8631668,8631669,8631670,8631671,8631672,8631705,8631706,8631707,8631742,8631743,7066287,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,8632237,8632238,8622500,8632522,8632523,8629783,8629784,8629786,8630244,10929915,8630289,8630290,8630291,8630292,7067875,10962567,10962568,10962569,10962570,10962571,10962572,10962573,10962574,10962575,10962576,10962577,8627729,8627730,8627731,8627732,8627733,8627734,8627735,8627736,8627737,8627872,8627873,8627874,8627875,8627876,8627877,8627878,8627991,8627992,8627993,8627994,8627995,8627996,8627997,8627998,8627999,8628000,8628001,8628002,8628003,8628004,8628005,8628006,8628007,8628008,8628009,8628010,8628011,8628012,8628013,8628014,8628015,8628016,8628017,8628018,8628019,8628020,8628021,8628022,8628023,8628024,8628025,8628026,8628027,8628028,8628029,8628030,10931836,10931838,8628144,8628149,8628150,8628151,8628152,8628159,8628160,8628161,8618365,8628194,8628231,8628360,8628361,8628362,8628363,8628364,8628365,8628366,8628367,8628368,8628369,8628389,8628397,10867461,10867462,10867463,10867464,10867465,10867466,10867467,10867468,10867469,10867470,10867471,10867472,10867473,10867474,10867475,10867476,10867477,10867478,10867479,10867480,10867481,10867482,10859606,10859607,5654763,8629552,10865279,10942618,11048967,11048971,7071242,7071262,7071296,7071298,7071299,7071301,7071304,7071305,8626970,8626971,8626972,8626973,8626974,8626975,7071337,8626985,8626989,8626990,8626991,8626992,8626993,8626994,8626995,8626998,8626999,8627000,8627001,8627002,8627003,3237952,10102904,10102912,10839702,8625141,8615494,8615495,8615502,8625502,10101041,8557331,10942100,10101948,10967957,10967958,10967959,10967960,10967961,10967962,10967964,10967965,10967966,10967967,3233702,3233703,3233704,3233705,3233711,3233712,3233713,3233714,3233715,3233716,8907072,8907073,10995298,8611955,8541766,8634900,8634902,8634904,3232756,3232850,3232853,3922861,8632591,8632592,8632593,8632647,10951665,8632692,8632693,8632694,8633062,8633063,8633064,8633065,8634100,8634101,3231961,10611162,9197683,9197684,3654910,3654911,9197708,3654921,3654922,3654923,10119682,10119683,10119684,9172326,9188332,9188432,9188436,10121041,10121042,10121043,10121044,10121045,10121046,10121047,10561854,10561855,10561905,10561960,10561961,8567758,8567769,8567770,10562092,10660157,10515341,10515342,10515343,10515344,10515345,10515346,10515347,6674453,6674454,6674455,6674456,6674457,6674458,6674459,6674460,6674461,9170301,10119311,10418584,9911164,10122528,10122536,9190453,8854591,10171207,10905218,10900416,7000845,7001084,10627948,10161933,10891378,10891379,10891380,10891381,10891382,10891383,10172416,10172434,10172754,10172755,10163025,10163028,10882429,10602248,10525331,10525332,10525333,10525334,10547804,10547816,10547817,10547818,10547819,10547820,10547821,10547822,10547823,10547841,10547843,10547844,10547872,10547873,10547874,10547930,10547931,10547934,10547935,10547936,10547944,10527948,10527949,10547954,10547955,10547956,10547960,10547989,10547990,10547991,10547992,10547993,10547994,10547995,10547996,10548044,10548045,10548046,10548049,10548050,10548054,10548055,10548056,10548057,10548058,10548064,10548067,10546316,10528380,10534383,10546508,10536771,10536772,10536850,10536851,10536853,10536854,10536855,10536856,10536857,10536858,10536859,10536877,10536882,10536883,10546919,10546920,10546921,10546922,10546927,10527028,10527029,10420247,10420248,10420249,10420250,10420251,10420252,10420253,10420254,10420255,10420256,10420257,10420258,10420259,10420260,10420261,10420262,10420263,10420264,10420265,10420266,10420267,10420268,10422286,10508446,10508519,10505552,10507563,10507633,10507649,10507650,10507859,10507860,10507901,10507932,10507933,10507934,10507935,10507936,10508002,10508013,10508021,10508022,10508023,10508024,8562529,8562602,8562604,10414043,10414044,10476142,10476143,10476144,10476145) 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'