Revision 52331
Added by Claudio Atzori almost 6 years ago
| tubitak_journal.sql | ||
|---|---|---|
| 4 | 4 |
d.collectedfrom, |
| 5 | 5 |
d.issn, |
| 6 | 6 |
d.id |
| 7 |
FROM datasources d |
|
| 7 |
FROM dsm_datasources d
|
|
| 8 | 8 |
WHERE |
| 9 | 9 |
d.collectedfrom = 'openaire____::tubitak' AND d.issn IS NOT NULL AND d.id LIKE 'tubitak::%' |
| 10 | 10 |
AND |
| ... | ... | |
| 12 | 12 |
(SELECT |
| 13 | 13 |
oa_source_id, |
| 14 | 14 |
entry |
| 15 |
FROM hostedby_map) |
|
| 15 |
FROM hostedby_map) |
|
Also available in: Unified diff
using dsm_datasources in sql expressions