フォロー
DTP鯖管
count | per | name
-------+---------+-------------------
99541 | 18.36 | theboss_tech
9083 | 1.67 | nowplaying
8592 | 1.58 | traindelay
8383 | 1.55 | abyss_fun
5874 | 1.08 | whatyouareplaying
5774 | 1.06 | dtp
4287 | 0.79 | news
3767 | 0.69 | pixiv
3662 | 0.68 | vs_qiita
2379 | 0.44 | nsfw
(10 行)
select count(tag_id) as count, to_char(count(tag_id) * 100.0 / (select count(*) from statuses_tags), '990.00') as per, tags.name from statuses_tags inner join tags on statuses_tags.tag_id = tags.id group by tag_id, tags.name order by count desc limit 10;