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(8838620,9214830,11041648,8584021,8584022,10850054,10860309,10939174,10845611,10845616,10845617,10845618,10845619,8559178,8559179,8559180,8559181,8559182,8559183,8559184,8559185,8559186,8559187,7064373,10866792,10866793,10866794,10866795,10866796,10986330,10986331,10986332,10843544,10843545,10843546,10932148,8618984,8618985,8618986,8618987,8618988,8618989,8595809,8836974,7073708,7073709,7073710,7073711,11048971,8558290,11011507,11011508,11011509,11011510,11011511,11011512,11011513,11011514,11011515,11011516,11011517,11011518,11011519,11011520,11011521,11011522,11011523,6000121,11011524,6000122,11011525,6000123,11011526,6000124,11011527,6000125,11011528,11011529,11011530,11011531,11011532,11011533,11011534,11011535,11011536,11011537,11011538,11011539,11011540,11011541,11011542,11011543,11011544,11011545,11011546,11011547,11011548,11011549,11011550,11011551,7198929,10864012,3926890,10958206,10958283,10101753,10853305,10853306,10853307,10853311,10853312,10853313,10618281,10618325,11032992,11032993,11032994,11032995,11032996,11032997,11032998,11032999,11033000,11033001,11033002,10623491,11033159,11033160,11033161,11033351,11046791,11046792,10855061,10855062,10427345,10954017,10954018,3230549,8570210,8570211,8570212,10952176,10616052,10852017,10562676,10562677,10562678,10714421,10612290,9188199,7058535,7058536,10613643,10121236,9193505,10515543,9161779,8592968,976319,976320,10417417,10116713,10116714,10116733,10116734,10419656,10419657,10419658,6681313,6667579,10123866,10123867,10123868,10123869,10123870,10123871,10123872,10123873,8917706,8917707,8917708,8917709,8917710,10884208,10884211,10884215,10628945,10628946,10628947,10628948,10628949,10628950,10628951,10889765,10879905,10900357,10877725,10877726,10877727,10176722,10176723,10176724,10176725,10912086,10601405,10607471,10601567,10544216,10544217,10544218,10544219,10544220,10544221,10544222,10544223,10544224,10544225,10544226,10544227,10544228,10544229,10544230,10544231,10544232,10544233,10544234,10526329,10526330,10526331,10526332,10526333,10526334,10526335,10526336,10526337,10526338,10526339,10526340,10526341,10526342,10526343,10526344,10526345,10526346,10526347,10526348,10526349,10526350,10526351,10526352,10526353,10526354,10526355,10526356,10526357,10526358,10526359,10526360,10526361,10526362,10526363,10526364,10526365,10526366,10526367,10526368,10526369,10536965,10536966,10525003,10525004,10483987,10409477,10409478,10409479,10409481,8562862,10407954,10410274,10410275,10408685) 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>