this post was submitted on 19 Jun 2023
8 points (100.0% liked)

Lemmy Support

4731 readers
29 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
 

I'm trying to prune "flotsam" communities from my instance, so it would help me to see when a community was first created. Is there a way to do so?

top 2 comments
sorted by: hot top controversial new old
[–] dystop 1 points 2 years ago

Don't have an answer, but thanks for doing this! I've noticed a bit of "cybersquatting", some people are creating 10-20 subs with no content. That's not helpful.

[–] [email protected] 1 points 2 years ago* (last edited 2 years ago)

You can query the community table in the database

SELECT * FROM public.community order by published asc;

load more comments
view more: next ›