Questions Where the OP Posted An Answer

1

Please login or register to vote for this query.

(click on this box to dismiss)

Finds 1000 answers posted by the person who originally posted the question where the answer was not accepted score of the answer is less than a parameter and the user's reputation is less than a parameter

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 1000 question.Id as [Post Link], answer.Id as [Post Link]
FROM Posts question
INNER JOIN Posts answer
ON question.Id = answer.ParentId
INNER JOIN Users poster
ON question.OwnerUserId = poster.Id
WHERE question.OwnerUserId = answer.OwnerUserId
AND question.AcceptedAnswerId != answer.Id
AND answer.Score < ##maxanswerscore##
AND poster.Reputation < ##maxreputation:int##

Enter Parameters

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