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