Accepted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

-- Accepted answers

SELECT PQ.id
-- , PQ.AcceptedAnswerId
, PQ.Title AS QuestionId
, PA.id
-- , PA.PostTypeId
, PA.Score
-- , IsAccepted = CASE PA.id WHEN PQ.AcceptedAnswerId THEN 'yes' ELSE 'no' END
, PL.Score AS [Accepted Score]
FROM posts PQ
INNER JOIN posts PA ON PA.ParentId=PQ.id
INNER JOIN posts PL ON PL.Id=PQ.AcceptedAnswerId

WHERE PL.Score < PA.Score

Enter Parameters

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