dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/doaj_journals/sql/doajJournals_findMatches.sql @ 48139
1 | 48139 | alessia.ba | 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 datasources d |
||
8 | WHERE
|
||
9 | d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' |
||
10 | AND
|
||
11 | (d.collectedfrom, d.issn) NOT IN |
||
12 | (SELECT |
||
13 | oa_source_id, |
||
14 | entry
|
||
15 | FROM hostedby_map) |