I saw View my questions with unaccepted answers but my question is not only about my questions. Instead: I would like to get a list of all these questions (on a specific site) which

  • I answered to
  • which do not have an accepted answer.

Beyond that: how to create that list for questions where my answer is the only one?


That's not too hard; here is one for part 1, and here is part 2.

For reference, here is the second query (the first one is identical, but leaves out the q.AnswerCount = 1 condition):

SELECT q.Id AS [Post Link], a.CreationDate
  FROM Posts AS q
  INNER JOIN Posts AS a ON a.ParentId = q.Id
  WHERE a.OwnerUserId = ##UserId##
    AND q.AnswerCount = 1
    AND q.AcceptedAnswerId IS NULL
  • Excellent! Thank you sir. – GhostCat Aug 3 '17 at 7:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .