这是实现首页投稿排行的代码：查询语句：  select top 10 a.userid,a.username,totalNum from ks_user a,(select inputer,count(*) as totalnum from ks_article where verific=1 group by inputer)b where a.username=b.inputer order by b.totalnum desc

循环体：[loop=10]
<br>{$Field(username,Text,0,...,0,)}(稿件:{$Field(totalNum,Num,0,2)})</br>
[/loop]