As I had said a while ago, I'm doing some light inactive community pruning on the regular.
This time I looked for communities with 0 posts and low effort (i.e. no description, banners etc). I didn't bother to send a warning because that just adds extra effort for me. If you can't put any effort when starting a community, I can't be expected to put any effort when deleting it for abandonment, eh?
In case anyone else is interested, here's the SQL query I used to detect abandoned communities.
SELECT c.id, c.name, c.local, c.published
FROM public.community AS c
LEFT JOIN (
SELECT community_id, COUNT(*) AS post_count
FROM public.post
GROUP BY community_id
) AS p ON c.id = p.community_id
WHERE c.local = true
If they don't have any post, description and banner after 10 days, then I consider them low-effort and purge them immediately.
For the communities I've seen at least a bit of effort, I plan to still send warnings first.
About 20 communities were pruned this time (including 3 of mine :D )
