---

select
    c.id as contract_id,
    c.number as contract_number,
    c.affiliate_program_contract_id,
    c.entity_id as current_entity_id,
    affiliate_c.entity_id as affiliate_entity_id,
    e.short_name as employer
from ourpension.contract c
left join ourpension.contract affiliate_c
    on affiliate_c.id = c.affiliate_program_contract_id
left join ourpension.entity e
    on e.id = affiliate_c.entity_id
where c.affiliate_program_contract_id is not null
limit 20;