---

select
    src.operation_id,
    src.incoming_order_id,
    et.eps_id,
    e.code as eps_code,
    et.oper_date,
    count(*) as eps_rows,
    sum(et.operation_sum) as total_sum,
    max(et.operation_sum) as max_row_sum
from back_office.eps_transaction et
join back_office.eps_transaction_source src
    on src.id = et.eps_transaction_source_id
join ourpension.eps e
    on e.id = et.eps_id
where e.service_type = 'NPO'
  and e.periodicity in (1, 2)
  and et.oper_date >= date '2026-09-01'
  and et.oper_date < date '2026-10-01'
  and exists (
      select 1
      from ourpension.eps_detail ed
      where ed.eps_id = et.eps_id
        and (
            ed.account_dt = '48310'
            or ed.account_ct = '48310'
        )
  )
group by
    src.operation_id,
    src.incoming_order_id,
    et.eps_id,
    e.code,
    et.oper_date
order by total_sum desc nulls last
limit 10;