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 3 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid in (914) order by istop desc,cls asc,id desc select top 1 id,classid,title,readme from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid in (811) and isgood=1 order by istop desc,cls asc,id desc select top 7 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid in (811) order by istop desc,cls asc,id desc select top 5 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid in (915) order by istop desc,cls asc,id desc select top 6 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid in (916) order by istop desc,cls asc,id desc select top 8 id,classid,stime,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid in (812) order by istop desc,cls asc,id desc select top 8 id,classid,stime,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=4 and classid in (817) 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 in (917) order by istop desc,cls asc,id desc select top 10 id,title from [wedonet_keyword] order by mycount desc