0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds all questions where your answer is the highest-voted but there are still other answers.

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT Id [Post Link] FROM Posts AS Answer
  WHERE PostTypeId = 2
  AND OwnerUserId = ##UserId##
  AND Score > 0
  AND Id = (SELECT TOP(1) Id FROM Posts AS AllAnswers WHERE AllAnswers.ParentId = Answer.ParentId ORDER BY AllAnswers.Score DESC)
  AND (SELECT AnswerCount FROM Posts AS Question WHERE Question.Id = Answer.ParentId) > 1
  ORDER BY Score DESC

fork query

edited mar 20 12

created mar 19 12 minitech