0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT 
  questions.Id AS [Post Link], 
  questions.title, 
  answers.body, 
  questions.viewcount
FROM Posts answers
INNER JOIN Posts questions ON answers.parentid = questions.id
WHERE answers.OwnerUserId = ##UserId:int##
ORDER BY questions.viewcount DESC;

fork query

created may 25 anonymous