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 id,classid,tags,descrip,content,title from [wedonet_doc] where isdel=0 and ispass=1 and classid=861 and id=121 update [wedonet_doc] set hits=hits+1 where id=121 select top 20 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=21 and classid<>-2 order by istop desc,cls asc,id desc select top 1 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid in (859) order by istop desc,cls asc,id desc select top 1 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid in (801) order by istop desc,cls asc,id desc select top 1 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid in (800) order by istop desc,cls asc,id desc select top 1 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid in (799) order by istop desc,cls asc,id desc select top 1 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid in (798) order by istop desc,cls asc,id desc select top 1 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid in (797) order by istop desc,cls asc,id desc select top 17 id,classid,title from [wedonet_video] where isdel=0 and ispass=1 and cid=8 and classid<>-2 order by istop desc,cls asc,id desc select top 10 id,title from [wedonet_keyword] order by mycount desc