gistfile1.txt

select count(*) as c,domain from accounts
where exists(select from follows left join accounts as a2 on a2.id=follows.account_id 
             where a2.domain is null and target_account_id=accounts.id)
group by domain order by c desc limit 100;

  c   |            domain
------+-------------------------------
 1476 | pawoo.net
 1186 | mstdn.jp
  396 |
  160 | mastodon.cloud
  141 | mstdn.maud.io
   59 | mastodon.social
   34 | jpnews.site
   31 | best-friends.chat
   29 | mstdn.guru
   28 | niu.moe
   25 | unnerv.jp
   23 | oransns.com
   22 | misskey.io
   21 | friends.nico
   18 | social.mikutter.hachune.net
   14 | heislandmine.work
   14 | mstdn.nere9.help
   13 | mstdn.beer
   12 | kirishima.cloud
   12 | pl.smuglo.li
   12 | theboss.tech
   12 | homoo.social
   11 | mstdn.io
   10 | mastodon.host
   10 | wxw.moe
   10 | social.tchncs.de
   10 | misskey.xyz
    9 | m6n.jp
    9 | sns.gdgd.jp.net
    9 | fgochiho.vip
    8 | chaosphere.hostdon.jp
    8 | misskey.m544.net
    8 | chaos.social
    8 | m6n.onsen.tech
    8 | pokemon.mastportal.info
    8 | mstdn.poyo.me
    7 | mstdn.club
    7 | mstdn-workers.com
    7 | mastodon.network
    7 | mastodon.yokohama
    7 | mastodon.xyz
    7 | pleroma.nakayoshi.tk
    7 | imastodon.net
    6 | mstdn.kemono-friends.info
    6 | freezepeach.xyz
    6 | vocalodon.net
    6 | mimumedon.com
    6 | framapiaf.org
    6 | tablegame.mstdn.cloud
    6 | mstdn.tamag.org
    5 | don.mamemo.online
    5 | heislandmine.mydns.jp
    5 | mstdn-amadeus.tech
    5 | shadowverse-mstdn.jp
    5 | si.pmpm.pw
    5 | pleroma.soykaf.com
    5 | mastodon.art
    5 | kurage.cc
    5 | mental.social
    5 | kirakiratter.com
    5 | mstdn.y-zu.org
    4 | mstdn-bike.net
    4 | handon.club
    4 | mathtod.online
    4 | mastodon.motcha.tech
    4 | qiitadon.com
    4 | gamelinks007.net
    4 | pixelfed.tokyo
    4 | kawen.space
    4 | photodn.net
    4 | mstdn.social
    3 | mstdn.hokkaido.jp
    3 | mstdn.fukuoka.jp
    3 | md.yutasan.co
    3 | wug.fun
    3 | don.nzws.me
    3 | botsin.space
    3 | abyss.fun
    3 | bookwor.ms
    3 | socialgame.mstdn.cloud
    3 | social.targaryen.house
    3 | gs.smuglo.li
    3 | mastodon.technology
    3 | taruntarun.net
    3 | s2.libera.blue
    3 | baraag.net
    3 | mastodon.ingress-enl.jp
    3 | tebukuro.m.to
    3 | kawaiuniv.work
    3 | js4.in
    3 | ika.moe
    3 | nagoyadon.jp
    2 | ekimemo.info
    2 | eigadon.net
    2 | mstdn.cuezakuisgodofthe.world
    2 | 4com.jp
    2 | dotdon.jp
    2 | mstdn.fm
    2 | don.tacostea.net
    2 | mstdn.anqou.net
(100 rows)