dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/dataRepositoryByJournal/sql/find_journal_intersection.sql @ 48139
| 1 |
SELECT
|
|---|---|
| 2 |
h.entry AS id, |
| 3 |
h.datasourceid AS datasource, |
| 4 |
d.officialname AS name, |
| 5 |
p.value AS issn |
| 6 |
|
| 7 |
FROM hostedby_map h, datasources d, hostedby_props p |
| 8 |
WHERE
|
| 9 |
h.oa_source_id = 're3data_____::r3d100010134' AND |
| 10 |
h.datasourceid = d.id AND p._dnet_resource_identifier_ = h._dnet_resource_identifier_ AND p.key = 'issn' |