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(3229037,7065986,7066094,10860254,10860292,10860293,10860388,10860389,10860422,10860423,10860424,10860425,10860574,10860583,10860587,10859429,10859431,7201110,7198350,7198467,7198577,7198578,7198684,7198703,7198742,7198760,7198767,7198770,7198776,7198777,7198778,7198779,10863823,7198848,8625485,10856761,10864915,10853278,10853279,10853280,10853281,8612892,10853787,10853969,8906782,10838768,10838807,8624476,8905143,8905301,8905325,8905629,7196139,10616021,8540635,8540636,10616632,8611652,8904919,10614166,10609303,10612696,8851872,8851992,10612860,10612861,10612881,10613150,10613151,10613153,10613154,10613173,10613248,10613249,10613250,10613251,10613252,10613253,10613254,10613255,10613256,10613478,10613479,10613480,10613481,10613482,10613483,10613484,10613512,10613569,10613682,10613683,10613711,6673530,6673558,6673569,6673611,6673642,6673644,7055605,7055606,10117821,9911938,10118081,10118122,990461,990463,990465,990466,990467,990543,990544,9912471,9912496,9912497,9912541,9912545,10118557,10118564,9912600,991116,991117,991118,991119,991120,991121,991197,991198,10418223,10417279,9168517,9168866,9168873,9168879,9168908,9168917,9168920,6673360,10468992,10469040,10469076,10469138,10469264,10469265,8549996,976502,976524,976526,10468536,10468537,10468538,10468539,10884630,10882580,10887871,10885575,10885636,10885637,10885638,10885639,10885640,10885641,10885642,10885643,10885684,10885701,10885727,10885813,10885814,10885815,10885875,10885919,10885927,10885940,10162065,10882291,10589826,10606990,10606991,10606992,10606993,10606994,10606995,10606996,10546434,10530689,10530690,10530691,10409465,10409466,10409467,10409468,10411678,10494373,10409765,10409805,10413896,10410019,10481988,10481989,10481990,10481991,10481992,10481993,10481994,10481995,10481996,10414635,10414636,10414637,10414638,10414690,10414691,10414692,10414719,10414720,10414721,10414722,10414829,10414832) 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>