游戏名称:
超级连连看 v1.80[于2010-08-28已下架]
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 channel_id=4 and res_relation_keywords='连连看' order by newid() desc )a union select res_id,res_name,r_index_id,default_r_i_id,1 as flag from T_D_Resource where res_id=19054 order by flag desc