485d043d2f602f06164404a1402b0dc27cc87a76
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