---

select
    atc.id,
    atc.number,
    atc.date,
    atc.client_type,
    atc.comment,
    atc.version,
    atc.*
from ourpension.load_snv l
join ourpension.contract c
    on l.contract_number = c.number
join ourpension.sharer sh
    on sh.contract_id = c.id
join ourpension.application_termination_contract atc
    on atc.sharer_id = sh.id
where l.file_id = 158136
  and l.id = 683
order by atc.id desc;




select
    l.*
from ourpension.load_snv l
where l.file_id = 158136
order by l.id;



select
    l.id as load_snv_id,
    l.file_id,
    l.contract_number,
    l.year,
    l.deduction_sign,
    l.sum_tax_deduction,

    c.id as contract_id,
    c.number as contract_number_db,
    c.individual_id,
    c.service_type,

    sh.id as sharer_id,

    atc.id as atc_id,
    atc.number as atc_number,
    atc.date as atc_date,
    atc.client_type as atc_client_type,
    atc.comment as atc_comment,
    atc.version as atc_version

from ourpension.load_snv l
join ourpension.contract c
    on l.contract_number = c.number
join ourpension.sharer sh
    on sh.contract_id = c.id
join ourpension.application_termination_contract atc
    on atc.sharer_id = sh.id
where l.file_id = 158136
order by
    l.id,
    atc.date desc nulls last,
    atc.id desc;