Questions Where the OP Posted An Answer


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

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

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

Switch to main site
loading Hold tight while we fetch your results