select
        u.id as 'user_id',
        u.username,
        u.created_at,
        u.updated_at,
        u.primary_email_id,
        e.id as 'email_id',
        e.email,
        e.created_at,
        e.retired_at,
        e.confirmed_at,
        p.people_id as "people",
        a.people_id as "ascimain",
        n.id as "notices",
        c.id as "citations",
        i.id as "identity",
        s.id as "shorts",
        o.id as "orcid"
from accounts_production.users u
join accounts_production.emails e on (e.user_id = u.id or e.id = u.primary_email_id)
left join manuscripticon_live.people p on (p.accounts_user_id = u.id)
left join manuscripticon_live.ascimain a on (a.accounts_user_id = u.id)
left join Notices.users n on (n.accounts_user_id = u.id)
left join citations_production.users c on (c.accounts_user_id = u.id)
left join identity_production.users i on (i.accounts_user_id = u.id)
left join shorts_production.users s on (s.accounts_user_id = u.id)
left join accounts_production.user_orcid_map o on (o.user_id = u.id)
where e.email = 'foo@bar.com';