---

SELECT
    id,
    code,
    name,
    short_name,
    name_old,
    short_name_old,
    service_type,
    type_movement,
    settings_transaction_extended_id
FROM back_office.operation_type
WHERE short_name ILIKE '%ИД%'
   OR short_name_old ILIKE '%ИД%'
   OR name ILIKE '%ежегод%'
   OR name ILIKE '%АСВ%'
   OR code ILIKE '%ANNUAL%'
   OR code ILIKE '%ASV%'
ORDER BY id;