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(7075985,7075988,7075989,7075990,7075994,8594577,9214805,10870449,3228864,3228865,3228866,3228867,8569549,8569550,3229104,3229105,9215406,10944263,10989999,10990000,10990001,10990002,10990003,10990004,10990005,10990006,10990007,10990008,10990009,10990010,10990011,10990012,10990013,10990014,10990015,10990016,10990017,10990018,10990019,10990020,10990021,10990022,10990023,10990024,10990025,10990026,10990027,10990028,10990029,10990030,10990031,10990032,10990033,10990034,10990035,10990036,10990037,10990038,10990039,10990040,10990041,10990042,10990043,10990044,10990045,10990046,10990047,10990048,10990049,10990050,10990051,10990052,10990053,10990054,10990055,10990056,10990057,10990058,10990059,10990060,10990061,10990062,10990063,10990064,10990065,10862798,8575745,10460415,8573213,8573214,8573325,8561307,8561308,8561309,8561310,8561311,7067724,10103392,8594944,8594976,8594977,8594978,8594979,8594980,8594981,10960084,10960139,10960140,10960141,10960142,10960143,10960144,10960145,10960146,10960147,10960148,10960149,10960150,10960151,10960152,10858755,10960153,10960154,10960155,10960156,10960157,10960158,10960159,3899063,3899064,10999733,10859440,10104611,10104616,3227061,3227062,7065775,7065776,7065777,7065778,7065779,7065780,7065781,7065782,7065783,7065784,7065785,7065786,7065787,7065788,7065789,7065790,7065791,7065792,7065793,7065794,7065795,7065796,7065797,7065798,7065799,7065800,7065801,7065802,7065803,7065804,7065805,7065806,7065807,7065808,7065809,7065810,7065811,7065812,7065813,7065814,7065815,7065816,7065817,7065818,7065819,7065820,7065821,8834719,8834720,7200595,10855590,8072428,8072441,8072467,8072468,10101361,10101362,10101363,10101364,10101365,10101366,10101367,10101368,10101369,10101370,10101371,10101372,10101373,10101374,10101375,10101376,10101377,10101378,10101379,10101380,10101381,10101382,10101383,11048359,10102025,3923353,3923354,8554158,8554159,8554160,8554161,8554162,8554163,8554164,8554165,8554166,8554167,8554168,8554169,8554170,8554171,8554172,8554173,8554174,8554175,8554176,8554177,8554178,8554336,11007161,10838427,10838428,10838429,10838430,10838431,10838432,10838433,10838434,10838435,10838436,10838437,10838438,10838439,10838440,10838441,10838442,10838443,10838444,10838445,10838446,10838447,10838448,10838449,10838450,10838451,10838452,10838453,10838454,10838455,10838456,10838457,10838458,10838459,10838460,10838461,10838462,10838463,10838464,10838465,10838466,10838467,10838468,10838469,10838470,10838471,10838472,10838473,10838474,10838475,10838476,10838477,10838478,10838479,10838480,10838481,10838482,10838483,10838484,10838485,10838486,7197487,4938166,4938179,4938205,4938206,10922477,10922481,10922482,10922483,10922484,10922485,10922486,10922487,10922488,10922489,10922490,10922491,10922493,10922494,10617160,11045083,11045084,11045085,11045086,11045087,11045447,11045448,10853206,10853207,10853208,10853209,10853210,10853211,10853212,10853213,10853214,10853215,10853216,10853217,10853218,10853219,10425519,3230844,10930625,9217421,9217422,9217423,9217437,9217523,8611179,8611180,8611181,8611182,8611183,8611184,8611185,8611186,8611187,8611188,8611189,8611190,8611191,8611192,8611193,8611194,8611195,8611196,8611197,8611198,8611199,8611200,8611201,8611202,8611203,8611204,8611205,8611206,10922464,10922465,10922466,10922468,10922469,10922470,8567987,10714105,8864325,10614665,10614666,10614667,6666156,6666157,6666158,6666159,6666160,6666161,6666162,6666163,6666164,6666165,6666166,6666167,6666168,6666169,6666170,6666171,6666172,6666173,6666174,6666175,6666176,6666177,6666178,6666179,6666180,6666181,6666182,6666183,6666184,6666185,6666186,6666187,6666188,6666189,6666190,6666191,6666192,6666193,6666194,6666195,6666196,6666197,6666198,6666199,8862466,8862467,8862468,8862469,8862470,8862471,8862472,8862473,8862474,8862475,9212033,9212034,9212035,9212036,9212037,9212038,9212039,9172160,3653379,3653380,3653381,3653382,3653383,3653384,3653385,9915470,9915471,9915472,9911544,9911545,9911546,8849371,10125780,10117801,6674320,9186146,9186802,9913240,9913337,7014021,7014022,10416361,4973674,10117242,10117243,10117244,10117245,10117246,10117247,10117248,10117249,10117250,10117251,10117252,10117253,10117254,10117255,10117256,10117257,10117258,10117259,10117260,10117261,10117262,10117263,10117264,10117265,7055382,7055383,10467214,8916745,8916746,8916747,8916748,8916749,8916750,8916751,8916752,8916753,8916754,8916755,8916756,9167166,9167167,9167168,9167169,9167170,9167171,9167172,9167173,9167174,9167175,9167176,9167177,9167178,9167179,9167180,9167181,9167182,9167183,9167184,9167185,9167186,9167187,9167188,9167189,9167190,9167191,9167192,9167193,9167194,9167195,9167196,9167197,9167198,9167199,9167200,9167201,9167202,9167203,9167204,9167205,9167206,9167207,9167208,9167209,9167210,9167211,9167212,9167213,6474302,10427615,10427616,10155428,10890026,10910480,10161653,10161654,10161655,10161656,10161657,10162133,10876583,10876584,10876585,10876586,10876587,10881916,10881917,10881918,10881919,10881920,10881921,10881922,10881923,10881924,10881925,10881926,10881927,10881928,10881929,10881930,10881931,10881932,10881933,10881934,10881935,10881936,10881937,10881938,10881939,10881940,10881941,10881942,10608586,10608587,10608588,10608589,10608590,10608591,10583779,10583780,10583781,10647158,10647159,10647160,10647161,10647162,10647163,10647164,10647165,10647166,10647167,10647168,10647169,10647170,10647171,10647172,10647173,10647174,10647175,10647176,10647177,10647178,10647179,10591006,10591784,10591785,10579796,10508122,10507488,10507489,10507490,10507494,10507038,10507039,10507040,10507041,10507042,10507043,10507044,10507045,10507046,10507047,10507048,10507049,10507050,10507051,10507052,10507053,10507054,10507055,10422165,10507056,10507057,10507058,10507059,10507060,10413308,10409408,10409409,10409410,10409411,10409412,10409413,10409414,10409415,10409416,10409417,10409418,10409419,10409420,10409421,10488183,8562506,10413904,10410754,10487519,8562182,8562183) 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'