I am curious why SE Data Explorer is telling me there are closed questions with no close votes
I don't think my query is wrong, but I suppose it could be:
select Closevotes, count(*) from ( select (select count(*) from votes where postid = posts.id and votetypeid = 6) as [CloseVotes], * from posts where posttypeid = 1 and not closeddate is null ) as t group by Closevotes order by closevotes
I checked a few of the questions which had 0 close votes, and all the ones I checked were closed by 1-4 users. None were closed by 5 users.
The only explanation I can possibly think of is that the process which expires close/reopen votes is removing these votes, even though the question got closed.
Would someone be able to verify this for me?
As Frédéric pointed out below, almost all the questions which have 1-4 close votes have either less than 100 views, or the votes are fairly recent.