dnet40/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryProjectContactperson.sql @ 31240
1 |
SELECT distinct |
---|---|
2 |
project, |
3 |
contactperson, |
4 |
startdate, |
5 |
enddate, |
6 |
inferred, |
7 |
deletedbyinference, |
8 |
trust, |
9 |
inferenceprovenance, |
10 |
'contactperson@@@contactperson@@@dnet:project_organization_relations@@@dnet:project_organization_relations' as semantics |
11 |
|
12 |
FROM project_organization |
13 |
|
14 |
WHERE contactperson is not null |