repos / pico

commit

493d4d6

parent

65a2f09

author

Eric Bower

date

2026-05-03 12:31:09 -0400 EDT

chore: sql query to reap unused accounts

References: https://pico.prose.sh/ann-036-reap-inactive-accounts

1@@ -0,0 +1 @@
2+SELECT count(*) FROM app_users u WHERE NOT EXISTS (SELECT 1 FROM posts WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM projects WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM access_logs WHERE user_id = u.id AND created_at > NOW() - INTERVAL '1 year');