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(8630867,8630868,8631185,8631186,8631187,8631189,8575733,8575734,8575735,8630284,10930095,7201730,8629097,8629098,8629100,9794578,9794579,9794580,9794592,9794594,8626900,8626901,8834762,8834763,7200901,10866017,7198712,7198736,8626221,8626222,8626444,8626445,8626447,8626448,8626449,8626450,8626452,8626453,8626454,8626455,8626457,8626458,8626459,8626460,8626461,8626463,8626464,3923593,8542254,8632764,10951828,10620303,8633252,10615722,8540633,8634487,8634496,8634501,8634508,8634523,10565319,10614376,10614499,10614501,8566665,8567072,8567073,10610901,9169318,6674326,9913369,8848771,10419172,8847493,8847496,8847500,8847541,8847542,8847584,8847613,8848050,8848094,10888565,10888566,10883588,10889019,10889020,10889021,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890161,10890162,10890173,10890174,10890175,10162113,10886878,10886910,10887052,10882359,10887464,10602184,10598867,10543041,10498367,10498499,10507721,10507724,10507804) 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>