dnet50/modules/dnet-wds/trunk/src/main/resources/eu/dnetlib/msro/workflows/hbase/queryProjectContactperson.sql @ 43444
| 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) |