I must be happy,适用于S60第三版,参考机型诺基亚5700x、6120 classic、6290、N76、N81、N82、N95、5320x、5630x、5730x、6110 navigator、6220 classic、6710 navigator、6720 classic、6730 classic、6788、6788i、E75、N78 、N79、N85、N86、N96。
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='S60第三版' and channel_id=3 and default_r_c_id=97 order by newid() desc