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(10951074,8573595,7067652,7067653,8595454,8066079,8835210,8835211,8835212,8835213,8835214,8835215,10840660,11048647,11036497,11008097,3234942,10619940,10619941,10619942,10619943,10619944,10619945,10619946,10619947,10619948,10619949,10619950,10619951,10619952,10619953,7155511,7155512,7155513,7155514,7155515,8612749,8570038,8540801,10966061,10966062,10966063,10966064,10966065,10966066,10966067,10966068,10966069,10966070,10966071,10966072,10966073,10966074,10966075,10966076,10966077,10966078,10966079,10966080,10966081,10966082,10966083,10966084,10966085,10966086,10966087,10966088,10966089,10966090,10966091,10966092,10966093,10966094,10966095,10966096,10966097,10966098,10966099,10966100,10966101,10966102,10966103,10966104,10966105,10966106,10966107,10966108,10966109,10966110,10966111,10966112,10966113,10966114,10966115,10966116,10966117,10966118,10966119,10966120,10966121,10966122,10966123,10966124,10966125,10966126,10966127,10966128,10966129,10966130,10966131,10966132,10966133,10966134,10966135,10966136,10966137,10966138,10966139,10966140,10966141,10966142,10966143,10966144,10966145,10966146,10966147,10966148,10966149,10966150,10966151,10966152,10966153,10966154,10966155,10966156,10966157,10966158,10966159,10966160,10966161,10966162,10966163,10966164,10966165,10966166,10966167,10966168,10966169,10966170,10966171,10966172,10966173,10966174,10966175,10966176,10966177,10966178,10966179,10966180,10966181,10966182,10966183,10966184,10966185,10966186,10966187,10966188,10966189,10966190,10966191,10966192,9913626,9913627,9913628,9913629,8542630,8566991,9197043,8853062,9185597,7056078,7056079,7056080,7056081,7056082,6674666,6674667,6674668,8850560,4971341,4971342,4971343,4971344,8550389,8550390,9175372,9175373,9175374,9175375,9175376,9175377,9175378,9175379,9175380,9175381,9175382,9175383,9175384,9175385,9175386,9175387,9175388,9175389,9175390,9175412,10893510,10893511,10893512,10163837,10163838,10163839,10163840,10163841,10163842,10163843,10163844,10163845,10163846,10163847,10163848,10163849,10163850,10163851,10163852,10163853,10163854,10163855,10648737,10648738,10648739,10648740,10648741,10521782,10521783,10521784,10521785,10521786,10521787,10521788,10521789,10521790,10521791,10521792,10521793,10521794,10521795,10521796,10521797,10521798,10477279) 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>