Use subquery to find org theme backgrounds by user membership instead of direct member join

Shipped

March 29, 2026 at 10:49 PM UTC

Author

Kamo

Commit

86492ce

The previous INNER JOIN on tb.member excluded backgrounds where member was NULL, which is most user-level backgrounds. Now uses a subquery through User→Member→Organization to find all backgrounds uploaded by users who are members of the org.