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(11014855,11014856,11014857,10933336,8560932,10999334,11013299,7071166,11022416,11022417,11022418,11022419,11022463,8909517,10853323,11032849,11032850,11032851,11032855,11032856,10918719,11032920,11032921,11033018,11033019,11033020,11033021,11033022,11033023,11033024,11033025,11033026,11033027,11033028,11033029,11033030,11033031,8554346,8554349,11033208,11033209,11033210,11033211,11033212,11033213,11033214,11033215,11033216,11033217,11033218,11033375,11033376,11033377,11033516,10918272,10918273,10918274,10918275,10918276,10918303,8577666,8577671,10616523,8577693,8577694,8577723,8577724,11005502,11005523,11005524,11005525,11005526,10917441,10917442,10611377,10611385,10611390,10611391,10611395,10611401,10611402,10611463,10611466,10611467,10611510,10611524,10611525,10611526,10611528,10611530,10611534,10611535,10611536,10611541,10611544,10611572,10611584,10611585,10611586,10611588,10611589,10611593,10611595,10611596,10611600,10611652,8854057,8854058,8854082,8851139,8851140,8851141,8851142,8851143,8851144,8851153,8851154,8851155,8851158,8851159,8851161,8851162,8851168,8851263,8851264,8851276,8851281,8851292,8851293,8851294,8851300,8851301,8851302,8851306,8851307,8851308,8851316,8851317,8851318,8851319,8851320,8851322,8851323,8851324,8851468,8850615,8850616,8850619,8850620,8850621,8850631,8850638,8850639,8850640,8850641,8850642,8850643,8850644,8850645,8850646,8850651,8850652,8850658,8850659,8850660,8850661,8850666,8850667,8850674,8850675,8850676,8850677,8850678,8850679,8850680,8850681,8850689,8850690,8850691,8850692,8850697,8850698,8850699,8850700,8850701,8850708,8850744,8850745,8850865,8850909,8850917,8850928,8850929,8850930,8850931,8850932,8850933,8850934,8850944,8850945,8850952,8850953,8850954,8850955,8850959,8850960,8850972,8850973,8850974,8850975,8850979,8850980,8850986,8850993,8851035,8851036,8851121,8851122,8851123,9916634,10179640,10913631,10913632,10179661,10179662,10179663,10179664,10179665,10913668,10908769,10889291,10889305,10889341,10889345,10904404,10904423,10889438,10914769,10909923,10913266,10913267,10906334,10906335,10906336,10177415,10897241,10653118,10409490) 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>