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?
Edit
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.
[status-by-design]
.PostHistory
table forPostHistoryTypeId = 10
.