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(11040620,4970921,10862257,11041663,8622031,10847116,10862882,10862883,10862884,10847437,10847438,8067747,8067776,8560885,8560886,8560887,8560888,8560889,8560892,8560893,8560894,8560895,8560900,8560902,8560903,8560904,10858309,10858310,7201900,7201901,7201902,3899426,3899427,3899428,3899429,10843908,11000265,11000266,11000267,11000268,8560734,8560767,8560768,8560769,8560772,8560773,8560774,8560775,8560776,8560783,8560799,8560801,8560807,8560808,8560811,8560812,8560825,8560870,10102094,3927554,3927567,3927568,3927630,10959006,10857688,10857689,10857693,10943160,10943219,10943220,10839726,3656817,3236681,3926915,8616369,3237022,8557850,11032791,11032792,11032793,11032794,11032809,11032810,11032811,11032812,8554340,7157359,11042860,11042861,11042862,11042863,11042864,11042865,11042866,11042867,11042868,11042869,11042870,11042871,11042872,11042873,11042878,11042879,10926320,10926327,10926696,10922170,10927196,10927197,10927198,9171374,10612095,10612096,10610023,9209486,9209487,9209490,9209494,9209500,9209517,9209518,9209519,9209520,9209524,9209527,9209528,10515787,10515788,10515789,10515790,10515791,10515792,9912478,9171214,10416448,10416449,10416450,10416451,10416452,4973761,10462994,8864966,8864989,8865005,8865006,8865112,8865115,8865124,8865125,9207231,9207232,9207555,9207874,9207880,9208036,9208037,9208042,9208048,9208049,9208108,10154576,10158649,10171594,10631317,10650870,10650871,10650872,10645327,10645328,10542013,10492426,10492427,10492428,10492429,10492430,10492431,10492432,10492433,8562843,10480477,10480478,10480479,10480480,10480481,10480482,10480483,10480484,10412842,10412843,10487618) 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>