Great Answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the answers a user owns that are eligible for the Great Answer Badge

Meta Stack Overflow

Q&A about Stack Overflow, Server Fault and Super User

-- Great Answers
-- Lists the answers a user owns that are eligible for the Great Answer Badge
SELECT P1.Score, P1.Id, P1.ParentId, P2.Title
FROM Posts as P1  -- find responses of questions
JOIN Posts as P2 --And the question it responds to
ON P1.ParentId  = P2.Id 
WHERE P1.PostTypeId = 2                 -- answers
AND P1.OwnerUserId = ##UserId##       -- by you
AND P1.Score > 100 --Which a score of over 100

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached