5

Please login or register to vote for this query.

(click on this box to dismiss)

Your answers which were viewed the most times.

Q&A for Drupal developers and administrators

SELECT Answers.Id as [Post Link], Question.ViewCount 
FROM Posts as Answers, Posts as Question 
WHERE Answers.PostTypeId = 2 
AND Answers.OwnerUserId = ##UserId## 
AND Question.Id = Answers.ParentId
ORDER BY Question.ViewCount DESC;

fork query

edited jan 16 12 matt6125

created jun 16 10 sblair