SELECT
id,
"name",
brief,
param_pl_type_id,
hb_param_pl_table_id
FROM prod_line.param_pl
WHERE
lower(COALESCE("name", '')) LIKE '%собствен%'
OR lower(COALESCE(brief, '')) LIKE '%собствен%'
OR lower(COALESCE("name", '')) LIKE '%страхов%'
OR lower(COALESCE(brief, '')) LIKE '%страхов%'
OR lower(COALESCE("name", '')) LIKE '%резерв%'
OR lower(COALESCE(brief, '')) LIKE '%резерв%'
OR lower(COALESCE("name", '')) LIKE '%отчислен%'
OR lower(COALESCE(brief, '')) LIKE '%отчислен%'
ORDER BY id;