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(8630758,10989061,10874040,10874043,10874046,10871891,10871893,10103480,8911688,8911689,8911690,8911691,8911692,8911693,8911694,8911695,8911696,8911697,8911702,8618679,8596098,3237370,3237371,8626826,7071453,8558466,8558468,3655646,3655647,3655648,10996014,8908457,10996728,10101211,3926732,10854391,8070880,3235339,10927866,8541934,10990790,10990791,10990806,10990819,10990828,10990829,10848058,10952571,10559619,10559620,10559621,10559623,10559700,6666268,8542658,9188868,9188909,9197095,9197115,9197120,10117994,10122616,9198421,8854862,8854863,6667450,6667453,10628445,10893990,10589365,10588873,10588874,10588875,10588876,10588877,10588878,10588879,10588880,10588881,10588882,10588883,10588884,10588885,10588886,10588887,10588888,10588889,10588890,10588891,10588892,10588893,10588894,10588895,10588896,10588897,10588898,10588899,10588900,10588901,10588902,10588903,10588904,10588905,10588906,10588907,10588908,10588909,10588910,10588911,10588912,10588913,10588914,10588915,10588916,10588917,10588918,10588919,10588920,10588921,10588922,10588923,10588924,10588925,10588926,10588927,10588928,10588929,10588930,10588931,10588932,10588933,10588934,10588935,10588936,10588937,10588938,10588939,10588940,10588941,10588942,10588943,10588944,10588945,10588946,10588947,10588948,10588949,10588950,10588951,10588952,10588953,10588954,10588955,10588956,10588957,10588958,10588959,10588960,10588961,10588962,10588963,10588964,10588965,10588966,10588967,10588968,10588969,10588970,10588971,10588972,10588973,10588974,10588975,10588976,10588977,10588978,10588979,10588980,10588981,10588982,10588983,10588984,10588985,10588986,10588987,10588988,10588989,10588990,10588991,10588992,10588993,10588994,10588995,10588996,10588997,10588998,10588999,10589000,10589001,10589002,10589003,10589004,10589005,10589006,10589007,10589008,10589009,10589010,10589011,10521848,10538091,10538092,10528566,10488289,10488291,10410120) 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>