select inputer as 用户名,count(*) as 投稿数 from ks_article group by inputer order by 2 desc  注：统计用户投稿数量按数量排序

select inputer as 用户名,count(*) as 投搞数 from ks_u_ctxt where verific=1 group by inputer order by 2 desc  注：统计用户投稿被审核的数量并排序

科讯QQ学习交流群：284334728