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:

queryOrganizations.sql
29 29 
		ARRAY[]::text[]                                           AS pid
30 30 
FROM dsm_organizations o
31 31 
	LEFT OUTER JOIN dsm_datasources d ON (d.id = o.collectedfrom)
32 
WHERE d.id <> 'openaire____::dfgf'
33 
AND d.id <> 'openaire____::innoviris'
34 
AND d.id <> 'openaire____::sgov'
35 
AND d.id <> 'openaire____::conicytf'
36 
AND d.id <> 'openaire____::anr'
37 
AND d.id <> 'openaire____::gsrt'
38 
AND d.id <> 'openaire____::rif'
39 
AND d.id <> 'openaire____::rsf'
40 
AND d.id <> 'openaire____::miur'
32 41 

  		




  33
  42
  
    

  		




  34
  43
  
    

  		












Also available in:  Unified diff