Questions with No accepted answer where I have the highest score

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

-- Questions with No accepted answer where I have the highest score
-- 
SELECT q.Id as [Post Link]
FROM Posts a
INNER JOIN Posts q ON q.ID = a.ParentID
WHERE a.OwnerUserID = ##UserID##
AND (SELECT MAX(p.Score) FROM Posts p WHERE p.ParentID=q.ID AND p.ID<>a.ID) < a.Score
ORDER BY q.ViewCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results