022-83718162 / 83715667 chinadse@126.com
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 8 id,classid,title from [wedonet_doc] where isdel=0 and ispass=1 and cid=108 and classid in (765) 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=108 and classid in (766) 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=108 and classid in (834) 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=108 and classid in (833) order by istop desc,cls asc,id desc
select top 10 id,title from [wedonet_keyword] order by mycount desc