Most viewed unanswered questions with votes > 3

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 top 20 viewcount, count(votes.postid) as 'votescount', postid as [Post Link]
from posts inner join votes on votes.postid = posts.id
where PostTypeId = 1 and VoteTypeId=2 and AnswerCount=0 and ClosedDate is null
group by viewcount, votes.postid
having count(votes.postid) > 3
order by viewcount desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results