Find answers by a given user (with links)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT 
  q.Id AS [Post Link], 
  a.Id AS "A ID", 
  q.CreationDate AS "Q Date", 
  a.CreationDate AS "A Date", 
  q.Score AS "Q Score",
  a.Score AS "A Score",
  q.ClosedDate AS "Question Closed Date",
  q.Title AS [Post Link]
FROM Posts a
  JOIN Posts q ON a.ParentId = q.Id
  JOIN Users u ON q.OwnerUserId = u.Id
WHERE a.OwnerUserId = ##UserId:int##
ORDER BY a.Score DESC

Enter Parameters

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