---

SELECT
    t.id,
    t.code,
    t.name,
    t.short_name,
    t.group_code,
    t.service_type,
    t.type_movement,
    t.auto_approver,
    t.display_in_lkk,
    t.display_in_statement,
    t.settings_transaction_extended_id
FROM back_office.operation_type t
WHERE
       t.name ILIKE '%классификац%'
    OR t.name ILIKE '%страхов%'
    OR t.name ILIKE '%инвестиц%'
    OR t.name ILIKE '%АСВ%'
    OR t.name ILIKE '%резерв%'
    OR t.name ILIKE '%отказ%банк%'
    OR t.name ILIKE '%отчислен%'
    OR t.name ILIKE '%взнос%'
    OR t.code ILIKE '%INSURED%'
    OR t.code ILIKE '%ASV%'
    OR t.code ILIKE '%RESERVE%'
    OR t.code ILIKE '%REFUSAL%'
ORDER BY t.id;