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 10 id,classid,title from [wedonet_download] where isdel=0 and ispass=1 and cid=20 and classid in (974) order by istop desc,cls asc,id desc select top 10 id,classid,title from [wedonet_download] where isdel=0 and ispass=1 and cid=20 and classid in (975) order by istop desc,cls asc,id desc select top 10 id,classid,title from [wedonet_download] where isdel=0 and ispass=1 and cid=20 and classid in (976) order by istop desc,cls asc,id desc select top 10 id,classid,title from [wedonet_download] where isdel=0 and ispass=1 and cid=20 and classid in (977) order by istop desc,cls asc,id desc select top 10 id,classid,title from [wedonet_download] where isdel=0 and ispass=1 and cid=20 and classid in (978) order by istop desc,cls asc,id desc select top 8 id,classid,preimg,etime,title,price from [wedonet_book] where isdel=0 and ispass=1 and cid=22 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