---

select
    o.id as operation_id,
    o.ef_date,
    o.operation_type_id,
    ot.code,
    ot.name,
    o.deb_mnemonics,
    o.cred_mnemonics,
    o.value
from operation o
join back_office.operation_type ot
    on ot.id = o.operation_type_id
where ot.name ilike '%единоврем%'
   or o.operation_type_id in (125, 130)
order by
    o.ef_date,
    o.id,
    o.deb_mnemonics,
    o.cred_mnemonics;