游戏名称:
枪炮与荣耀(Java) for 诺基亚5233[于2011-08-26已下架]
相关下载
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=224 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=47570 order by flag desc