想写个统计用户上稿排名
{eyou:sql sql=SELECT author COUNT(*) AS count (@rank := @rank + 1) AS rank FROM __PREFIX__archives (SELECT @rank := 0) r WHERE author != 'admin' GROUP BY author ORDER BY count DESC;"}
排名：{$field.rank}
用户：{field:author}
上稿：{field:count}
{/eyou:sql}
这串sql代码在sql中都能运行，为什么放进网站就显示缺少sql值呢？
