---

SELECT
    io.id AS incoming_order_id,
    c.id AS contract_id,
    c.number AS contract_number,
    c.service_type AS contract_type,
    c.individual_id AS contract_individual_id,
    c.family_member,
    c."date" AS contract_date,

    o.id AS operation_id,
    o.operation_date,
    o.approved,
    o.deleted,

    io.payment_return,

    ot.code AS operation_code,
    at.mnemonics,

    t.value AS contribution_value,

    ind.insurance_number AS snils,

    EXISTS (
        SELECT 1
        FROM ourpension.application_death_info adi
        WHERE adi.individual_id = ind.id
          AND adi.accepted IS NOT NULL
          AND adi.canceled IS NULL
    ) AS has_death_info

FROM back_office.incoming_order io
JOIN back_office.incoming_order_operation ioo
    ON ioo.incoming_order_id = io.id
JOIN back_office.operation o
    ON o.id = ioo.operation_id
JOIN back_office.operation_type ot
    ON ot.id = o.operation_type_id
JOIN back_office."transaction" t
    ON t.operation_id = o.id
JOIN back_office.account a
    ON a.id = t.credit_account_id
JOIN back_office.account_type at
    ON at.id = a.account_type_id
JOIN ourpension.contract c
    ON c.id = io.contract_id
JOIN ourpension.individual ind
    ON ind.id = io.individual_id
WHERE io.individual_id = 11232579
  AND c.id = 13649368
  AND o.operation_date >= DATE '2023-01-01'
  AND o.operation_date < DATE '2026-01-01'
ORDER BY
    o.operation_date,
    o.id,
    t.id;