dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/doaj_journals/sql/doajJournals_findMatches.sql @ 52632
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 = '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) |