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(3228960,3228961,3229171,10950697,10950698,8595094,7202121,7202122,7202123,7202124,7202125,7202126,7202127,7202131,7202132,7202134,7202135,7202136,7202138,7202161,7202164,7202166,7202169,7202196,7202197,7202205,7202206,5654590,5654591,5654592,5654593,10857374,10857375,10857376,10857377,10857378,10857379,10857380,10857381,10857382,10857383,10857384,10857385,10857386,10857387,10857388,10857389,10857390,10857391,8910162,10857392,10857393,10857394,10857395,10857396,10857397,10857398,10857399,10857400,10857401,10857402,10857403,10958960,10101467,10101468,10101488,10101489,10101490,10101492,3923404,3923482,3923483,8905332,8905333,8905334,8905335,10954225,3581859,10426018,10426468,10426469,10426470,10426471,10426472,10426473,3231701,3231702,8611307,8611308,8611309,8611310,10611727,10611728,10611729,10611730,10611731,10611732,10611733,10611734,10611735,10611736,10611737,10611738,10611739,10611740,10611741,10611742,10611743,10611744,10611745,10611746,10611747,10611748,10611749,10611750,10611751,10611752,10611753,10611754,10611755,10611756,10611757,8851572,8851573,8851574,8851575,10612746,10612747,10612750,10612752,10612754,10612783,10612785,10612786,10612790,10612791,10612792,10612793,10612794,10612796,8852335,8852337,10610793,10117526,10117825,10117826,9912162,9912163,9912164,9912165,9912166,9912167,9912168,9912169,9912170,9912171,9912172,9912173,9912174,9912175,9912176,9912177,9912178,9912179,9912180,9912181,9912182,9912183,9912184,10513988,8552180,8552181,8552182,8552183,9913190,9168299,9168300,9168301,9168302,9168303,9168304,9168305,9168306,9168307,9168308,9168309,9168310,9168311,9168312,9168313,9168314,9168315,9168316,9168317,9168318,9168319,9168320,9168321,9168322,9168454,9168455,6673108,6673109,6673110,8549955,8550012,976467,976468,976469,976470,976471,10468341,10468342,10468343,10468344,10468345,10889437,10884541,10884542,10884543,10884544,10884545,10884546,10884547,10884548,10884549,10884550,10884551,10884552,10884553,10884554,10884555,10884556,10884557,10884558,10884559,10884560,10884561,10884562,10884563,10884564,10884565,10884566,10884567,10884568,10884569,10884570,10884571,10884572,10884653,10890163,10883120,10883121,10883122,10883123,10883124,10883125,10883126,10883127,10883128,10883129,10883130,10883131,10883132,10883133,10161950,10161951,10161952,10161953,10886270,10881555,10881556,10647472,10508329,10507814,10507896,10412134,10412135,10412136,10412137,10412138,10412139,10412140,10412141,10412142,10412143,10412144) 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>