Project

General

Profile

Download (357 Bytes) Statistics
| Revision:

dnet40/modules/icm-iis-import/trunk/src/main/resources/eu/dnetlib/iis/importer/database/project/sql/read_project_details_v2.sql @ 37093

1 
SELECT  p.id                         as projectid,
2 
        p.acronym                    as acronym,
3 
        p.code                       as code,
4 
        array_agg(fp.path)           as fundingpath
5 

    		
  

  

    
      6
    
    
      
FROM projects p


    		
  

  

    
      7
    
    
      
     left outer join project_fundingpath pf on (pf.project = p.id)


    		
  

  

    
      8
    
    
      
     left outer join fundingpaths fp on (fp.id = pf.funding)


    		
  

  

    
      9
    
    
      

    		
  

  

    
      10
    
    
      
GROUP BY p.id


    		
  









  (2-2/2)