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(9214835,9214836,9214837,7068291,7068310,10976041,8574558,8574559,3228870,10870825,10873852,10870878,10873881,10873882,10870888,10870889,10870891,8569822,8569830,8569831,8569832,8569833,8569834,8569835,8569836,8569837,8631508,8631533,8569870,8569871,8569872,8569873,8569874,10950644,10871311,10868608,8622280,8622281,8622282,10871875,10951353,11042429,8632558,8591211,8591212,8591213,8591214,8591215,8591216,8560944,8560945,8068013,8068014,8068015,8068016,8068017,8629780,8573329,8629798,8629803,10498000,10498001,10498002,10498003,10498004,10498005,10498006,10498007,10498008,10498009,10498010,10498011,10498012,10498013,10498027,10498028,10498029,10498030,10498031,8629892,10498046,10498047,10498048,8591498,10498081,10498082,10498083,10498084,8591527,10498094,8591537,10498095,8591538,10498096,8591539,8591540,8591541,8591542,8591543,8591549,8591553,8591554,8591555,8629964,8629986,8630114,8630115,8630116,8068386,8068387,8068388,8068389,8068390,8068391,8068392,8068393,8068394,8068395,8068396,8068397,8630177,8068444,8068445,8068446,8068447,8068448,8068471,8068482,8068483,8630401,7201229,8835489,8835496,8835497,8627840,8627845,8627851,8627861,10960175,8628395,8628396,8628447,8628473,8628476,7202205,7202206,8628648,8628740,3899596,3899597,3899598,8066264,8066265,8066266,8066267,7202568,8066411,8066412,8066413,8066414,8066415,8066416,8066417,8066418,8066419,8066439,8066440,8066459,8066460,8066461,8066462,8066463,8066464,8066473,8066474,8066492,8066493,8066494,8066495,10859936,10859937,10859964,10859974,10497610,10497611,10497612,10497613,10497614,10497615,10497616,8626786,8626787,8626904,8626923,8626924,8626925,7200822,7200823,10102849,8970220,7068969,7068981,7068982,7068983,8555984,10940774,10940775,10940777,10940779,10855941,10855956,10855957,10856000,10864148,8564732,8564801,8564865,8565098,8626052,10856740,10856742,10864868,8626260,10622987,10853335,10853657,8613241,7197064,7197065,7197066,7197067,10838643,8613771,7197625,10982072,10982073,10982074,10982075,10982076,10982077,10982078,8614247,7197674,7197675,7197701,3234966,3234971,8614489,8614490,8614491,8614492,8614493,10855046,10855047,8555739,10619895,10619896,10619904,8624549,8905217,8905218,8553249,3922838,10837226,11045291,8542212,8542272,8542273,8542274,8542275,8542276,10853078,10837551,10853090,10853092,10993548,8632606,8633102,10615533,8633194,8633297,10616016,9217877,10621262,10621263,10621357,10621358,10621374,3231956,3231957,3231958,3232183,3232192,3232193,3232194,3232244,8634533,8634534,8634535,8634536,8853586,10614563,10611933,9211538,10120068,9211921,9211939,8851770,8851771,8851772,8851773,10612651,8566515,8566516,10612733,10612734,6676415,6676416,6676417,10120412,10120425,10120426,10612937,10610054,10613061,10613062,9212435,9212445,10613113,8863326,8863327,8863328,8863329,8863330,8852729,8863442,3654140,8863472,8863473,8863474,8863475,8863476,8863477,8863478,8863479,8863480,8863481,3654170,8863491,8863492,3654182,8863502,8863503,8863513,8863514,8863516,10117504,10511427,10126212,10126217,10126220,8849973,8849974,10516830,10516831,10516832,10516833,10516834,10516835,10516836,8918221,8918222,8918223,10467240,4972106,4972107,4972108,4972109,4972110,4972111,4972112,4972122,9167296,9167297,9167298,10468035,10468059,10468071,10468072,10468107,9175944,10893800,8069030,8069034,8069135,10948235,10627290,10627292,10164092,10161662,10156709,10172391,10949275,10949276,10949277,10949278,10949279,10949280,10949281,10949338,10949339,10949340,10949341,10949342,10949343,10949344,10949345,10949346,10626138,10626139,10626302,10881993,10881994,10881995,10598596,10608600,10587099,10647380,10590773,10590774,10590780,10590781,10590782,10590852,10654085,10588236,10588237,10585281,10582563,10604549,10579795,10604671,10539120,10539121,10539122,10539123,10539124,10539125,10539126,10539127,10539128,10525277,10525278,10525279,10525280,10525281,10521323,10521362,10521363,10521364,10521365,10521366,10521367,10521368,10521369,10521370,10521371,10521372,10521373,10521374,10521375,10521376,10521377,10521378,10521379,10521380,10521381,10521382,10521383,10521384,10521385,10521386,10521387,10521388,10521389,10521390,10521391,10521392,10521393,10521394,10521395,10521396,10521397,10521398,10521399,10521400,10521401,10528106,10528108,10528177,10522399,10520463,10520464,10528485,10528486,10546720,10546721,10546722,10546723,10538759,10538763,10539100,10539109,10422461,10424479,10424509,10424510,10422526,10422527,10422529,10422794,10510781,10510782,10510783,10510784,10510785,10507803,10508810,10508811,10421104,10423160,10507100,10507101,10507102,10507103,10507104,10507105,10480944,10480945,10480946,10409314,10409315,8562365,10409501,10411656,10411659,10409676,10479630,10479631,10479632,10479654,10479655,10479656,10479657,10479658,10479659,10479671,10479703,10479704,10479724,10479895,10479896,10410260,10410261,10479931,10479932,10414346,10414347,10414359,10414369,10414382,10482092,10482093,10482095,10482118,10482120,10714910,10714930,10497407,10411105,10411106,10411107,10411108,10411172,10411173) 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'