1
|
INSERT INTO hostedby_map (_dnet_resource_identifier_, oa_source_id, entry, datasourceid)
|
2
|
SELECT
|
3
|
p.issn || '__' || p.id || '@@' || p.oa_source_id,
|
4
|
p.oa_source_id,
|
5
|
p.issn || '__' || p.id,
|
6
|
d.id
|
7
|
FROM datasources d, pangaea_temp_journals p
|
8
|
WHERE
|
9
|
d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' AND p.issn = d.issn
|
10
|
AND
|
11
|
(p.oa_source_id, p.issn || '__' || p.id) NOT IN
|
12
|
(SELECT
|
13
|
oa_source_id,
|
14
|
entry
|
15
|
FROM hostedby_map)
|