---

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.name_for_statement,
    t.display_in_statement,
    t.settings_transaction_extended_id
FROM back_office.operation_type t
WHERE
       t.code ILIKE '%CLASS%'
    OR t.name ILIKE '%классиф%'
    OR t.short_name ILIKE '%классиф%'
    OR t.code ILIKE '%CHANGE%'
    OR t.name ILIKE '%изменен%'
    OR t.short_name ILIKE '%изменен%'
ORDER BY t.id;