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
    (
        select query_cr.account_id
        from
            contact query_c
            join contactrelationship query_cr
            on query_c.id = query_cr.contact_id
        where
            query_c.email = 'f39b503a908441cb85d3c3a2f97b0a43'
    ) query_cr

    join account a
    on query_cr.account_id = a.id

    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 accountdata d2
    on a.id = d2.account_id

    join accountdata d3
    on a.id = d3.account_id

    join accountdata d4
    on a.id = d4.account_id

    join accountdata d5
    on a.id = d5.account_id

where 1=1
    and main_cr.main
;