Users who posted an answer to the same question as a downvoted post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  Count(*) AS [Count],
  b.OwnerUserId AS [User Link]
FROM Posts a, Posts b
WHERE a.OwnerUserId = ##me##
  AND a.PostTypeId = 2
  AND a.ParentId = b.ParentId
  AND b.Id <> a.Id
  AND EXISTS (SELECT Id FROM Votes v
              WHERE v.PostId = a.Id
                AND v.VoteTypeId = 3)
GROUP BY b.OwnerUserId
ORDER BY Count DESC

Enter Parameters

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