---

and c.id = (
    select max(c2.id)
    from ourpension.application_termination_contract atc2
    join ourpension.sharer s2 
        on s2.individual_id = atc2.individual_id
    join ourpension.contract c2 
        on c2.id = s2.contract_id
    where c2.number = c.number
)