---

SELECT
    id,
    code,
    name,
    short_name,
    group_code,
    service_type,
    type_movement,
    auto_approver,
    display_in_lkk,
    name_for_statement,
    display_in_statement,
    settings_transaction_extended_id
FROM back_office.operation_type
WHERE
       name ILIKE '%классификац%'
    OR name ILIKE '%инвестицион%'
    OR name ILIKE '%страхов%'
    OR name ILIKE '%ежегод%'
    OR name ILIKE '%взнос%'
    OR name ILIKE '%АСВ%'
    OR name ILIKE '%резерв%'
    OR name ILIKE '%задолж%'
    OR name ILIKE '%отказ%'
ORDER BY id;