红色警戒 Check the crazy real time strategy in the red alert on yourphone! Experience a unique story, where you have to stand on the Soviet side to conquer the world or be an ally of the allies fighting global peace. Attack and weapons using both classic units such as combat Kirov airships, and a completely new - the paladin tank
以上是“红色警戒 for 诺基亚N97(国行版)”这款游戏的简介,想了解更多精彩就赶紧下载玩起来吧!
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='K-Java' and channel_id=4 and default_r_c_id=167 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=26074 order by flag desc