Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>","url":"https:\/\/mastodon.zunda.ninja\/users\/zundan","portablecontacts_net":{"preferredUsername":"zundan@mastodon.zunda.ninja","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","note":"
Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>"}},"content":"
\u3082\u3089\u3048\u3066\u308b\u65b9\u3084\u3093\u3053\u306e\u30af\u30a8\u30ea\u30fc<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101435410936284756","object":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101435410936284756","objectType":"comment","content":"
\u3082\u3089\u3048\u3066\u308b\u65b9\u3084\u3093\u3053\u306e\u30af\u30a8\u30ea\u30fc<\/p>","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101435410936284756","status_net":{"notice_id":null},"inReplyTo":{"objectType":"note","id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101435409280780992","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101435409280780992"}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mastodon.zunda.ninja,2019-01-18:objectId=2721113:objectType=Conversation","notice_info":{"local_id":"2023599","source":"ostatus"}},"published":"2019-01-18T03:18:58+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101435410936284756"},{"actor":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/1005-original-20200212031327.gif","rel":"avatar","type":"image\/gif","width":120,"height":120},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-48-20200212035814.gif","rel":"avatar","type":"image\/gif","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-24-20200212035814.gif","rel":"avatar","type":"image\/gif","width":24,"height":24}],"profile_info":{"local_id":"1005"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},"objectType":"person","summary":"
Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>","url":"https:\/\/mastodon.zunda.ninja\/users\/zundan","portablecontacts_net":{"preferredUsername":"zundan@mastodon.zunda.ninja","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","note":"
Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>"}},"content":"
> SELECT domain, COUNT(1) FROM accounts WHERE avatar_updated_at IS NOT NULL GROUP BY domain ORDER BY 2 DESC LIMIT 5;
domain | count
-----------------+-------
mastodon.social | 5840
pawoo.net | 4489
friends.nico | 2284
mstdn.guru | 619
mstdn.jp | 618
(5 rows)<\/p>
\u4ed6\u306e\u30c9\u30e1\u30a4\u30f3\u3067\u3082\u3051\u3063\u3053\u3046\u30a2\u30d0\u30bf\u30fc\u304c\u3082\u3089\u3048\u3066\u306a\u3044\u30a2\u30ab\u30a6\u30f3\u30c8\u304c\u3042\u308b\u307f\u305f\u3044<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101435409280780992","object":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101435409280780992","objectType":"note","content":"
> SELECT domain, COUNT(1) FROM accounts WHERE avatar_updated_at IS NOT NULL GROUP BY domain ORDER BY 2 DESC LIMIT 5;
domain | count
-----------------+-------
mastodon.social | 5840
pawoo.net | 4489
friends.nico | 2284
mstdn.guru | 619
mstdn.jp | 618
(5 rows)<\/p>
\u4ed6\u306e\u30c9\u30e1\u30a4\u30f3\u3067\u3082\u3051\u3063\u3053\u3046\u30a2\u30d0\u30bf\u30fc\u304c\u3082\u3089\u3048\u3066\u306a\u3044\u30a2\u30ab\u30a6\u30f3\u30c8\u304c\u3042\u308b\u307f\u305f\u3044<\/p>","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101435409280780992","status_net":{"notice_id":null}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mastodon.zunda.ninja,2019-01-18:objectId=2721113:objectType=Conversation","notice_info":{"local_id":"2023583","source":"ostatus"}},"published":"2019-01-18T03:18:33+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101435409280780992"}],"links":[{"url":"https:\/\/social.senooken.jp\/conversation\/1435151","rel":"alternate","type":"text\/html"}]}