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