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(9214696,9214739,8630736,8630739,7076131,9214819,8631127,8631192,8631193,8631194,8631195,8631196,8631197,8631198,8631199,8631200,8631201,8631202,8631203,8631204,8631205,8631206,8631207,8631208,8631209,8631210,8631211,8631212,8631213,8631214,8631215,8631216,8631217,8631218,8631219,8631220,8631221,8631222,8631223,8631224,8631225,8631226,8631227,8631228,8631229,8631230,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631238,8631239,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,8631248,8631249,8631250,8631251,8631252,8631253,8631471,8631472,8631473,8631474,10871133,8631588,8631589,10963638,8631636,8631637,8631638,10963717,10963718,8622379,10868926,8632391,8576004,8576005,8576006,8576007,8632484,8632485,8632486,8632487,8632488,8632489,8632508,8632509,8632510,8632511,8632512,8632513,10964553,9216562,9216563,9216564,9216565,9216566,9216567,9216568,9216569,9216570,9216571,9216572,9216573,9216574,9216575,9216576,9216577,9216578,9216579,9216580,9216581,9216582,9216583,9216584,9216585,9216586,8629607,8629613,8629645,11001149,11001151,11001152,7067583,8630303,8630305,8630306,8630307,8630308,8630309,8630310,8630311,8630312,9214445,9214449,9214450,9214451,8630450,8630451,8630452,8630455,9214468,7067913,7075935,10103111,10103112,7201297,10842809,10842810,10103238,8559070,10103265,10103266,10103274,10103284,7064337,7201649,7201650,7201651,7201652,7201653,7201654,7201655,7201656,7201657,7201658,7201659,7201701,7201702,7201703,7201705,3899055,3899056,7201845,10103771,10103822,10960403,10960417,8911817,10843520,10986514,10986515,10843941,10843973,10843979,10960946,10960947,10844164,10104597,10104613,10844260,10844276,10844280,10844283,10844287,10844288,10844290,10844291,10844296,10844304,8629263,8629267,7073635,3227163,10099938,10099972,10099984,10099993,10099994,10100011,10100039,10100062,10100064,8629569,8629571,8629572,8629573,8629574,8626812,8626813,8626814,8626815,3927765,8910469,8910474,8910476,8910478,8910479,8910480,8910481,10102599,7071536,10102673,10998384,11011441,11011444,11011445,11011449,10998509,10103020,10100247,10995887,10941037,8625074,8625075,8625076,8625077,8625089,8625236,11009330,10840466,10840493,10840494,8625591,3926474,3926597,10840971,8625868,8625869,10101396,8626036,10101630,10101631,8626235,7070754,10101958,11010588,10623065,10618229,11006925,11007125,11007149,10623516,10623517,10838480,3234728,11008180,11008181,8624251,8624252,8624345,8624346,10839456,8624409,8624410,8624411,8624412,8624413,8624414,8624415,8624416,8624417,8624418,8624442,10839618,8624514,8624557,8624573,10621974,10966897,8634896,8634897,8634898,8634899,8634900,8634901,8634902,8634903,8634904,8541834,11045038,10954178,10954179,11045260,11045540,3923282,3233316,10837674,9216589,9216590,9216591,9216592,9216593,9216594,9216595,9216596,9216597,9216598,9216599,9216600,9216601,9216602,9216603,9216604,9216605,8632716,8632717,8632718,8570059,8570060,8570061,8632730,8570062,8632731,10425524,10848101,10848102,10848103,10965283,10965284,10965285,10848519,10620800,10848527,10965471,9217779,9217782,10991848,10991853,8634091,8634092,8634093,8634094,8634095,9218142,8634172,8634173,8634196,8634322,8634323,8634327,8634328,8634329,8634337,8634340,8634342,10992402,9189378,8853304,8568057,10614221,7059745,8568380,8568381,8568384,8568385,8568386,8568387,8568388,9916190,10611805,7057471,10612040,7057600,10609311,10563546,10563564,10563565,10563566,10563570,9171954,7058182,7058202,7058203,7058210,7058211,7058231,7058232,7058235,7058236,7058253,7058258,10557969,9196251,10610023,10610327,9914879,9914881,8852540,9915208,8567737,10610911,9173255,7059446,7059447,7059448,7059449,7059450,7059451,7059452,7059453,7059454,7059455,7059456,7059457,10515322,10515323,10515324,10515325,10515395,10515396,10515397,10515398,10515399,10515400,7055799,7055812,7055848,7056035,7056192,7056250,7056255,10118678,7056759,10514789,10514790,7057246,8850955,9913455,6681384,9193183,10122882,9190703,8854619,8854722,8854723,8854724,8854725,8854726,9191094,6667236,6667594,976631,9175976,9191995,10908630,10908631,10908632,10908633,10908634,10908635,10908636,10908637,10893967,10629405,10629493,10880462,10626963,10627113,10627114,10627115,10627145,10173692,10627321,10183901,10627772,10627773,10627779,10627780,10627781,10627782,10627783,10627784,10627785,10627786,10627787,10627788,10627790,10627791,10627792,10627793,10627794,10627795,10627796,10627797,10627798,10627799,10627800,10627801,10627802,10627803,10627804,10627805,10627806,10627807,10627808,10627809,10627810,10627811,10627812,10627813,10627814,10627815,10627816,10627817,10627818,10627819,10627820,10627821,10627822,10627823,10627824,10627825,10627826,10627827,10627828,10627829,10627830,10627831,10627832,10627833,10627834,10627835,10627836,10627837,10627838,10627839,10627840,10627841,10627842,10627843,10627844,10627845,10627846,10627847,10627848,10627849,10627850,10627851,10627852,10627853,10627854,10627855,10627856,10627857,10627858,10627859,10893370,10627860,10627861,10627862,10627863,10627864,10627865,10627866,10627867,10627868,10627869,10627870,10627871,10627872,10627873,10627874,10627875,10627876,10627877,10627878,10627879,10627880,10627881,10627882,10627883,10627884,10627886,10627887,10627888,10627889,10627890,10627891,10627892,10627893,10627894,10627895,10627897,10627898,10627899,10627900,10627901,10627902,10627903,10627904,10627905,10627906,10627907,10627908,10627909,10627910,10627911,10627912,10627913,10627914,10627915,10627916,10627917,10627918,10627919,10627920,10627921,10627922,10627923,10627924,10627925,10627926,10627927,10627928,10627929,10627930,10627931,10627932,10627933,10910548,10890597,10912307,10626929,10626951,10626952,10608026,10608133,10608202,10608203,10608217,10608282,10598521,10598534,10602751,10602931,10602936,10602937,10602958,10602966,10606130,10603204,10606574,10603617,10603627,10603647,10604005,10582190,10604134,10579735,10579736,10579737,10591890,10549730,10549731,10549732,10529732,10529864,10543984,10543985,10543986,10542356,10542357,10543038,10543039,10421237,10422666,10508793,10424988,8562860,10486561,10486562,10486563,10486564,10486565,10486566,10486567,10486568,10486569,10486570,10486571,10489575,10487787,10487789) 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'