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(10845761,8620876,11001743,7076069,7076089,7076090,4970545,4970685,3228907,10944082,11041395,10944238,4968375,4968376,3229603,3229606,10990026,10990027,3229765,7074356,10964059,3229830,3229851,3229854,8575809,3230144,3230148,3230229,7067054,7075058,3227625,3227634,11040013,11040042,4969610,10939185,8620416,10860956,10931693,10931789,10999531,10999553,10986762,10986763,8910270,8834805,8834814,8834816,10842219,7071533,10858073,8908404,10941063,8908757,10101365,10954848,11007137,11007154,10623585,10623928,10623929,10623931,11046624,8907000,3234466,7197457,10624531,8614464,8614467,8614500,10922665,8578365,10622415,11045086,10837214,10967149,10923128,10923156,10923165,10923180,10923197,8542254,10990745,10951894,10952576,8610841,10952744,8540672,10922005,8541032,8611638,8611639,10616931,8552856,9189412,10122054,10122056,10122060,8542492,10609310,10120247,10120248,3653454,3653469,9220289,9220296,9220301,9220302,3653572,7058900,9204915,9164984,7059157,7059161,7059165,7059169,7059171,7059446,10125744,10125746,10125747,10125748,7055907,4974778,10118261,8850518,8552210,8552211,10514791,10514792,10514793,8850884,8851061,9160481,4973664,7055459,8549593,10465328,4971652,6667231,10466524,10462632,10464668,10464673,10898901,10947328,10629500,10186152,10880196,10875196,10186354,10890420,10890427,10890429,10161482,10887652,10887653,10900952,10896252,10896253,10881278,10881554,10881608,10886789,10886790,10901794,10605194,10605195,10602545,10602936,10647759,10590790,10590791,10645630,10649036,10541426,10545553,10527730,10537904,10537905,10538702,10508823,10508824,10407270,10407272,10407273,10407274,10407275,10407277,10407279,10407280,10407283,10494998,10412652) 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>