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(8630854,8630855,8630902,8630903,10861585,8631146,8631712,10850020,8632393,8632394,8632514,8632566,8629765,10860868,10860869,10860985,10860988,10860992,10860996,10866228,10866229,10866231,10866242,10866243,10866245,8627707,8627708,8627709,8627710,8627711,3238537,3238538,7201629,7201866,7201959,10857229,8626708,7200409,8627071,8627072,8627073,8627074,8627075,8627076,8627077,8627078,8627079,8627080,8627081,8627082,8627083,8627084,8627085,8627086,10857892,7201000,7201001,7201002,7201003,7201132,7201133,7199053,10856137,8626089,8626090,8626091,8626092,7199776,10857127,7197302,7197310,7197321,7197330,7197439,10855091,10855092,10855093,10855107,10855108,10855126,10855130,10855131,10855133,10855138,10855140,10855141,10855144,10855145,10855147,3925320,8905024,8905036,8905039,8905040,8905041,8905066,10852505,10852506,8632622,10615767,10615793,10851974,8634421,8634423,8634426,10613974,10614074,10714166,6669907,10611434,10614443,10614445,10611656,10611856,10612303,10612897,10612898,10610098,10610105,10610106,10610120,10613305,10613306,10117531,6673731,6673733,9911878,9911881,9911886,9911890,9911899,8850118,8850120,8850121,8850122,8850123,8850124,8850125,8850126,8850127,9912778,8850507,8850508,8850509,8848132,8848134,6672563,8848192,8848202,10419339,10419340,10419341,10419351,10419353,6672656,6672657,6672658,6672663,6672666,10415481,6672998,6673004,6673005,6673006,6673007,6673008,6673009,6673146,6673147,6673150,9911258,6670727,10467645,10467652,10467664,10469664,10467689,10467690,10467691,10467699,10467701,10467704,10467721,10467727,10467743,10467744,10467751,10467752,10467753,10467755,10467756,10467757,10467772,976546,8848049,8848055,8848056,8848107,8848109,8848110,10889236,10889813,10883156,10883159,10883175,10883183,10883186,10883203,10883207,10883208,10883209,10883212,10161754,10876749,10602473,10647366,10507589,10507800,10411252,10407462,10410294,10410309,10410310,10410322,10410333,10408651,10408971,10414994,10415010,10415013,10415017,10415021) 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>