---

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