select Address,AllianceUser,Answer,ChargeType,CheckNum,City,ClubGradeID,ClubSpecialPower,EDays,Email,FaceHeight,FaceWidth,Fax,GradeID,GradeTitle,GroupID,IDCard,IsOnline,JoinDate,KS_addr, from KS_User

比如这个标签语句，如何让他与文章关联，按照顶的数量进行排行，

谢谢，帮我写下语句

查询语句：

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><strong>第{$AutoID}名</strong> {$Field(username,Text,0,...,0,)}(发表文章:{$Field(totalNum,Num,0,2)}篇)</br>
[/loop]

谁要是能把每年、每月、每周、每日的排行都弄出来就好了！！！

看不明白。