Which of user A's questions have been answered by user B?


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for active researchers, academics and students of physics

  qu.Id AS "Who Asked",
  qu.DisplayName AS "Who Asked",
  au.Id AS "Who Answered",
  au.DisplayName AS "Who Answered",
  q.Id AS "Question ID", 
  q.Id AS [Post Link]
FROM Posts a
  JOIN Posts q ON a.ParentId = q.Id
  JOIN Users qu ON qu.Id = q.OwnerUserId
  JOIN Users au ON au.Id = a.OwnerUserId
WHERE q.PostTypeId = 1 -- question
  AND a.PostTypeId = 2 -- answer
  AND q.OwnerUserId = ##WhoAsked:int##
  AND a.OwnerUserId = ##WhoAnswered:int##

Enter Parameters

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