select id,classid,tags,descrip,title,content from [wedonet_doc] where isdel=0 and ispass=1 and classid=812 and id=200 update [wedonet_doc] set hits=hits+1 where id=200 select top 10 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 10 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 10 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