Just noticed the `LEFT JOIN` — if they have a role, then a `JOIN` should suffice.