0

Please login or register to vote for this query.

(click on this box to dismiss)

List those users that have answered at least two questions which I have also answered

Q&A about the site for people organizing, marketing or licensing open source development projects

-- Who are answering the same questions as me?
-- List those users that have answered at least two questions which I have also answered

declare @MyUserId int = ##MyUserId##; -- 176569;

select count(distinct myAnswer.ParentId) as QuestionCount,
 otherAnswer.OwnerUserId as [User Link],
 otherUser.DisplayName as otherUserDisplayName
from Posts as myAnswer, Posts as otherAnswer, Users as otherUser
where otherAnswer.OwnerUserId != @MyUserId 
 and myAnswer.ownerUserId = @MyUserId   
 and myAnswer.ParentId = otherAnswer.ParentId
 and otherAnswer.postTypeId = 2
 and myAnswer.postTypeId = 2
 and otherUser.id = otherAnswer.OwnerUserId
group by otherAnswer.OwnerUserId, otherUser.DisplayName
having count(distinct myAnswer.ParentId) > 1
order by QuestionCount desc 

fork query

created sep 4 11 bpgergo