Revision 59019
Added by Alessia Bardi almost 4 years ago
| queryProjects.sql | ||
|---|---|---|
| 1 | 1 |
SELECT * |
| 2 |
FROM projects_mv |
|
| 2 |
FROM projects_mv |
|
| 3 |
WHERE p.collectedfrom <> 'openaire____::dfgf' |
|
| 4 |
AND p.collectedfrom <> 'openaire____::innoviris' |
|
| 5 |
AND p.collectedfrom <> 'openaire____::sgov' |
|
| 6 |
AND p.collectedfrom <> 'openaire____::conicytf' |
|
| 7 |
AND p.collectedfrom <> 'openaire____::anr' |
|
| 8 |
AND p.collectedfrom <> 'openaire____::gsrt' |
|
| 9 |
AND p.collectedfrom <> 'openaire____::rif' |
|
| 10 |
AND p.collectedfrom <> 'openaire____::rsf' |
|
| 11 |
AND p.collectedfrom <> 'openaire____::miur' |
|
Also available in: Unified diff
Query updated to ignore funders that are not ready for production, but have been aggregated into production