select top 28 topic,logfile,addtime,commentnum,iis,logid,classid,subjectid,author,blogname,nickname,user_dir,user_domain,user_domainroot,user_dir,oblog_user.userid,user_folder from oblog_log,oblog_user where oblog_user.userid=oblog_log.userid and ishide<>1 and isdraft=0 and passcheck=1 And oblog_log.isdel=0 And oblog_user.isdel=0  and oblog_log.blog_password=0 And (ispassword='' Or ispassword is null) and datediff('d',oblog_log.addtime,now())<360 And oblog_log.addtime<=Now  order by logid desc