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(10447818,10448055,8838685,8838686,10845967,10846061,8631084,8631085,8631086,8621708,8621733,8621755,8621785,7074112,7074113,8067205,8631868,8631869,8631870,8631871,8631872,8631889,8631890,10871631,10871713,8619773,8619784,8619819,8619975,8837701,8620056,8629876,8629877,8837757,10872574,10498185,8620278,8630258,8617671,8617672,8910995,7201522,8559489,7072594,8836288,7072805,7072806,7072857,7072900,7072901,7073015,8619377,8909891,8909921,8617080,8617086,8617119,8617191,8627007,8910524,8617362,8617456,7071704,4430376,4430407,4430421,8624803,8624804,8624805,8615004,3925567,8625078,8625080,8625082,8625083,8625087,8625090,8625092,8625094,8625097,8625098,3656230,3926061,3926063,3656722,8909142,8909238,8909239,8909287,8909288,8909505,8909506,8909543,8909760,8909761,10942459,3927141,10918611,8906061,8906151,7196404,10918850,10918851,8906349,8906350,10919513,10919574,10919575,10919576,10919577,10919578,10919579,10839265,10852529,10920559,10920653,10920654,10920655,8632802,10425550,10920876,10920982,10921054,10921055,10921078,10921079,10921080,10921081,10921082,8576604,8633135,8633199,10615829,10620863,10615878,8633381,8577009,10921571,10921572,10921676,8577238,10921737,10921738,10921755,10921756,10921757,8577361,8577403,10917070,8577803,10559392,6669804,6677898,9190002,9916239,9916240,8853887,6678287,8853916,9916339,9190151,9190184,10122439,8854076,10122476,8854104,9203322,9195437,9195438,9203453,9203454,9203455,9203480,9195627,9195628,9195629,9195630,9195709,9195710,9203807,9187985,9203999,9204000,9204001,9204120,9204121,9204122,9188122,7058290,9188125,9204210,9204214,9188258,9212322,9204373,10613083,9204496,9204535,7058719,7058720,7058721,7058725,9204575,9204584,8852427,8852479,8852486,10610769,9193371,9193385,9193444,10555359,10555360,10555361,10555362,10555363,10555364,8849377,9193606,10555430,10555431,10555432,10555433,10555434,10555435,8849447,8849458,6673865,9193708,8849561,8849584,9201825,6674045,7023570,9912248,9194052,9194053,9194054,9194055,9194090,9194091,9194092,9202241,9194476,10556295,10556296,10556297,9202543,9202544,9202545,9912761,9194594,9194595,9194596,9202827,9202828,9202829,9202830,9202831,9202832,9202833,9202834,9202835,9194847,9194848,9194849,9194850,9194851,9194852,9194853,9194854,9194855,9194856,10556705,9203251,9203252,9203253,9203254,9203289,9160373,6680596,8848256,9200458,8848327,8848328,6680871,6680885,10428254,8848968,8848971,8849030,8849031,9916555,8854255,8854282,9916708,9916763,9916764,8854430,6678830,8854459,6678915,10463429,10463430,10463431,10463432,10463433,10463434,10463435,10463436,10463437,10463438,10463439,8550201,8854948,8847369,10470382,8847651,8847718,10470486,10470491,9200010,10124405,9200260,10888872,10179886,10179988,10913992,10913993,10913994,10180048,10180049,10909077,10909078,10909088,10909089,10909090,10909091,10909092,10909093,10904199,10904200,10909314,10909402,10904456,10904457,10904458,10909476,10909477,10909478,10909479,10909480,10909481,10909482,10909502,10909503,10909504,10909505,10180538,10914635,10904660,10904661,10909683,10909684,10909685,10909686,10904696,10904697,10909819,10909861,10180879,10180880,10180881,10180882,10904893,10180926,10180927,10629581,10629609,10181169,10181210,10181211,10181212,10629690,10181430,10181431,10629914,10629915,10629916,10629917,10181473,10183565,10183566,10183604,10183605,10183606,10183607,10183608,10183720,10183746,10168767,10168768,10168769,10168770,10627294,10912922,10912923,10912924,10888094,10888329,10888330,10174448,10905717,10181734,10181735,10181736,10181737,10181963,10181964,10182003,10182004,10182032,10182033,10182173,10182201,10182343,10182364,10906357,10177433,10177438,10182461,10182470,10162543,10182570,10182604,10182605,10182606,10182796,10182797,10172868,10172869,10182972,10177973,10183055,10183071,10183136,10183301,10183315,10183316,10183404,10183475,10183476,10577444,10602500,10571732,10571733,10574759,10574793,10574816,10574817,10571821,10571822,10571823,10571824,10571825,10577852,10577853,10577854,10577855,10577856,10577857,10577858,10577859,10577860,10577861,10577862,10652938,10653122,10653123,10578065,10578066,10578067,10578068,10653139,10653140,10653172,10575120,10575164,10575165,10575166,10572306,10575368,10575422,10575423,10575424,10575425,10575426,10575427,10575428,10575429,10575430,10575431,10578436,10578437,10578438,10569500,10569501,10569539,10569540,10569541,10569542,10575548,10575549,10575550,10575551,10575757,10575827,10569886,10569887,10569888,10570084,10570085,10579089,10579090,10579091,10579092,10579093,10579094,10579095,10579096,10570103,10576174,10579433,10570557,10570558,10604420,10604438,10573686,10573687,10571082,10571083,10553177,10535284,10535285,10535286,10525326,10535381,10535382,10535383,10535384,10535385,10535386,10535387,10551478,10551479,10551480,10551481,10551482,10551483,10551484,10551485,10551486,10551487,10551488,10551489,10551490,10551491,10551492,10551493,10551494,10551495,10551496,10551497,10551498,10553541,10553542,10539576,10539577,10551580,10539613,10539614,10539678,10529679,10529680,10529681,10539702,10535864,10553864,10535865,10553865,10535866,10553866,10535867,10553867,10553868,10553869,10535969,10535970,10535971,10535972,10535973,10535974,10554258,10552260,10552261,10536404,10536405,10552429,10534635,10554667,10554668,10554669,10554670,10554671,10554672,10554673,10554674,10554675,10554676,10554677,10554678,10554679,10554680,10554681,10554682,10554683,10554684,10554685,10554686,10554687,10554688,10554689,10554690,10554691,10554692,10554693,10554694,10554695,10554696,10554697,10554698,10554699,10554700,10554701,10554702,10554703,10554704,10554705,10554706,10554707,10554708,10554709,10554710,10554711,10554712,10554713,10554714,10554715,10554716,10550881,10550882,10534891,10534892,10534893,10526903,10526904,10526905,10526906,10526907,10526908,10526909,10526935,10526936,10487924,10493988,10494006,10488006,10494126,10497313,10497324,10493409,10408993,10493712,10493733) 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'