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(9214760,11014974,11014975,11014976,11014977,11014978,11015128,11015129,4970738,3228986,3229665,9215902,10951347,10951348,7067614,9214314,9214344,9214375,11014425,10962470,10962471,10962472,10962473,7067887,6000289,10103143,10972797,8559161,10103456,10843707,8595623,8618966,7073137,7073140,7073141,8628805,10844449,10844450,7073701,7073756,8558407,10959182,7200764,11011381,11011420,11011421,11011422,11011423,6000118,3655988,7198737,7198738,7198748,3656187,11009340,11009889,11009890,11009891,11009892,8565004,7200112,7200142,11007199,10968243,7197948,10839674,10839677,10953986,3922861,8542113,3923214,3923215,10848033,10848034,11004513,11004514,11004539,9217527,9217586,9217587,9217588,9217589,9217590,9217591,9217592,9217593,9217594,9217606,9217607,10991671,10991672,10991673,10991674,10991675,10991676,10991677,10991678,9217675,9217676,9217677,9217678,9217679,9217725,10952780,8541247,10616909,9213503,9189710,9189711,7057789,9211968,9212301,9212302,9212303,9212304,9212305,9212306,9212307,9212308,9911586,9911849,6674106,6674107,10126127,10126129,10514485,10514486,10514487,10514488,10514489,10514490,10514491,10514492,10514493,10514494,10514495,10514496,10514497,10514498,10514499,10514564,10514565,10514566,10514567,10514568,10514569,10514570,10514571,10514572,10514573,10514574,10514575,10514576,10514577,10514578,10514579,10514580,10514581,10512582,10514582,10514583,10514584,10514585,10514586,10514587,10514588,10514589,10514590,10514591,10514592,10514593,10514594,10514595,10514596,10514597,10514598,10514599,10514600,10514601,10514602,10514603,10514604,10514605,10514606,10514607,10514608,10514609,10514610,10514611,10514612,10514613,10514614,10415604,10117405,4971353,8549956,9190842,9190845,9190846,9190889,9190890,9190891,9190892,9190893,9190908,9190910,6679308,9167265,9199552,10123820,9167662,10462407,9207964,10884313,10884603,10874992,10905103,10880214,10627182,10627183,10627184,10627185,10627186,10627308,10176701,10176702,10176703,10176704,10176705,10176706,10176707,10161944,10891020,10891021,10911863,10881989,10877104,10877119,10877201,10877202,10882288,10882293,10882400,10882401,10882402,10602237,10652701,10590265,10590500,10606676,10590888,10607415,10607416,10607417,10607418,10546603,10546604,10509275,10488174,10407941,10493048,10493091,10715141,10715142) 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>