<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<disco format="disco.linkout.sql" format-version="1.0">
<site-info site-name="NIF Registry Automated Crawl Data"/>
 <technical-contact email="" name=""/>
 <linkout-sql>
 <![CDATA[

SELECT DISTINCT 'PubMed' AS db,
	b.pmid AS oid,
	'Resource: Registry' AS linkcategory,
	trim(leading 'Resource:' FROM a.resource_name) AS linkname,
	'https://scicrunch.org/resolver/' || scr_id AS linkurl
FROM l2_nlx_144509_resource_scicruch_registry a,
	l2_nlx_144525_rdw_resource_refs b
WHERE a.original_id = b.nifid
	AND b.pmid NOT LIKE '#%'
	AND b.pmid NOT LIKE ''
	AND a.resource_url NOT LIKE ''
	AND a.original_id NOT LIKE '0'
	AND b.pmid NOT LIKE '0'

 ]]>
</linkout-sql>
</disco>
