dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/dsIdentitiesQuery.sql @ 59199
| 1 |
SELECT
|
|---|---|
| 2 |
id.pid, |
| 3 |
id.issuertype |
| 4 |
FROM
|
| 5 |
dsm_identities id |
| 6 |
LEFT OUTER JOIN dsm_datasourcepids dp ON (id.pid = dp.pid) |
| 7 |
WHERE
|
| 8 |
dp.datasource = :dsId |