|
1
|
SELECT
|
|
2
|
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
|
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
|
o.dateofcollection AS dateofcollection,
|
|
18
|
o.lastupdate AS dateoftransformation,
|
|
19
|
false AS inferred,
|
|
20
|
false AS deletedbyinference,
|
|
21
|
o.trust AS trust,
|
|
22
|
'' AS inferenceprovenance,
|
|
23
|
d.id AS collectedfromid,
|
|
24
|
d.officialname AS collectedfromname,
|
|
25
|
|
|
26
|
o.country || '@@@dnet:countries' AS country,
|
|
27
|
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction,
|
|
28
|
|
|
29
|
ARRAY[]::text[] AS pid
|
|
30
|
FROM dsm_organizations o
|
|
31
|
LEFT OUTER JOIN dsm_datasources d ON (d.id = o.collectedfrom)
|
|
32
|
WHERE d.id <> 'openaire____::dfgf'
|
|
33
|
AND d.id <> 'openaire____::innoviris'
|
|
34
|
AND d.id <> 'openaire____::sgov'
|
|
35
|
AND d.id <> 'openaire____::conicytf'
|
|
36
|
AND d.id <> 'openaire____::anr'
|
|
37
|
AND d.id <> 'openaire____::gsrt'
|
|
38
|
AND d.id <> 'openaire____::rif'
|
|
39
|
AND d.id <> 'openaire____::rsf'
|
|
40
|
AND d.id <> 'openaire____::miur'
|
|
41
|
|
|
42
|
|
|
43
|
|
|
44
|
|
|
45
|
|