4 INNER JOIN authentication a
USING (identifier_id
)
5 FULL JOIN profile_scope ps
USING (profile_id
)
6 FULL JOIN scope s
USING (scope_id
)
7 WHERE a.identifier
= $
(identifier
)
8 UNION ALL SELECT NULL AS profile
, *
10 WHERE is_manually_added
OR is_permanent