---

SELECT
    t.id,
    t.code,
    t.name,
    t.short_name,
    t.group_code,
    t.service_type,
    t.type_movement,
    en.enum_value AS type_movement_name,
    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
LEFT JOIN ourpension.enums en
    ON en.id = t.type_movement
WHERE
       t.code ILIKE '%CLASSIF%'
    OR t.name ILIKE '%классификац%'
    OR t.code ILIKE '%INSURED%FUND%'
    OR t.name ILIKE '%страхов%фонд%'
    OR t.code ILIKE '%ASV%'
    OR t.name ILIKE '%АСВ%'
    OR t.code ILIKE '%REFUSAL%'
    OR t.name ILIKE '%отказ%'
    OR t.code ILIKE '%RESERVE%'
    OR t.name ILIKE '%резерв%'
    OR t.code ILIKE '%NDFL%'
ORDER BY t.id;