---

  termination_reason.name as terminationReason,


LEFT JOIN LATERAL (
    SELECT
        reason.name
    FROM ourpension.termination_contract tc
    JOIN ourpension.termination trm
        ON trm.id = tc.termination_id
    JOIN ourpension.contract_termination_reason reason
        ON reason.id = trm.contract_termination_reason_id
    WHERE tc.contract_id = s.contract_id
    ORDER BY
        trm.date DESC NULLS LAST,
        trm.version DESC NULLS LAST,
        trm.id DESC
    LIMIT 1
) termination_reason ON TRUE