Remote posts are hidden in local community

[Nutomic]

Noticed this while testing something else. The problem looks pretty simple, when viewing a local community (like this one), it only displays local posts. If you go to the front page, you can see many posts in the same community that simply werent shown before. Take this post as example.

Post is shown on the frontpage as expected:

Post is nowhere to be found when viewing main directly: (both screenshots are taken directly on voyager)

[dessalines]

Methinks this is a dupe of #1283 , why is local getting overwritten to false again:

lemmy=# select local, community_local, community_actor_id from post_view where id = 125 and user_id is null;
 local | community_local |       community_actor_id
-------+-----------------+---------------------------------
 f     | t               | https://voyager.lemmy.ml/c/main

Also this filter should be community_local, and not local: https://github.com/LemmyNet/lemmy/blob/main/lemmy_db/src/post_view.rs#L283 , I'll change that now.