Revision 52325
Added by Claudio Atzori almost 6 years ago
| find_journal_intersection.sql | ||
|---|---|---|
| 4 | 4 |
d.officialname AS name, |
| 5 | 5 |
p.value AS issn |
| 6 | 6 |
|
| 7 |
FROM hostedby_map h, datasources d, hostedby_props p |
|
| 7 |
FROM hostedby_map h, dsm_datasources d, hostedby_props p
|
|
| 8 | 8 |
WHERE |
| 9 | 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' |
|
| 10 |
h.datasourceid = d.id AND p._dnet_resource_identifier_ = h._dnet_resource_identifier_ AND p.key = 'issn' |
|
Also available in: Unified diff
using dsm_datasources in sql expressions