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(8569510,10950353,10862016,10862024,10862031,10862036,10862039,10862041,10862045,10862055,10862059,10862065,8609703,8609704,10938687,10938688,10938689,10938690,10938691,10938692,10938693,10938694,10938695,10938696,10938697,10938698,3227558,3227559,3227560,3227561,3227562,8594733,8594734,8594735,7064353,7202369,10928858,10928859,10928860,10928861,10928862,4967980,4967981,10857376,7200989,7200990,7200991,7200992,7200993,7200994,7200995,7201099,7201100,7201101,10100264,10970212,10970225,7200087,7196243,7196244,7196245,7196246,7196247,7196409,7196410,10837051,10837052,3922876,10850527,10850528,10850529,10850530,10850531,10850532,10850533,10850534,10850535,10850536,10850537,10850538,10850539,10850540,10850541,10850542,10850543,10850544,10850545,10850546,10850547,10850548,10850549,10850550,10850551,10850552,10850553,10850554,10850555,10850556,10850557,10850558,10850559,10850560,10850561,10850562,10850563,10850564,10850565,10850566,10850567,10850568,10850569,10850570,10850571,10850572,10850573,10850574,10850575,10850576,10850577,10850578,10850579,10850580,10850581,10850582,10850583,3581930,7154528,7154529,7154530,7154531,7154532,7154533,7154534,7154535,8904422,8904423,8904424,8904425,8904426,8904427,8904428,8904429,8904430,8904431,8904432,8904433,8904434,8904435,8904436,8904437,8904438,8904439,8904440,8904441,8904442,8904443,8904444,10611326,10611327,3962524,3962525,8861844,9219607,6676010,6676011,6676014,6676019,6676020,6676034,6676037,6676038,6676039,8863234,8849380,8849381,8849382,8849383,8849384,8849385,8849386,8849387,8849388,8849389,8849390,8849391,8849392,8849393,8849394,8849395,8849396,8849397,8849398,8849399,8849400,8849401,8849402,8849403,8849404,8849405,8849406,8849407,8849408,8849409,8849410,8849411,8849412,8849413,8849414,8849415,8849416,8849417,8849418,8551585,6675208,6675209,6675210,6675216,6675217,6675218,6675223,6675224,6675229,6675232,6675233,6675234,6675235,6675236,6675237,6675243,6675244,6675248,6675249,6675250,6675255,6675258,6675260,6675261,6675268,6675269,6675282,6675283,6675285,6675294,6675297,6675298,6675300,6675304,6675305,6675307,6675308,6675314,6675317,6675325,6675326,6675335,6675339,6675342,6675345,6675348,6675350,6675355,6675358,6675359,6675363,6675364,6675365,6675366,6675367,6675369,6675386,6675387,6675388,6675398,6675403,6675424,6675425,6675426,6675428,6675430,6675434,8565749,6675473,6675474,6675485,6675486,9910829,9910830,9910831,9910832,9910833,9910834,9910835,9910836,9910837,9910838,9910839,9910840,9910841,9910842,9910843,9161282,9161283,9161284,9161285,9161286,9161287,9161288,9161289,9161290,9161291,9161292,8549554,8549555,6670760,6670761,6670762,6670763,6670764,6670765,9198594,10467333,6665125,6665126,6665127,6665128,10463499,10463500,10463501,10463502,10463503,10463504,10463505,10463506,10463507,10463508,10463509,10463510,10463511,10463512,10463513,10463514,10463515,10463516,10463517,10463518,10463519,10463520,10463521,10463522,10463523,10463524,10463525,10463526,10463527,10463528,10463529,10463530,10463531,10463532,10463533,10463534,10463535,10463536,10463537,10463538,10463539,10463540,10463541,10463542,10463543,10463544,10463545,10463546,10463547,10463548,10463549,10463550,10463551,8550165,10116076,10116077,10116078,10116079,10116080,10116081,10116082,10116083,10116084,10116085,10116086,10116087,10116088,10116089,10116090,10116091,10116092,10116093,10116158,10427442,10155547,10155548,10155549,10155550,10155551,10155552,10884541,10155553,10155554,10155555,10155556,10155557,10165886,10887502,10158699,10625075,10625076,10625077,10876752,10876753,10876754,10876755,10876756,10876757,10876758,10876759,10876760,10876761,10876762,10876763,10876764,10876765,10876766,10876767,10876768,10876769,10876770,10876771,10876772,10876773,10876774,10876775,10876776,10876777,10876778,10876779,10876780,10876781,10876782,10876783,10876784,10876785,10876786,10876787,10876788,10876789,10876790,10876791,10876792,10876793,10876794,10876795,10876796,10876797,10876798,10876799,10876800,10876801,10876802,10876803,10626920,10602135,10602136,10602137,10602705,10602706,10602707,10644322,10644323,10644324,10644325,10644657,10644661,10603700,10603778,10603779,10603780,10603781,10603782,10603783,10603784,10603785,10603786,10603787,10603788,10603789,10603790,10603791,10603792,10603793,10603794,10603795,10603796,10603797,10603798,10603799,10603800,10603801,10603802,10603803,10603804,10603805,10603806,10603807,10603808,10603809,10603810,10603811,10603812,10603813,10603814,10603815,10603816,10603817,10603818,10603819,10603820,10603821,10603822,10603823,10603824,10603825,10603826,10603827,10603828,10603829,10603830,10603831,10603832,10603833,10603834,10603835,10603836,10603837,10603838,10603839,10603840,10603841,10603842,10603843,10603844,10603845,10603846,10603847,10603848,10603849,10603850,10603851,10603852,10603853,10603854,10603855,10603856,10603857,10603858,10603859,10603860,10603861,10603862,10603863,10603864,10603865,10603866,10603867,10603868,10603869,10603870,10603871,10606880,10601700,10601703,10541367,10541368,10541369,10498368,10498369,10498370,10407833,10407834,10407835,10407836,10407837,10407838,10407839,10407840,10407841,10407842,10407843,10407844,10407845,10407846,10407847,10407848,10407849,10407850,10407851,10407852,10407853,10407854,10407855,10407856,10407857,10407858,10407859,10407860,10407861,10407862,10407863,10407864,10407865,10407866,10407867,10407868,10407869,10407870,10407871,10407872,10407873,10407874,10407875,10407876,10407877,10407878,10407879,10407880,10407881,10407882,10407883,10407884,10407885,10486657,10486658,10486659) 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'