dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/hostedbyMapJournalIntersection/sql/find_journal_intersection.sql @ 52331
1 |
SELECT
|
---|---|
2 |
h.entry AS id, |
3 |
h.datasourceid AS datasource, |
4 |
d.officialname AS name |
5 |
|
6 |
FROM hostedby_map h, dsm_datasources d |
7 |
WHERE
|
8 |
h.oa_source_id = 're3data_____::r3d100010134' AND |
9 |
h.datasourceid = d.id |