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 id,classid,preimg,tags,descrip,etime,title,mycode,fromcom,price,pages,hasdisk,content,readme from [wedonet_book] where isdel=0 and ispass=1 and classid=938 and id=533
update [wedonet_book] set hits=hits+1 where id=533
select top 20 id,classid,title from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid<>-2 order by istop desc,cls asc,id desc
select tags from wedonet_article where id=533
select top 2 id,classid,preimg,etime,title,price from [wedonet_book] where isdel=0 and ispass=1 and cid=22 and classid<>-2 and cid=-10 and id<>533 order by istop desc,cls asc,id desc
select top 10 id,title from [wedonet_keyword] order by mycount desc