zunda on Nostr: ドメインブロック対象をどうしようか眺めるよ > SELECT ...

ドメインブロック対象をどうしようか眺めるよ

> 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 domain NOT IN (SELECT domain FROM domain_blocks) GROUP BY domain ORDER BY 1 DESC;