dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/sql-datacite/dataciteSets_findMatches.sql @ 48139
| 1 |
INSERT INTO hostedby_map (_dnet_resource_identifier_, oa_source_id, entry, datasourceid) |
|---|---|
| 2 |
SELECT
|
| 3 |
s.setspec || '@@' || s.oa_source_id, |
| 4 |
s.oa_source_id, |
| 5 |
s.setspec, |
| 6 |
MIN(d.id) AS id |
| 7 |
FROM
|
| 8 |
datacite_temp_sets s |
| 9 |
JOIN datacite_temp_datarepos d ON (s.setname_cleaned = d.name_cleaned) |
| 10 |
WHERE (s.oa_source_id, s.setspec) NOT IN |
| 11 |
(SELECT |
| 12 |
oa_source_id, |
| 13 |
entry
|
| 14 |
FROM hostedby_map) |
| 15 |
GROUP BY s.oa_source_id, s.setspec |