select*
from r7.v_registry r
join r7.registrydata rd on rd.registry_id = r.registry_id

where rd.evn_disdate::date between '2022-03-01'::date and '2022-03-31'::date
