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