---

LEFT JOIN LATERAL
(
    SELECT
        tc.contract_id,
        trm.contract_termination_reason_id AS termination_reason_id,
        trm.date AS termination_date

    FROM ourpension.termination_contract AS tc

    JOIN ourpension.termination AS trm
        ON trm.id = tc.termination_id

    JOIN ourpension.contract_termination_reason AS reason
        ON reason.id = trm.contract_termination_reason_id

    WHERE tc.contract_id = ct.id

    ORDER BY
        trm.date DESC NULLS LAST,
        trm.version DESC NULLS LAST,
        trm.id DESC

    LIMIT 1
) AS t
    ON TRUE