---

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
       code ILIKE '%CLASSIFICATION%'
    OR code ILIKE '%ANNUAL%'
    OR code ILIKE '%ASV%'
    OR code ILIKE '%REFUSAL%'
    OR code ILIKE '%OUTSTANDING%'
    OR name ILIKE '%отказ%банк%'
    OR name ILIKE '%резерв%не исполн%'
    OR name ILIKE '%ежегодн%'
    OR name ILIKE '%АСВ%'
ORDER BY id;