SELECT * FROM leagues l INNER JOIN league_admins a ON l.league_id = a.leagueid WHERE l.status IN ('active') AND ((l.user_name = 'GuestUser') OR (a.username = 'GuestUser')) ORDER BY l.name