1
|
SELECT
|
2
|
dor.datasource AS datasource,
|
3
|
dor.organization AS organization,
|
4
|
NULL AS startdate,
|
5
|
NULL AS enddate,
|
6
|
false AS inferred,
|
7
|
false AS deletedbyinference,
|
8
|
0.9 AS trust,
|
9
|
NULL AS inferenceprovenance,
|
10
|
|
11
|
'providedBy@@@provided by@@@dnet:datasources_organizations_typologies@@@dnet:datasources_organizations_typologies' AS semantics,
|
12
|
d.provenanceaction || '@@@' || d.provenanceaction || '@@@dnet:provenanceActions@@@dnet:provenanceActions' AS provenanceaction
|
13
|
|
14
|
FROM dsm_datasource_organization dor
|
15
|
LEFT OUTER JOIN dsm_datasources d ON (dor.datasource = d.id)
|
16
|
WHERE d.id <> 'openaire____::dfgf'
|
17
|
AND d.id <> 'openaire____::innoviris'
|
18
|
AND d.id <> 'openaire____::sgov'
|
19
|
AND d.id <> 'openaire____::conicytf'
|
20
|
AND d.id <> 'openaire____::anr'
|
21
|
AND d.id <> 'openaire____::gsrt'
|
22
|
AND d.id <> 'openaire____::rif'
|
23
|
AND d.id <> 'openaire____::rsf'
|
24
|
AND d.id <> 'openaire____::miur'
|
25
|
|