update wedonet_user set user_atime=GetDate() where id=0 update wedonet_user set isonline=0 where isonline=1 and datediff(n,user_atime,GetDate())>20 select top 1 * from [wedonet_comman] select id,uid,classid,fid,nickname,content,stime from [wedonet_comman] where ucid=638 and ispass=1 and fid=86 order by cls asc,id desc select top 1 * from [wedonet_commanreply] select id,uid,bid,nickname,content,stime from [wedonet_commanreply] where ispass=1 and ucid=638 and fid=86 order by cls asc,id asc select top 1 * from [wedonet_video] select id,classid,preimg,tags,descrip,title,timelong,point,readme from [wedonet_video] where isdel=0 and ispass=1 and classid=775 and id=86 update [wedonet_video] set hits=hits+1 where id=86 select tags from wedonet_article where id=86 select top 4 id,classid,preimg,title from [wedonet_video] where isdel=0 and ispass=1 and cid=8 and classid<>-2 and cid=-10 and id<>86 order by istop desc,cls asc,id desc select tags from wedonet_article where id=86 select top 1 * from [wedonet_book] select top 8 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid<>-2 and cid=-10 and id<>86 order by istop desc,cls asc,id desc select top 8 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid<>-2 and isgood=1 order by istop desc,cls asc,id desc select top 10 id,title from [wedonet_keyword] order by mycount desc