游戏介绍: 帝国神鹰 Aces of the Luftwaffe是一款空战游戏。二战爆发,法国覆亡,希特勒制定了入侵英国的“海狮计划“。为保障渡海登陆作战,德军企图首先夺取制空权,以摧毁英国的防御工事,消灭英国空军。 游戏中你将扮演英国皇家空军的一员,浴血奋战,保家卫国,共同经历史诗般波澜壮阔的不列颠空战!
select res_id,res_name,r_index_id,default_r_i_id,flag from(select top 11 res_id,res_name,r_index_id,default_r_i_id,0 as flag from T_D_Resource where res_is_audit=1 and res_run_flat='Android' and channel_id=4 and default_r_c_id=165 order by newid() )a union select res_id,res_name,r_index_id,default_r_i_id,1 as flag from T_D_Resource where res_id=80375 order by flag desc