/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/dsIdentitiesQuery.sql - Annotate - D-Net - D-Net project tracking tool

Download (144 Bytes) Statistics

dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/dsIdentitiesQuery.sql @ 62109

-            michele.ar
+ SELECT
  	id.pid,
  	id.issuertype
  FROM
  	dsm_identities id
-            michele.ar
+	LEFT OUTER JOIN dsm_servicepids dp ON (id.pid = dp.pid)
-            michele.ar
+WHERE
-            michele.ar
+	dp.service = :dsId