---

termination as (
    select
        tr.name as termination_reason,
        t.date as termination_date,
        row_number() over (
            partition by tc.contract_id
            order by
                t.date desc nulls last,
                t.version desc nulls last,
                t.id desc
        ) as num
    from ourpension.termination_contract tc
        join ourpension.termination t
            on tc.termination_id = t.id
        join ourpension.contract_termination_reason tr
            on tr.id = t.contract_termination_reason_id
    where tc.contract_id = :id
),