Questions with close votes and less views

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 count(*) from
(select p.id
from posts p
inner join votes v on v.postid = p.id
where v.votetypeid = 6 --close votes
and p.viewcount < 100 -- less than 100 views
and p.closeddate is null -- not closed yet
group by p.id
having count(v.votetypeid) >= 3
) x

Enter Parameters

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