Accepted answers with zero score

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

DECLARE @UserId int = ##userid:int?5026##

SELECT answers.id as [Post Link]

FROM 

(SELECT *
FROM Posts
WHERE PostTypeId = 2) AS answers

JOIN

(SELECT *
FROM Posts
WHERE PostTypeId = 1) AS questions

ON questions.AcceptedAnswerId = answers.id

WHERE answers.OwnerUserId = @UserId AND answers.score = 0

Enter Parameters

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