select top 6 res_id,res_name,r_index_id,channel_id,default_r_c_id, default_r_i_id,res_upload_datetime,res_format_id,default_r_wap_i_id,res_default_img_dir_name,res_default_img,res_wap_img_dir_name,res_wap_img,res_small_icon_dir_name,res_small_icon from T_D_Resource where res_is_audit=1 and res_run_flat='Windows Mobile' and channel_id=3 and default_r_c_id=97 order by newid() desc