1 |
33011
|
sandro.lab
|
INSERT INTO hostedby_map(_dnet_resource_identifier_, oa_source_id, entry, datasourceid)
|
2 |
|
|
SELECT d.issn||'@@'||d.collectedfrom, d.collectedfrom, d.issn, d.id
|
3 |
52331
|
claudio.at
|
FROM dsm_datasources d where
|
4 |
41128
|
alessia.ba
|
d.collectedfrom ='$datasourceId$' and d.issn is not null and d.id like '$datasourceNamespacePrefix$%'
|
5 |
33011
|
sandro.lab
|
AND
|
6 |
|
|
(d.collectedfrom, d.issn) NOT IN
|
7 |
43833
|
sandro.lab
|
(SELECT oa_source_id, entry from hostedby_map);
|
8 |
|
|
|
9 |
|
|
|
10 |
|
|
INSERT INTO hostedby_map(_dnet_resource_identifier_, oa_source_id, entry, datasourceid)
|
11 |
|
|
SELECT d.eissn||'@@'||d.collectedfrom, d.collectedfrom, d.eissn, d.id
|
12 |
52331
|
claudio.at
|
FROM dsm_datasources d where
|
13 |
43833
|
sandro.lab
|
d.collectedfrom ='$datasourceId$' and d.eissn is not null and d.id like '$datasourceNamespacePrefix$%'
|
14 |
|
|
AND
|
15 |
|
|
(d.collectedfrom, d.eissn) NOT IN
|
16 |
|
|
(SELECT oa_source_id, entry from hostedby_map);
|
17 |
|
|
|
18 |
|
|
|
19 |
|
|
INSERT INTO hostedby_map(_dnet_resource_identifier_, oa_source_id, entry, datasourceid)
|
20 |
|
|
SELECT d.lissn||'@@'||d.collectedfrom, d.collectedfrom, d.lissn, d.id
|
21 |
52331
|
claudio.at
|
FROM dsm_datasources d where
|
22 |
43833
|
sandro.lab
|
d.collectedfrom ='$datasourceId$' and d.lissn is not null and d.id like '$datasourceNamespacePrefix$%'
|
23 |
|
|
AND
|
24 |
|
|
(d.collectedfrom, d.lissn) NOT IN
|
25 |
52331
|
claudio.at
|
(SELECT oa_source_id, entry from hostedby_map);
|