dnet40/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryProjectContactperson.sql @ 31240
| 1 | 26600 | sandro.lab | 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 |