Conversation

Notices

1. のえる :cava_red: DTP鯖管 (noellabo@dtp-mstdn.jp)'s status on Saturday, 05-Jan-2019 12:14:10 JST のえる :cava_red: 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 行)

   • のえる :cava_red: DTP鯖管 (noellabo@dtp-mstdn.jp)'s status on Saturday, 05-Jan-2019 12:14:19 JST のえる :cava_red: DTP鯖管

     in reply to

     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;