Skip to main content
replaced http://data.stackexchange.com/ with https://data.stackexchange.com/
Source Link

That's not too hard; herehere is one for part 1, and herehere 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

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

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
Source Link
Glorfindel Mod
  • 255.6k
  • 61
  • 638
  • 1.3k

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