select count(*) from [wedonet_doc] where cid=108 and isdel=0 and ispass=1 and classid in (833) select top 20 id,classid,title from [wedonet_doc] where cid=108 and isdel=0 and ispass=1 and classid in (833) order by istop desc,cls asc,id desc select top 1 * from [wedonet_class] select top 10 id,title from [wedonet_keyword] order by mycount desc