MATCH (i:Identity)-[:HAS_PROFILE]->(p:Profile)-[:HAS_ACCESS_TO|HAS_ADMIN_ACCESS_TO]->(tenant)
WHERE
(
    tenant:Vendor
    OR tenant:SubAccount
    OR tenant:Collaborator
    OR tenant:LabelParticipant
)
WITH i, COUNT(DISTINCT tenant) as tenantCount
RETURN i.id, tenantCount
ORDER BY tenantCount DESC
LIMIT 10;