zunda ? nはおまけ :green_dango:
> SELECT domain, COUNT(1) FROM accounts WHERE avatar_updated_at IS NULL GROUP BY domain ORDER BY 2 DESC LIMIT 5;
domain | count
-----------------+-------
mstdn.jp | 3701
mastodon.social | 1073
friends.nico | 237
pawoo.net | 111
fosstodon.org | 62
(5 rows)
ふむ
senooken JP Social is a social network, courtesy of senooken. It runs on GNU social, version 2.0.2-beta0, available under the GNU Affero General Public License.
All senooken JP Social content and data are available under the Creative Commons Attribution 3.0 license.