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(7075938,7076165,9214840,9214841,9214842,9214843,9214844,9214845,9214846,9214847,9214848,9214849,9214850,9214851,9214852,9214853,10930471,9214854,9214855,9214856,9214857,9214858,9214859,9214860,9214861,9214862,9214863,9214864,9214865,9214866,9214867,9214868,9214869,9214870,9214871,9214872,9214873,9214874,9214875,9214876,9214877,9214878,9214879,9214880,9214881,9214882,9214883,9214884,9214885,9214886,9214887,9214888,9214889,9214890,9214891,9214892,9214893,9214894,9214895,9214896,9214897,9214898,9214899,9214900,9214901,9214902,9214903,9214904,9214905,9214906,9214907,9214908,9214909,9214910,9214911,9214912,9214913,9214914,9214915,9214916,9214917,9214918,9214919,9214920,9214921,9214922,9214923,9214924,9214925,9214926,9214927,9214928,9214929,9214930,9214931,9214932,9214933,9214934,9214935,9214936,9214937,9214938,9214939,9214940,9214941,9214942,9214943,9214944,9214945,9214946,9214947,9214948,9214949,9214950,9214951,9214952,9214953,9214954,9214955,9214956,9214957,9214958,9214959,9214960,9214961,9214962,9214963,9214964,9214965,9214966,9214967,9214968,9214969,9214970,9214971,9214972,9214973,9214974,9214975,9214976,9214977,9214978,9214979,9214980,9214981,9214982,9214983,9214984,9214985,9214986,9214987,9214988,9214989,9214990,9214991,9214992,9214993,9214994,9214995,9214996,9214997,9214998,9214999,9215000,9215001,9215002,9215003,9215004,9215005,9215006,9215007,9215008,9215009,9215010,9215011,9215012,9215013,9215014,9215015,9215016,9215017,9215018,9215019,9215020,9215021,9215022,9215023,9215024,9215025,9215026,9215027,9215028,9215029,9215030,9215031,9215032,9215033,9215034,9215035,9215036,8569459,8569696,8569697,8569698,8569703,8569709,7074229,7074295,7074299,7074311,7074314,3229965,3229966,7066736,10929412,10929413,7067273,7067274,7067275,7067403,7067404,7067471,7067487,7067540,7067541,7067542,7067547,7067564,7067565,7067566,7067567,7067569,7067570,7067572,7067594,7067598,7067599,7067600,7067601,7067603,7067606,7067607,7067610,7067611,7067612,7067657,7067728,7067729,7067730,7067735,7067768,7067923,7064663,10103974,7202703,7202704,7065605,7071233,8834958,7071522,4430201,4430202,8835126,10102903,10102999,10101485,10101606,10101770,8834235,10101937,10101940,10101950,10102018,10102053,11046068,11046069,3924111,3924113,3924114,3924115,3924116,3924117,3924160,8907412,8907413,8907414,8907415,8907416,8907417,10619844,3922927,8612638,10620098,3231083,10965383,10965384,10965385,10965386,10965387,10965388,10965389,3231233,3231234,3231235,3231236,3231237,3231238,3231239,3231240,3231241,3231242,3231243,3231244,3231245,3231246,3231247,3231248,3231249,3231250,3231251,3231252,3231253,3231254,3231255,3231256,3231257,3231258,3231259,3231260,3231261,3231262,3231263,3231264,3231265,3231266,3231267,3231268,3231269,3231270,3231271,3231272,3231273,3231274,3231275,3231276,3231277,3231278,3231279,3231280,3231281,3231282,3231283,3231284,3231285,3231286,3231287,3231288,3231289,3231290,3231291,3231292,3231293,3231294,3231295,3231296,3231297,3231298,3231299,3231300,3231301,3231302,3231303,3231304,3231305,3231306,3231307,3231308,3231309,3231310,3231311,3231312,3231313,3231314,3231315,3231316,3231317,3231318,3231319,3231320,3231321,3231322,3231323,3231324,3231325,3231326,3231327,3231328,3231329,3231330,3231331,3231332,3231333,3231334,3231335,3231336,3231337,3231338,3231339,3231340,3231341,3231342,3231343,3231344,3231345,3231346,3231347,3231348,3231349,3231350,3231351,3231352,3231353,3231354,3231355,3231356,3231357,3231358,3231359,3231360,3231361,3231362,3231363,3231364,3231365,3231366,3231367,3231368,3231369,3231370,3231371,3231372,3231373,3231374,3231375,3231376,3231377,3231378,3231379,3231380,3231381,3231382,3231383,3231384,3231385,3231386,3231387,3231388,3231389,3231390,3231391,3231392,3231393,3231394,3231395,3231396,3231397,3231398,3231399,3231400,3231401,3231402,3231403,3231404,3231405,3231406,3231407,3231408,3231409,3231410,3231411,3231412,3231413,3231414,3231415,3231416,8540691,8540694,8540701,9189432,9189433,7059884,7059885,9174038,7057601,7057654,9172092,9188343,8566971,9188490,9205133,7055696,9161539,7055754,7055765,7055836,7055923,10125969,7055966,7056047,7056048,7056049,7056098,9170005,7056172,9912761,10119483,9187288,7055284,6666650,9174682,6666781,6666801,6666803,6666804,6666824,6666893,9175114,9175115,9175116,9175117,9175118,9175119,9175179,9175352,8917006,9167590,9175756,10175035,10632199,10632200,10632201,7000920,7001276,7001277,8562288,8562289,8562290,8562291,8562292,8562293,8562294,8562295,8562296,8562297,8562298,8562299,8562300) 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'