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(7200285,7200286,7200287,7200288,7200289,7200290,7200291,7200292,7200293,7200294,7200295,7200296,7200297,7200298,7200299,10985195,10985196,10985197,7198251,7198386,8906783,3925035,10616372,10616373,10616374,10616375,10616376,10616377,10616378,10616379,10616380,10616381,10616382,10616383,10616384,10616385,10616386,10616387,10616388,10616389,10616390,10616391,10616392,10616393,10616394,10616395,10616396,10616397,10616398,10616399,10616400,10616401,10616402,10616403,10616404,10616405,10616406,10616407,10616408,10616409,10616410,10616411,10616412,10616413,10616414,10616415,10616416,10616417,10616418,10616419,10616420,10616421,10616422,10611572,10611573,10611574,10611575,10611576,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611591,10611592,10611593,10611594,10611595,10611596,10611597,10611598,10611599,10611600,10611601,10611602,10611603,10611604,10611605,10611606,10611607,10611608,10611609,10611610,10611611,10611612,10611613,10611614,8851263,8851264,8851265,8851266,8851267,8851268,8851269,8851270,8851271,8851272,8851273,8851274,8851275,8851276,8851277,8851278,8851279,8851280,8851281,8851282,8851283,8851284,8851285,8851286,8851287,8851288,8851289,8851290,8851291,8851292,8851293,8851294,8851295,8851296,8851297,8851298,8851299,8851300,8851301,8851302,8851303,8851304,8851305,8851306,8851307,8851308,8851309,8851310,8851311,8851312,8851313,8851314,8851315,8851316,8851317,8851318,8851319,8851320,8851321,8851322,8851323,8851324,8851325,8851326,8851327,8851328,8851329,8851330,8851331,8851332,8851333,8851334,8851335,8851336,8851337,8851338,8851339,8851340,8851341,8851342,8851343,8851344,8851345,8851444,8851445,8851446,8851447,8851448,8851449,8851450,8851451,10610014,8852644,8852645,8852646,8852647,8852648,8852649,8852650,8852651,8852652,8852653,8852654,8852655,8852656,8852657,8852658,8852659,10610739,10610740,10117818,10427899,10471082,9182545,9182546,10469535,10470672,10483193) 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>