---

select
    l.id as load_snv_id,
    ct.id as atc_id,
    ct.number as atc_number,
    ct.date as atc_date,
    ct.accepted,
    ct.individual_id,
    c.id as contract_id,
    c.number as contract_number,
    sh_atc.id as atc_sharer_id
from ourpension.load_snv l
join ourpension.contract c
    on l.contract_number = c.number
join ourpension.application_termination_contract ct
    on ct.individual_id = c.individual_id
join ourpension.application_termination_contract_data ctd
    on ct.id = ctd.application_termination_contract_id
join ourpension.sharer sh_atc
    on sh_atc.id = ctd.sharer_id
   and sh_atc.contract_id = c.id
where l.file_id = :fileId
  and ct.accepted is not null
  and ct.rejected is null
  and ct.canceled is null
order by
    l.id,
    ct.accepted desc,
    ct.id desc;