dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryProjects.sql @ 61386
| 1 |
SELECT * |
|---|---|
| 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' |