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(8839040,8575149,8575150,8575166,8583487,10849341,8583656,7066266,8573309,8573310,8573311,8594636,8594942,10866612,10866616,10866617,8595109,8595112,8595113,8595116,3237391,8910445,8910446,8910447,7201040,7201041,7198709,7198717,7198728,7198729,7198746,10856184,10617453,10617454,10954113,10954114,10617573,10425553,10425555,10425577,10620301,10620302,10620303,10930631,8904348,8611319,8853177,8853216,8853219,8853220,8853221,8853222,8853223,8853224,8853225,8853226,8853227,10714024,10611396,10611406,10611407,10611426,10611432,10611457,10611891,10611892,10612086,10119814,9169310,8849317,8849319,8849329,8849378,9911858,9912815,8850815,9160334,8848166,6672770,10419497,10419498,6672784,6672808,6672829,6672830,6672864,6672868,6672890,6672892,6673010,8848716,8848725,8848726,8848727,8848728,8848733,8848740,8848745,8848755,8848756,8848760,8848761,8848765,8848769,8848770,6673162,8848781,8848782,8848790,6673174,8848810,6673196,8848820,8848828,8848843,8848848,8848849,8848866,8848885,8848889,6673271,6673277,8848903,6673288,6673297,6673299,6673300,6673308,10471175,8847266,8847268,8847270,8847271,8847272,8847273,8847274,8847276,9167533,976360,976362,976367,8847469,8847485,8847491,8847495,8847498,8847499,8847511,8847514,976476,8847529,8847533,8847540,8847541,8847542,8847578,8847998,8848001,8848003,8848005,8848014,8848021,8848024,8848028,8848050,8848059,8848062,8848064,8848067,8848100,8848101,10883559,10883560,10883561,10883568,10883585,10883586,10883587,10883588,10883622,10883624,10883625,10883659,10894377,10894380,10884787,10884793,10875001,10890169,10890170,10890171,10888339,10883429,10887226,10887227,10602160,10602161,10602163,10602164,10602165,10602166,10602167,10602168,10602169,10602185,10602690,10602691,10602692,10602693,10602696,10602697,10602704,10602705,10602707,10602708,10602722,10602726,10603684,10603692,10603693,10601436,10601687,10601693,10601695,10411281,10496935,10496936,10496937,10496983,10496984,10478007,10478008,10478009,10478010,10478011,10478012,10478013,10497037,10497038,10497039,10497040) 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>