select count(*) from [wedonet_video] where cid=8 and isdel=0 and ispass=1 and classid in (761) select top 20 id,classid,preimg,title from [wedonet_video] where cid=8 and isdel=0 and ispass=1 and classid in (761) order by istop desc,cls asc,id desc select top 4 id,classid,preimg,title from [wedonet_video] where isdel=0 and ispass=1 and cid=8 and classid<>-2 and isgood=1 order by istop desc,cls asc,id desc select top 5 id,classid,title from [wedonet_video] where isdel=0 and ispass=1 and cid=8 and classid<>-2 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=4 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