dnet40/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/datacite/dataset_journal/sql/pangaea_journal_findmatches.sql @ 40144
| 1 |
INSERT INTO hostedby_map(_dnet_resource_identifier_, oa_source_id, entry, datasourceid) |
|---|---|
| 2 |
SELECT p.issn||'__'||p.id ||'@@'||p.oa_source_id, p.oa_source_id, p.issn||'__'||p.id , d.id |
| 3 |
FROM datasources d, pangaea_temp_journals p where |
| 4 |
d.collectedfrom ='driver______::1790119e-d281-4b7a-aedf-866d1d853a07' and d.issn is not null and d.id like 'doajarticles::%' and p.issn = d.issn |
| 5 |
AND
|
| 6 |
(p.oa_source_id, p.issn||'__'||p.id) NOT IN |
| 7 |
(SELECT oa_source_id, entry from hostedby_map) |