Popular answers with most viewed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select q.Title, q.Score as QuestionScore, q.ViewCount, q.Tags, q.Id as [Post Link],
ans.Score as AnswerScore, ans.Id as AnswerId
from Posts ans
join Posts q on ans.ParentId = q.Id
where q.ViewCount > 5000
and ans.Score > 20
and ans.OwnerUserId = 7586
order by q.ViewCount desc

Enter Parameters

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