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(10939800,8838931,10963380,10963472,10963473,11041537,11041568,11041720,11041721,11041722,11041723,11041724,8622081,7066280,10871890,8560990,8560991,8560992,8561024,7067234,7075280,7067439,7067440,7075546,7067640,7075746,8630400,8911535,8911620,8911628,8595499,10104327,8560281,10104474,8560315,8560383,11000230,11049094,3927687,10943255,3238170,3238347,10863246,10863247,10840388,10840389,7198932,8625488,3236729,3656920,8616336,8616337,8557839,10841653,3233443,3233444,3233847,3924094,10618956,8554999,8907284,11008147,10619576,10619577,10619578,10619579,10619580,10619581,10619582,8579051,8632755,8632758,10964923,10964924,10964925,10964926,3230661,10964927,10964928,8633171,3231467,10921608,7027039,9211444,7025124,7058190,8566676,7026206,7026400,7026596,7018642,7026865,8853039,7022979,9209977,9209978,9209979,7023725,7023923,7024335,10516654,7022075,4971207,4971208,7020054,9174705,9174706,9174707,7020582,6474064,6474345,7021869,10169868,10893887,10893888,10169942,10628443,10175108,10163500,10892937,10169029,10631558,10163264,10652311,10583700,10589861,10583862,10587173,10587174,10584460,10522774,10530782,10508616,10423171,10487107,10487318,10487319,10487569,10487570,10495767) 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>