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:

queryDatasources.sql
115 115 
LEFT OUTER JOIN dsm_api a ON (d.id = a.datasource)
116 116 
LEFT OUTER JOIN dsm_datasourcepids di ON (d.id = di.datasource)
117 117 

  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  127
  
    

  		




  118
  128
  
    
GROUP BY


  		




  119
  129
  
    
	d.id,


  		




  120
  130
  
    
	d.officialname,


  		












Also available in:  Unified diff