|
1
|
SELECT
|
|
2
|
po.project AS project,
|
|
3
|
po.resporganization AS resporganization,
|
|
4
|
po.participantnumber AS participantnumber,
|
|
5
|
po.contribution AS contribution,
|
|
6
|
po.currency AS currency,
|
|
7
|
NULL AS startdate,
|
|
8
|
NULL AS enddate,
|
|
9
|
false AS inferred,
|
|
10
|
false AS deletedbyinference,
|
|
11
|
po.trust AS trust,
|
|
12
|
NULL AS inferenceprovenance,
|
|
13
|
|
|
14
|
po.semanticclass || '@@@' || po.semanticclass || '@@@dnet:project_organization_relations@@@dnet:project_organization_relations' AS semantics,
|
|
15
|
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction
|
|
16
|
|
|
17
|
FROM project_organization po
|
|
18
|
WHERE po.project not like 'dfgf%'
|
|
19
|
AND po.project not like 'innoviris%'
|
|
20
|
AND po.project not like 'sgov%'
|
|
21
|
AND po.project not like 'conicytf%'
|
|
22
|
AND po.project not like 'anr%'
|
|
23
|
AND po.project not like 'gsrt%'
|
|
24
|
AND po.project not like 'rif%'
|
|
25
|
AND po.project not like 'rsf%'
|
|
26
|
AND po.project not like 'miur%'
|