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(10871973,10871974,10871975,10871976,10871977,10871978,10871979,10871980,10871981,10871982,8618366,8618367,10986481,8836868,8836869,5654793,11049203,11049204,8910687,8910688,8910689,8910690,5999949,5999951,5999953,5999959,5999960,5999961,5999962,5999963,5999964,5999965,8910756,8910757,8910758,8910759,8910760,8910761,8910762,8910763,8558674,8558675,8558676,8558677,8970231,8970232,3655783,3655784,3655785,11009245,11009246,11009247,11009248,11009249,11009250,11009251,11009252,11009253,11009254,11009255,11009267,11009268,11009269,11009275,7069716,3926657,3926658,3926659,3926662,3926663,11008218,11008222,11008223,11008226,3235249,3235250,3235251,3235252,3235253,3235254,3235255,3235256,10952099,10562112,10562113,10562114,10562115,8863830,8863831,10562202,10562203,10562204,10562205,10562206,10562207,10562208,10562209,10562210,10562211,10562212,9915606,10562213,10562214,10562215,10562216,10562217,10562218,10562225,10562226,9197707,9197708,9197709,9197710,9197711,9197712,9197713,9197714,9197715,9197716,9197717,9197721,8864503,8864504,8864505,8864506,8864509,8864510,10612210,10612211,10612212,10612213,10121038,10121045,10121046,10121047,10562026,10562027,10562028,10562029,10562030,10562031,10562032,10562033,10562034,10562035,10562036,10562037,10562038,10562039,10562040,10562041,10562042,10562043,10562044,10562045,10562046,10562047,10562048,10562049,10562050,10562051,10562052,10562053,10562054,10562055,10562056,10562057,10562058,10562059,10562060,10562061,10562062,10562063,10562064,10562065,10562066,10562067,10562068,10562069,10562070,10562071,10562072,10562073,10562074,10562075,10562076,10562077,10562078,10562079,10562080,10562081,10562082,10562083,10562084,10562085,10562086,10562087,10562088,10562089,10562090,10562091,10562092,10562093,10562094,10562095,10562096,10562097,10562098,10562099,10562100,10562101,10562102,10562103,10562104,10562105,10562106,10562107,10562108,10562109,10562110,10562111,8592966,8592967,976317,10428310,10123648,10123649,10123650,10123651,10123652,10123653,10123654,10123658,10123659,10123660,10123661,10123662,10123663,10628529,10628530,10628534,10628535,10628536,10628537,10171209,10900698,10900699,10910854,10910855,10910856,10910857,10910877,10652399,10652400,10652403,10528020,10528021,10528022,10528023,10528024,10528025,10528026,10528027,10528028,10528029,10528030,10528031,10528032,10528033,10528034,10528035,10528036,10528037,10528038,10423211,10423212,10423213,10423214,10715118) 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>