Trending communities is scuffed and doesnt actually show trending communities. Usually if theres a new community made within the last 2 days it shows there otherwise it shows the most dead communities as they are getting large subscriber activity relative to their MAU
Vacant collects a lot of different kinds of communities ranging from unmoderated ones that havent been taken over yet by a new mod team to ones that are admin started to start getting some content on that subject (usually if thats the case ill be posting in it on my other account)

Sites back up
Got a lot of information about what it actually causing the issues which should help me automate some fixes for tomorrow + the weekend
There likely will be some more downtime tomorrow if I have time (if not itll be on saturday)
The issue is essentially a chain of issues with one needing to be fixed before I can fix the others. Some tables have duplicates entries which is preventing reindexing (since the indexes are broken). First one im going to try to fix is the post table.
I did some changes to remove a duplicate community to test which is https://programming.dev/c/photography@lemmy.world and ive managed to make it merged and now comments will show if you sort by comments in the community. Posts however still aren't showing up due to the posts table having the issue with duplicates as well. (fixing posts first so I can set all of the posts to the correct community in an automated way later for the communities)