Project

General

Profile

« Previous | Next » 

Revision 59019

Added by Alessia Bardi almost 4 years ago

Query updated to ignore funders that are not ready for production, but have been aggregated into production

View differences:

queryDatasourceOrganization.sql
13 13 

  		




  14
  14
  
    
FROM dsm_datasource_organization dor


  		




  15
  15
  
    
	LEFT OUTER JOIN dsm_datasources d ON (dor.datasource = d.id)


  		




  
  16
  
    
WHERE d.id <> 'openaire____::dfgf'


  		




  
  17
  
    
AND d.id <> 'openaire____::innoviris'


  		




  
  18
  
    
AND d.id <> 'openaire____::sgov'


  		




  
  19
  
    
AND d.id <> 'openaire____::conicytf'


  		




  
  20
  
    
AND d.id <> 'openaire____::anr'


  		




  
  21
  
    
AND d.id <> 'openaire____::gsrt'


  		




  
  22
  
    
AND d.id <> 'openaire____::rif'


  		




  
  23
  
    
AND d.id <> 'openaire____::rsf'


  		




  
  24
  
    
AND d.id <> 'openaire____::miur'


  		




  16
  25
  
    

  		












Also available in:  Unified diff