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

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##

fork query

created nov 18 11 waiwai933