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(10870833,10870860,10870867,10870871,8569750,8569751,10850061,10973348,10973349,10973350,10973351,10973352,10973353,10973354,10973355,10973356,10973357,10973358,10973359,10973360,10973361,10973362,10973363,10973364,10973365,10973366,10973367,10973368,10844110,8617299,4430266,4430267,4430268,4430270,10102982,8072358,8072362,8072364,8072391,8072392,8072449,11007919,4938096,4938100,4938102,4938129,4938130,4938187,10951871,10614552,10614553,6670317,10118315,6679015,9191911,9191912,9191924,9191929,10908858,10909150,10895334,10905426,10187080,10187081,10608602,10608609,10545463,10545464,10545465,10545466,10545467,10545468,10545469,10545470,10545471,10545472,10545473,10545474,10545475,10545476,10545477,10545478,10545479,10545480,10545481,10545482,10545483,10545484,10545485,10545486,10545487,10545488,10545489,10545593,10545594,10545595,10545606,10545607,10545608,10545609,10545610,10545611,10545612,10545613,10545614,10545615,10545616,10545617,10545618,10545619,10545620,10545621,10545622,10545623,10545624,10545625,10545626,10545627,10545628,10545629,10545630,10545631,10545632,10545633,10545634,10545635,10545636,10545637,10545638,10545639,10545640,10545641,10545642,10545643,10545644,10545699,10545700,10545709,10545710,10545711,10545712,10545713,10545714,10538770,10553059,10553060,10553061,10553062,10553063,10553064,10553065,10553066,10508301,10508302,10422469,10422496,10422504,10422508,10407495,10487491,10487494) 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>