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(10843203,7201768,10198399,10198400,10198401,10198402,10198403,10198404,10198405,10198406,10198407,10198408,10198409,10198410,10198411,10198412,10198413,10198414,10198415,10198416,10198417,10198418,10198419,10198420,10198421,10198422,10198537,4970858,4970859,4970860,8596067,10844501,10929301,10929302,8573403,8573404,7066749,7066750,7066751,7066752,7066753,7066754,7066755,7066756,7066757,8834874,7066889,10236605,10236606,10236607,10236608,10103382,10103383,10103384,10103385,7072075,10234792,8615999,10857193,10857194,10857195,10102120,10102123,10102138,10857472,8626947,3235016,3235017,3235018,3235019,3235020,10855023,10855024,7198048,10246520,10246521,10246522,10246523,10246524,10246525,10246526,10246527,10246528,10839630,10839631,10839632,10839633,10839634,8908059,8908224,8905781,3923726,3923727,3923728,3923729,3923730,3923731,10866875,8554582,8554583,8554584,10838784,10867330,10867331,10867332,10867333,10867334,8860482,8860483,8860484,8860485,8860486,8860487,8860488,10863888,10618236,10618237,8540586,8611861,8611862,8611863,8611864,8611865,8611866,8611867,8611868,8611869,8611870,8611871,8611872,8611873,8611874,10282748,8611875,10282749,10282750,8611876,8611877,8611878,8611879,3230004,3230005,3230006,3230007,3230008,3230009,3230010,3230011,3230012,3230013,3230014,3230015,3230016,3230017,3230018,3230019,3230020,3230021,3230022,10860977,8621140,10616220,10616258,10616295,10616303,10616304,10616305,10616306,10616341,10616342,10616345,10616346,10616350,10616351,10616352,10616384,10616385,10616386,10616388,10616389,10616390,10616398,10616430,10616431,10616458,10227751,10227752,8583590,10279838,10279839,10279840,10614058,10614059,10614060,9189587,9189588,9189589,9189590,9189591,9189592,9189593,9189594,9189595,10614732,10614733,10614734,9211723,7057921,9171957,9171958,9171959,9171960,9171961,9171962,9171963,9171964,9171965,9171966,9171967,9171968,9171972,9171973,9171974,9171975,9171976,9171977,9171978,9171979,9171980,9171981,9171982,9171983,9171984,9171985,9171986,9171987,9171988,8566605,8862680,8862681,8862682,3653536,3653537,3653538,3653539,3653540,8566841,7017996,7017997,7017998,7017999,7018000,7018001,7018002,7018003,7018004,7018005,7018006,7018007,7018008,7018009,7018010,7018011,7018012,8852580,8852582,8852593,8852594,8852596,8852607,8852611,8852615,8852621,8852631,8852632,8852635,8852644,8852645,8852648,8852652,8852659,8852671,8852677,8852819,10513865,10513873,10513874,10513875,10513876,10513877,10513878,10513879,10513880,10513881,10513882,10513883,10513884,10513885,10513886,10513887,10513888,10513889,10513890,10513891,10513892,10513893,10513894,10513895,10513896,10513897,10513898,10513899,10513903,10513904,10513905,10513906,10513907,10513908,10513909,10513910,10118987,10118988,10118989,10118990,10118991,10118992,10118993,10417328,9176768,4973664,4973665,4973666,4973667,10420137,10420138,10420139,6666527,6666529,6666530,6666531,6666532,9191117,9191118,9191119,9191120,8916883,8916884,8916885,9183342,9167597,9167864,10893911,10884487,10884488,10884489,10910049,10907788,10907789,10891196,10891197,10891198,10891199,10891200,10891201,10891202,10891203,10891204,10891205,10891206,10891207,10891208,10891209,10891210,10891211,10891212,10891213,10891214,10891215,10891216,10891217,10891218,10891219,10891220,10891221,10891222,10891223,10891224,10891225,10891226,10891227,10891228,10891229,10891230,10891231,10630853,10886865,10886866,10611793,10647620,10647999,10648000,10648001,10648002,10648003,10648004,10648005,10651836,10525176,10525177,10525178,10542398,10542399,10542400,10542401,10542402,10542403,10410237,10410238,10410239,10482559,10482560,10482561,10415000,10415001) 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<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>