select count(tag_id) as tag_count, tags.name from statuses_tags inner join tags on statuses_tags.tag_id = tags.id group by tag_id, tags.name order by tag_count desc limit 10;

tag_count | name
-----------+-------------------
99454 | theboss_tech
9082 | nowplaying
8592 | traindelay
8382 | abyss_fun
5874 | whatyouareplaying
5774 | dtp
4286 | news
3767 | pixiv
3661 | vs_qiita
2379 | nsfw
(10 行)

すごいね。ほんと凄いw