| 1 |
48139
|
alessia.ba
|
SELECT
|
| 2 |
50489
|
michele.ar
|
o.id AS organizationid,
|
| 3 |
|
|
o.legalshortname AS legalshortname,
|
| 4 |
|
|
o.legalname AS legalname,
|
| 5 |
|
|
o.websiteurl AS websiteurl,
|
| 6 |
|
|
o.logourl AS logourl,
|
| 7 |
53226
|
alessia.ba
|
o.ec_legalbody AS eclegalbody,
|
| 8 |
|
|
o.ec_legalperson AS eclegalperson,
|
| 9 |
|
|
o.ec_nonprofit AS ecnonprofit,
|
| 10 |
|
|
o.ec_researchorganization AS ecresearchorganization,
|
| 11 |
|
|
o.ec_highereducation AS echighereducation,
|
| 12 |
|
|
o.ec_internationalorganizationeurinterests AS ecinternationalorganizationeurinterests,
|
| 13 |
|
|
o.ec_internationalorganization AS ecinternationalorganization,
|
| 14 |
|
|
o.ec_enterprise AS ecenterprise,
|
| 15 |
|
|
o.ec_smevalidated AS ecsmevalidated,
|
| 16 |
|
|
o.ec_nutscode AS ecnutscode,
|
| 17 |
50489
|
michele.ar
|
o.dateofcollection AS dateofcollection,
|
| 18 |
52338
|
alessia.ba
|
o.lastupdate AS dateoftransformation,
|
| 19 |
50489
|
michele.ar
|
false AS inferred,
|
| 20 |
|
|
false AS deletedbyinference,
|
| 21 |
53226
|
alessia.ba
|
o.trust AS trust,
|
| 22 |
50489
|
michele.ar
|
'' AS inferenceprovenance,
|
| 23 |
|
|
d.id AS collectedfromid,
|
| 24 |
|
|
d.officialname AS collectedfromname,
|
| 25 |
26600
|
sandro.lab
|
|
| 26 |
50489
|
michele.ar
|
o.country || '@@@' || o.country || '@@@dnet:countries@@@dnet:countries' AS country,
|
| 27 |
|
|
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction,
|
| 28 |
48139
|
alessia.ba
|
|
| 29 |
53226
|
alessia.ba
|
ARRAY[]::text[] AS pid
|
| 30 |
50489
|
michele.ar
|
FROM dsm_organizations o
|
| 31 |
51336
|
claudio.at
|
LEFT OUTER JOIN dsm_datasources d ON (d.id = o.collectedfrom)
|
| 32 |
48139
|
alessia.ba
|
|
| 33 |
|
|
|
| 34 |
|
|
|
| 35 |
|
|
|