织梦DedeCMS调用管理员发帖发文章排行

织梦调用管理员发帖发文章排行代码如下：

{dede:sql sql="select u.id, u.uname, u.userid, u.usertype, (select count(*) from `dede_archives` where mid = u.id) as cfrom `dede_admin` u where u.usertype < 10 group by u.userid order by c desc,u.userid asc;"}
[field:global name=autoindex/][field:dd/][field:uname/]
{/dede:sql}