1 |
48139
|
alessia.ba
|
SELECT
|
2 |
|
|
dor.datasource AS datasource,
|
3 |
|
|
dor.organization AS organization,
|
4 |
50489
|
michele.ar
|
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 |
48139
|
alessia.ba
|
|
11 |
50489
|
michele.ar
|
'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 |
48139
|
alessia.ba
|
|
14 |
50489
|
michele.ar
|
FROM dsm_datasource_organization dor
|
15 |
|
|
LEFT OUTER JOIN dsm_datasources d ON (dor.datasource = d.id)
|