duplicate pubmed ids

gistfile1.sql

select dr.provider_id, dr.provider_name_first, dr.provider_name_last,
       drid.provider_identifier_identity 
from provider_identifier drid
     inner join provider dr on (dr.provider_id = drid.provider_id)
where dr.project_id = 38 and drid.identifier_type_id = 7 and drid.provider_identifier_identity in (
select drid.provider_identifier_identity
from provider dr
     inner join provider_identifier drid on (drid.provider_id = dr.provider_id)
where project_id = 38 and drid.identifier_type_id = 7
group by drid.provider_identifier_identity
having count(drid.provider_identifier_identity) > 1)