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(distinct 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
and v.creationdate < '2013-07-13' --more than 4 days old (data dump -4)

Enter Parameters

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