Project

General

Profile

Download (396 Bytes) Statistics
| Revision:

dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/fillhostedByDoaj/sql/tubitak_journal.sql @ 52331

1 
INSERT INTO hostedby_map (_dnet_resource_identifier_, oa_source_id, entry, datasourceid)
2 
	SELECT
3 
		d.issn || '@@' || d.collectedfrom,
4 
		d.collectedfrom,
5 
		d.issn,
6 
		d.id
7 
	FROM dsm_datasources d
8 
	WHERE
9 
		d.collectedfrom = 'openaire____::tubitak' AND d.issn IS NOT NULL AND d.id LIKE 'tubitak::%'
10 
		AND
11 
		(d.collectedfrom, d.issn) NOT IN
12 
		(SELECT
13 
			 oa_source_id,
14 
			 entry
15 
		 FROM hostedby_map)
(3-3/3)