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(10447885,8631587,9215865,10437271,8575665,8632291,8632292,8632337,10860578,8559384,10999127,10999128,10931826,10931836,10843430,10843431,10843432,10843433,10843434,10843435,10843438,8836320,10859192,3237395,7071260,7071261,7071264,7071297,7071298,7071299,7071300,7071301,7071303,8910465,7200779,10102686,10102687,10857987,10857989,10102911,10102924,10102925,6000196,11011612,11011613,10863547,10863548,7198730,7198759,7198762,8615509,8625320,8625321,8625322,3926114,10856248,10856250,8557306,8557308,8557331,8557332,8557335,8557336,10101564,10101565,10101566,10853409,10853410,10623768,10623769,10623770,3234356,10838965,10838968,10838969,10838974,10838975,10838976,10838980,7197795,7197796,11008235,7197806,7197807,10995299,10995300,10995301,10995302,10995303,10995524,10995525,10995526,10995527,10995528,10995529,10995530,10995531,8905259,8905261,3232901,10425358,10425388,10620303,3581911,8633970,8904405,8634478,8634479,8634485,8634486,8634487,8634488,8634489,8634490,8634491,10427274,10610995,10610996,8853320,8853321,8853322,8853323,8853324,8853325,3654923,8864244,8864248,8864249,10611406,10611407,10611408,10611422,10611426,10559609,10612381,9212316,9212317,9188329,9188330,9188331,9188415,9188416,9188417,9188418,9188419,9188420,9188421,9188422,9188423,9188424,9188425,9188431,7058620,10613737,9197141,8567770,9169407,8849319,8849329,10117784,10117785,10117817,8592897,10517670,6673100,8848740,8848755,8848761,8848765,8848769,8848770,8848790,8848810,8848843,8848866,8848885,8848889,8848903,10417080,10417081,10122528,10122548,10122549,10122550,10122551,8847511,8550898,9192132,8848014,8848024,9192202,9192203,10884085,10890169,10905218,10905219,10172410,10172425,10172426,10172427,10172428,10172429,10172430,10172431,10172432,10625935,10625936,10568116,10568117,10568118,10568119,10568120,10568306,10568307,10568308,10568309,10603684,10606914,10651651,10651652,10607607,10607608,10544477,10507920,10507921,10425031,10425032,10425033,10425054,10411336,10411338,10486100,10486101,10486102,10486103,10409564,10409565,10486442,10486443,10412532,10412573,10412575,10493296) 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>