zunda on Nostr: ...

ところで1週間を超えて放置されているサーバのみなさんをドメインブロックします。ごめんね。

SELECT age(max(action_taken_at), min(action_taken_at)), count(1), domain
FROM reports
LEFT JOIN accounts ON accounts.id = target_account_id
WHERE forwarded = true
AND action_taken_at > '2024-10-01'
AND domain NOT IN (SELECT domain FROM domain_blocks)
GROUP BY domain ORDER BY 1 DESC;