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(11027707,10943605,10943606,7076337,7076339,7076342,7076343,8621181,10861835,3229221,10846702,11028811,8622727,8622729,10961958,10961959,8620119,10872623,11001153,11001279,3899289,8560028,4967899,4967901,10497566,3927877,3927881,3927882,3927884,3927886,3927887,3927890,8064573,10943385,10943390,11034649,11034655,11034659,10944484,10855895,3656365,10101420,3926985,3926986,8834218,7200130,11006626,11006627,11006628,11006629,11006630,11006631,11006686,11006692,11006696,11006697,11006705,11006706,11006707,11006713,11006718,10928611,10928612,10928615,10618305,10618306,10618309,10618310,10618313,10618314,10618315,8554560,10853965,10838652,10838653,10838654,3234380,3234383,10838790,10854369,10624186,10624187,11046895,11046896,11046897,11046898,11046899,11046900,11046909,11046910,11046913,11046914,11046915,11046916,11046917,11046918,11046919,11046920,11046921,11046922,11046923,11046924,11046941,11046942,11046943,11046949,11046950,11046955,11046956,11046957,11046958,11046959,11046960,11046966,11046969,11046986,11046987,8555601,7198021,10425542,10991100,10848476,10848484,10848488,10848489,10848490,10848491,10848492,10921412,10921415,10921416,10426619,8863917,9213655,7059854,9213772,9213788,9213789,9213790,9213791,9213792,9213793,9213794,9213795,9213796,9213797,9213798,9213799,9213800,9213816,9213833,9213840,9213841,9213842,9213843,9213856,9213859,9213860,9213861,9213862,9213863,9213864,9213865,9213866,9213867,9213868,9213873,9213875,9213880,6666274,6666275,6666276,9211961,9211962,9211963,9196162,9201324,9177442,10126141,10126142,10126143,10126144,10126145,10126154,6674272,9202595,8552480,8552481,8552482,8861814,9160514,8918315,10415679,10416865,10428557,9161231,8549902,10463406,9183811,9183812,4972813,10946337,10946339,10946340,10946341,10946342,10946345,10946346,10946347,10946348,10946352,10946765,10155445,10155455,10884604,10890047,10182986,10182987,10182989,10182990,10182991,10182992,10182993,10182994,10599183,10599184,10599185,10599186,10599187,10599188,10578254,10578255,10578256,10578257,10599451,10599465,10599469,10599476,10599482,10599503,10599521,10599522,10599523,10599524,10599525,10599526,10599527,10599528,10599529,10599530,10599531,10599532,10599533,10599534,10599535,10599536,10599537,10599538,10599539,10599540,10599541,10599542,10599543,10599544,10599545,10599546,10599547,10599548,10599549,10599550,10599551,10599552,10599553,10599554,10599555,10599556,10599557,10650617,10599558,10599559,10599560,10599561,10599562,10599563,10599564,10599565,10599566,10599567,10599568,10599569,10599570,10599571,10599572,10599573,10599574,10599575,10599576,10599577,10599578,10599579,10599580,10599581,10599582,10599583,10599584,10599585,10599586,10599587,10599588,10599589,10599590,10599591,10599592,10590593,10599593,10599594,10599595,10599596,10599597,10599598,10599599,10599600,10599601,10599602,10599603,10599604,10599605,10599606,10599625,10599626,10599630,10599639,10599649,10599667,10599671,10599672,10599681,10599693,10599785,10603660,10603661,10603662,10603663,10603664,10603667,10599849,10599855,10599864,10599868,10599872,10599878,10599880,10599891,10599894,10599895,10599896,10599897,10599898,10599899,10599900,10599901,10599902,10599903,10599904,10599905,10599906,10599907,10599908,10599909,10599910,10599911,10599912,10599913,10599916,10599923,10599924,10599930,10599932,10599944,10599948,10599950,10599958,10599959,10599960,10599967,10599978,10599980,10599981,10599984,10599985,10599993,10590996,10599998,10599999,10600000,10600001,10600002,10600006,10600011,10600018,10600019,10600021,10600023,10600026,10600029,10600039,10600044,10600045,10600046,10600047,10600048,10600049,10600050,10600051,10600052,10600057,10600068,10600069,10600070,10600071,10600076,10600081,10600096,10600108,10600119,10600125,10600126,10600127,10600128,10600129,10600130,10600131,10600132,10600133,10600134,10600135,10600136,10600137,10600138,10600139,10600140,10600141,10600142,10600143,10600144,10600145,10600146,10600147,10600148,10600163,10600165,10600170,10600189,10600190,10600193,10600194,10600195,10600196,10600197,10600198,10600199,10600200,10600201,10600202,10600203,10600204,10600218,10524189,10550364,10550367,10531014,10425266,10425272,10484008,10484009,10495020) 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'