Find Duplicate Cards

SELECT sc.name, sc.login, ci1.IdentityType, ci1.VALUE FROM consumeridentities_t ci1, ServiceConsumer_T sc
WHERE ci1.ConsumerID = sc.ID AND sc.Visibility = 0
AND ci1.DefaultIdentity = 1 AND ci1.Visibility = 0
AND EXISTS (SELECT 1 FROM consumeridentities_t ci2
WHERE ci1.IdentityType = ci2.IdentityType AND ci2.DefaultIdentity = 1 AND ci2.Visibility = 0
AND ci1.id != ci2.id AND ci1.ConsumerID = ci2.ConsumerID)
ORDER BY sc.name