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(8630761,8630762,8630763,8630764,3228946,10861844,10861845,10861846,10861847,10861848,10861849,10861850,3229130,10862082,10862083,10862084,10862085,10862086,10862087,10862088,10862089,10862090,10862091,10862092,10862093,10862094,10862095,10862096,10862097,10862098,10862099,10862100,10862101,10862102,10862103,10862104,10862105,10862106,10862107,10862108,10862109,10862110,10862111,10862112,10862113,10862114,10862115,10862116,10862117,10862118,10862119,10862120,10862121,10862122,10862123,7066142,8573292,8573293,8595065,8065800,7065933,10101469,11048438,11048439,7197373,7197374,7197375,7197376,7197377,7197378,7197379,7197380,7197381,7197382,7197383,7197384,7197385,7197386,7197387,7197388,7197389,7197390,7197391,7197392,7197393,7197394,7197395,7197396,7197397,10855216,10855217,10855218,10855219,10855220,8905089,8905090,8905091,8905092,8905093,8905094,8905095,10617332,10615314,3231053,8611312,7155248,7155300,10614738,8852250,8852251,8852252,8852253,10610252,10610253,10610254,10610255,10610256,10610257,10610258,10610259,10610260,10610261,10610262,10610263,10610264,10610265,10610266,10610267,10610268,10610269,10117554,10117555,6673751,6673752,6673753,6673754,6673755,6673756,6673757,6673758,6673759,10118270,10118271,9912504,8850129,8850152,9912846,9912847,9912848,9912849,9912850,9912851,9912852,9912853,9912854,9912855,9912856,9912857,9912858,6672687,6672688,6672689,6672690,10415686,10415687,10415688,10415689,10415690,10415691,10415692,10415807,10415808,10415809,10415810,10415811,10415812,10415813,10415814,10415815,10415816,10415817,10415818,10415819,10415820,10415821,10415822,10415823,10415824,10415825,10415826,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10415838,10415839,10415840,10117335,7055443,8549958,8549959,8549960,8549961,10467798,10467799,10467800,10467801,10467802,10467803,9167940,9167941,9167942,9167943,9167944,9167945,9167946,9167947,10427664,10427665,10883692,10887669,10887670,10887671,10887672,10887673,10887674,10887675,10887676,10887677,10887678,10887679,10887680,10887681,10887682,10887683,10887684,10887685,10887686,10887687,10887688,10887689,10887690,10887691,10887692,10887693,10887694,10887695,10887696,10887697,10887698,10883289,10883290,10883291,10883292,10883293,10883294,10883295,10883296,10883297,10883298,10883299,10883300,10883301,10883302,10883303,10883304,10883305,10883306,10883307,10882416,10882417,10882418,10882419,10646189,10647621,10532131,10507586,10410404,10410405,10410406,10410407) 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>