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;<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/dtp-mstdn.jp\/users\/noellabo\/statuses\/101361782553029579","object":{"id":"https:\/\/dtp-mstdn.jp\/users\/noellabo\/statuses\/101361782553029579","objectType":"comment","content":"
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;<\/p>","url":"https:\/\/dtp-mstdn.jp\/@noellabo\/101361782553029579","status_net":{"notice_id":null},"inReplyTo":{"objectType":"note","id":"https:\/\/dtp-mstdn.jp\/users\/noellabo\/statuses\/101361781986273789","url":"https:\/\/dtp-mstdn.jp\/@noellabo\/101361781986273789"}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:dtp-mstdn.jp,2019-01-05:objectId=2286544:objectType=Conversation","notice_info":{"local_id":"1911419","source":"ostatus"}},"published":"2019-01-05T03:14:19+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/dtp-mstdn.jp\/@noellabo\/101361782553029579"},{"actor":{"id":"https:\/\/dtp-mstdn.jp\/users\/noellabo","displayName":"\u306e\u3048\u308b :cava_red: DTP\u9bd6\u7ba1","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/895-original-tmp20200811090558.png","rel":"avatar","type":"image\/png","width":400,"height":400},{"url":"https:\/\/social.senooken.jp\/avatar\/895-96-20200811090558.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/895-48-20200811090558.png","rel":"avatar","type":"image\/png","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/895-24-20200811090558.png","rel":"avatar","type":"image\/png","width":24,"height":24}],"profile_info":{"local_id":"895"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/895-96-20200811090558.png","rel":"avatar","type":"image\/png","width":96,"height":96},"objectType":"person","summary":"DTP\u30fb\u30c7\u30b6\u30a4\u30f3\u30fb\u5370\u5237\u306e\u30c6\u30fc\u30de\u30b5\u30fc\u30d0 DTP-Mstdn.jp\u3084\u3063\u3066\u307e\u3059\u3002#Illustrator #\u30b9\u30af\u30ea\u30fc\u30f3\u5370\u5237 #\u30a4\u30f3\u30af\u30b8\u30a7\u30c3\u30c8 #\u30ab\u30e9\u30fc\u30de\u30cd\u30b8\u30e1\u30f3\u30c8 #\u904b\u55b6","url":"https:\/\/dtp-mstdn.jp\/@noellabo","portablecontacts_net":{"preferredUsername":"noellabo","displayName":"\u306e\u3048\u308b :cava_red: DTP\u9bd6\u7ba1","note":"DTP\u30fb\u30c7\u30b6\u30a4\u30f3\u30fb\u5370\u5237\u306e\u30c6\u30fc\u30de\u30b5\u30fc\u30d0 DTP-Mstdn.jp\u3084\u3063\u3066\u307e\u3059\u3002#Illustrator #\u30b9\u30af\u30ea\u30fc\u30f3\u5370\u5237 #\u30a4\u30f3\u30af\u30b8\u30a7\u30c3\u30c8 #\u30ab\u30e9\u30fc\u30de\u30cd\u30b8\u30e1\u30f3\u30c8 #\u904b\u55b6"}},"content":"
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 \u884c)<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/dtp-mstdn.jp\/users\/noellabo\/statuses\/101361781986273789","object":{"id":"https:\/\/dtp-mstdn.jp\/users\/noellabo\/statuses\/101361781986273789","objectType":"note","content":"
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 \u884c)<\/p>","url":"https:\/\/dtp-mstdn.jp\/@noellabo\/101361781986273789","status_net":{"notice_id":null}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:dtp-mstdn.jp,2019-01-05:objectId=2286544:objectType=Conversation","notice_info":{"local_id":"1911417","source":"ostatus"}},"published":"2019-01-05T03:14:10+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/dtp-mstdn.jp\/@noellabo\/101361781986273789"}],"links":[{"url":"https:\/\/social.senooken.jp\/conversation\/1353864","rel":"alternate","type":"text\/html"}]}