Information of the users with accepted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

SELECT TOP 100
    Id, 
    Score,
    ViewCount as Views,
    AnswerCount as Answers,
    (SELECT TOP 1 Score FROM Posts b WHERE PostTypeId = 2 AND b.ParentId = a.Id ORDER BY Score DESC) AS TopAnswerScore
FROM Posts a
WHERE
    Tags NOT LIKE '%'+'story-identification'+'%'
    AND AcceptedAnswerId IS NULL
    AND PostTypeId = 1
ORDER BY AnswerCount ASC, Score DESC

Enter Parameters

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