一生有你写的前10发稿数最多排行列表sql语句，老是提示有一个值未指定 什么原因呢  怎么实现月排名 加一个什么函数啊

源代码如下：

select top 10 a.userid,a.username,totalNum from ks_user a,(select articleinput,count(*) as totalnum from ks_article where verific=1 group by articleinput)b where a.username=b.articleinput order by b.totalnum desc

循环体:

[loop=10]

<li>{$Field(username,Text,0,...,0,)}(稿件:{$Field(totalNum,Num,0,2)})</li>

[/loop]

新版本要改成

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