Users with two Stack Overflow profiles, each tied to the same SE Account

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/310019/why-does-joe-friend-and-a-few-others-have-two-stack-overflow-accounts-each-ti

Stack Overflow

Q&A for professional and enthusiast programmers

select u.id as [User Link], u.accountid, * 
from users u
inner join (
select accountid
from users
where accountid is not null
group by accountid
having count(*)> 1) da on da.accountid = u.accountid
order by u.accountid

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results