View counts on my answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Questions.ViewCount, Questions.Id AS [Post Link]
FROM Posts AS Answers
JOIN Posts AS Questions
  ON Answers.ParentId = Questions.Id
WHERE Answers.PostTypeId = 2
AND Answers.OwnerUserId = ##UserID##
AND Questions.ViewCount IS NOT NULL
ORDER BY Questions.ViewCount DESC

Enter Parameters

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