so for some reason the mastodon moderation federation interface shows "x users followed by us", but won't show you *who* is following who. So here is a messy postgres query that shows which of your local users follow people from BAD_DOMAIN.COM, so you can inform them after suspending
select accounts.username as remote_user, local_users.username as followed_by from accounts inner join follows on accounts.id = follows.target_account_id and domain='BAD_DOMAIN.COM' inner join accounts as local_users on follows.account_id=local_users.id;
so for some reason the mastodon moderation federation interface shows "x users followed by us", but won't show you *who* is following who. So here is a messy postgres query that shows which of your local users follow people from BAD_DOMAIN.COM, so you can inform them after suspending
select accounts.username as remote_user, local_users.username as followed_by from accounts inner join follows on accounts.id = follows.target_account_id and domain='BAD_DOMAIN.COM' inner join accounts as local_users on follows.account_id=local_users.id;
#fediadmin #mastodev