---

and (
    td.id is null
    or td.id = (
        select max(td2.id)
        from ourpension.year_tax_deduction td2
        where td2.application_termination_contract_id = atc.id
    )
)