On Raspberry Pi Beta, I notice that if I use the lower "unanswered" tab (the one in line with "All Questions"), the count is 1,432 questions.
If I use the upper "Unanswered" tab (in line with the site title), I get 1,383 "questions with no upvoted or accepted answers". This changes the options in the lower tab, one of which is "no answers". Clicking here, I now get 1,083 "questions with no answers".
If I run
select Id from Posts where PostTypeId=1 and AnswerCount=0;
in the Data Explorer, I get 1158 rows back.
Which of these is correct, and why is the first one (1,432) so much higher than the others? I understand that the numbers may only be updated periodically, but that difference in particular seems much too great for this to be the reason.
- 1,432 is the number of "unanswered questions".
- 1,383 is the number of "questions with no upvoted or accepted answers".
- 1,083 is the number of "questions with no answer"
- 1,158 is the number of questions with no answer in the data explorer. This is not live data, but that means it should be smaller, not larger, than 1,083. I promise we did not offset this with answers to the tune of 80 questions this week.
The first three are obviously live because they fluctuate. The difference between the first two is ~50, implying they actually don't refer to the same thing, and the difference between the last two seems too great (and in the wrong direction) to be explained by the a live vs. data explorer source.