Enter a summary page of a region (for example https://apps.magicjudges.org/region/25/).
Check the contents of the list “Other Regional Projects” down on the page.
The list displays only projects where the currently signed-in user is member of (public and private).
Make that JOIN a LEFT JOIN in the SQL. The list should show all public projects aligned to the region (+ projects which are not public and the user is member of).