dli_access_pid_sql.ESGF

DOI_ENTRY:select d.policy_drs_id,c.citation_id as entry_id,v.drs_map_esgf as entry_name,lower(v.pid) as PID,v.external_pid_url from cmip6_cite_test.v_data_pid v,cmip6_cite_test.policy_drs d, cmip6_cite_test.citation c where v.pid_type='DOI' and v.drs_map_esgf=d.drs_map_esgf and v.pid like '10.22033%' and d.policy_drs_id=c.policy_drs_id
DOI_REF:select t.ref_type_acronym,lower(replace(c.access_spec,'doi:','')) as REF_PID,c.title,c.publisher from cmip6_cite_test.reference r, cera2_upd.upd_citation c,cera2.ref_type t where r.citation_id=${entryid} and r.ref_citation_id=c.citation_id and c.access_spec like 'doi%' and r.ref_type_id=t.ref_type_id