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(8574725,8574769,9215303,9215304,8574841,10940517,10940537,10940538,10951297,10951298,10497839,10497840,10497896,8591419,10498166,10498167,10498168,10498169,10498170,10498171,10498172,10498173,10498174,10498175,8068277,8068278,8068279,8591660,8591661,10498220,8591662,10498221,10498222,8591768,8591803,8591856,8591857,8068547,8068548,8068549,8068550,8068551,8068651,8068707,8835574,8066342,8066361,8066517,8066518,8066519,8066685,8066686,8066687,8066688,8066689,8066795,8066856,8066857,7069015,10981202,10981203,10981204,10981262,10981263,10981264,10981265,10981295,10981379,8613846,8613849,3924438,10979755,10979756,10979757,10979758,10979759,10979760,10979761,10979762,10979763,7155640,10980325,10980326,10980327,10978965,10978966,10979012,10621397,10621398,10621399,10426917,10621673,10979361,10979362,10979363,10979364,10621744,9179410,9179411,9179412,9179528,6676438,6676494,9914541,9914576,6676596,10120587,10120591,9914608,9914609,9914643,8567314,8567341,8567342,8567343,8567377,8849331,7056730,9179142,9179143,9179144,4972173,4972174,4972240,4972241,4972250,4972251,4972252,10898510,10898719,10898800,10898801,10898802,10898803,10898804,10898805,10898806,10898807,10898808,10898809,10898810,10898811,10898812,10898813,10898814,10898815,10898816,10898817,10898818,10898819,10898820,10898821,10898822,10898823,8593877,8593878,8594029,10897843,10897844,10897845,10649804,10649805,10480211,10480212,10714939) 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>