dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryProjectContactperson.sql @ 48139
1 |
SELECT DISTINCT |
---|---|
2 |
po.project, |
3 |
po.contactperson, |
4 |
po.startdate, |
5 |
po.enddate, |
6 |
po.inferred, |
7 |
po.deletedbyinference, |
8 |
po.trust, |
9 |
po.inferenceprovenance, |
10 |
'contactperson@@@contactperson@@@dnet:project_organization_relations@@@dnet:project_organization_relations' AS semantics |
11 |
|
12 |
FROM project_organization po |
13 |
LEFT OUTER JOIN persons p ON (p.id = po.contactperson) |
14 |
|
15 |
WHERE po.contactperson IS NOT NULL AND (p.firstname IS NOT NULL OR p.secondnames IS NOT NULL) |