masto admin tip Show more
just gonna leave this sql query here in case anyone else needs to work around the moderation interface's lack of ability to answer the question "who here follows who on that instance"
SELECT a1.username, a2.username FROM follows JOIN accounts a1 ON a1.id=target_account_id JOIN accounts a2 ON a2.id=account_id WHERE a1.domain='example.com';
@chrIf you already have the query then adding an extra screen to show exactly that info is gonna be much easier! 😃
Okay who in here knows Ruby? 😅
We are a Mastodon instance for LGBT+ and allies! ☺