explain select
    a.id as "accountId",
    a.name as "accountName",
    main_c.name as "contactName",
    main_c.email as "mainContactEmail",
    d1.stuff as "data1"

from
    account a

    join contactrelationship main_cr
    on a.id = main_cr.account_id

    join contact main_c
    on main_cr.contact_id = main_c.id

    join accountdata d1
    on a.id = d1.account_id

    join contactrelationship query_cr
    on a.id = query_cr.account_id

    join contact query_c
    on query_cr.contact_id = query_c.id

where 1=1
    and query_c.email = 'f39b503a908441cb85d3c3a2f97b0a43'
    and main_cr.main
;