Questions with close votes and less views


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(distinct
from posts p
inner join votes v on v.postid =
where v.votetypeid = 6 --close votes
and p.viewcount < 100 -- less than 100 views
and p.closeddate is null -- not closed yet
and v.creationdate < '2013-07-13' --more than 4 days old (data dump -4)

Enter Parameters

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