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(4970729,10950763,7201193,7201194,10866380,10866381,10866382,10866383,10866384,10866385,10866386,10866387,10866388,10866389,10866390,10866391,10866392,10866393,8595299,7202635,7202669,7202670,7200486,7200487,7200488,10865891,10865898,10865899,10863512,10863513,10863514,10863515,10863516,10863517,7198768,10865192,10865193,10865194,8906853,8906854,8906855,8906856,8906857,8906858,8906859,8906860,10838943,10838944,10838945,10838946,10838947,10838948,10838949,10838950,10838951,10838952,10617099,10617100,10617101,10617102,10617103,10617104,10617105,10617106,10617107,10617108,10617109,10617110,10617111,10617112,10617113,10617114,10617115,10617116,10617117,10617118,10617119,10617120,10617121,10617122,10617123,10617124,10617125,10617126,10617127,10617128,10617129,10617130,10617131,10617132,10617133,10617134,10617135,10617136,10617137,10617138,10617139,10617140,10617141,10617142,10617143,10617144,10617145,10617146,10617147,10617148,10617149,10617150,10617151,10617152,10617153,10617154,10617155,10617156,10617157,10617158,10617159,10617160,10617161,10617162,10617163,10617164,10617165,10617166,10617167,10617168,10617169,10617170,10617171,10617172,10617173,10617174,10617175,10617176,10617177,10615991,10609285,9169914,9169915,9169916,9169917,6674315,6674316,6674317,6674318,6674319,6674320,6674321,6674322,9913326,9913327,9913328,9913329,9913330,9913331,9913332,9913333,9913334,9913335,9913336,9913337,9913338,10419378,10419379,10419380,10419381,10419382,10419383,10419384,10419385,10419386,10419387,10419388,10419389,10419390,10419391,10419392,10419393,10419394,10419395,10419396,10419397,10418503,10418504,10418505,10418506,10417046,10417047,10417048,10417049,10417050,10417051,10417052,10471168,8550254,8550255,10115642,9167778,10889228,10889229,10889230,10890022,10890023,10890024,10890025,10890026,10890027,10890028,10890029,10890030,10890031,10890032,10890033,10890034,10888021,10888379,10888380,10887459,10647689,10647690,10647691,10647692,10647693,10647694,10647695,10647696,10647697,10647698,10647699,10508217,10508575) 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>