Project

General

Profile

Download (465 Bytes) Statistics
| Revision:

dnet50/modules/dnet-wds/trunk/src/main/resources/eu/dnetlib/msro/workflows/hbase/queryProjectContactperson.sql @ 43444

1 43444 sandro.lab 
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)