Revision 52325
Added by Claudio Atzori almost 6 years ago
| pangaea_journal_findmatches.sql | ||
|---|---|---|
| 4 | 4 |
p.oa_source_id, |
| 5 | 5 |
p.issn || '__' || p.id, |
| 6 | 6 |
d.id |
| 7 |
FROM datasources d, pangaea_temp_journals p |
|
| 7 |
FROM dsm_datasources d, pangaea_temp_journals p
|
|
| 8 | 8 |
WHERE |
| 9 | 9 |
d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' AND p.issn = d.issn |
| 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