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(8583779,8583780,8583781,8583782,8835570,8835571,10841498,10841499,10841500,10841501,10841502,10841503,10841504,10841505,10841506,10841507,10841508,10841509,10841510,10841511,10841512,10841513,10841514,10841515,10841516,10841517,10841518,10841519,10841520,10841521,10841522,10841523,8613818,3924487,10953185,10979369,10979370,10979371,10979372,10979373,10979374,10979375,10979376,10979377,10979378,10979379,10979380,10979381,10979382,10979383,10979384,10979385,10979386,10979387,10979388,10979389,10979390,10979391,10979392,10979393,10979394,10979395,10979396,8552711,8552712,8552713,8853406,8853407,8853408,6670282,6670283,9179299,9179300,9179301,9179302,9179303,9179304,9179305,9179306,9179307,9179308,9179309,9179310,9179311,9179312,9179313,6676305,9914458,9914459,10120499,8567262,8863618,7056546,7056547,7056548,7056549,7056550,7056551,7056552,7056553,10514200,10514201,7056554,7056555,10514202,10514203,7056556,10514204,7056557,10514205,7056558,10514206,7056559,7056560,7056561,7056562,7056563,7056564,7056565,9179294,9179295,9179296,9179297,9179298,9198936,9198937,9198938,3963411,4972225,4972226,4972227,10154584,10168875,10168876,10168877,10168878,10168879,10168880,10168881,10168882,10168883,10168884,10168885,10945721,10945722,10897981,10897982,10897983,10897984,10897985,10897986,10897987,10897988,10897989,10897990,10897991,10897992,10897993,10897994,10897995,10897996,10897997,10897998,10897999,10898000,10898001,10898002,10898003,10898004,10898005,10898006,10898007,10898008,10898009,10898010,10898011,10898012,10898013,10898014,10898015,10898016,10898017,10898018,10898019,10898020,10898021,10898022,10898023,10898024,10898025,10898026,10523790,10523791,10523792,10523793,10523794,10523795,10523796,10523797,10523798,10523799,10523800,10523801,10523802,10523803,10523804,10523805,10523806,10523807,10523808,10523809,10523810,10523811,10523812,10523813,10523814,10523815,10483005,10483006,10483007,10483008) 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>