Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clear absent / empty communities #1445

Closed
dessalines opened this issue Feb 22, 2021 · 1 comment
Closed

Clear absent / empty communities #1445

dessalines opened this issue Feb 22, 2021 · 1 comment
Labels
enhancement New feature or request

Comments

@dessalines
Copy link
Member

dessalines commented Feb 22, 2021

Saving these queries for later:

select count(*) from ( select community.id, actor_id, count(post.id) from community left join post on post.community_id = community.id group by community.id having count(post.id) = 0) as a

select count(*) from community;

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

@Nutomic
Copy link
Member

Nutomic commented Apr 15, 2023

How about adding this kind of stuff to the documentation instead?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants