select category_id,count(*) as count 

from article 

group by category_id 

order by count desc 

limit 10;


http://database.51cto.com/art/201011/235139.htm