I used the following query Close votes per tag in the glory days of the close vote queue.
During the fuzzying I used the query to keep a sense of the actual number of questions with a close vote in the queue.
Under the new regime I expected the outcome of my query to be close to the actual number of questions in the queue.
However with around 7500 questions in the queue the first 5 tags already overflow that number.
Tim already commented that I used the wrong table and should use PendingFlags instead which gives me this query.
I already tried leaving out FlagTypeId 13 but that is not the whole story.
How should I adapt my query to have a result that is more closely related to the actual number of questions in the queue?
I'm also open for an explanation what data is missing from SEDE to get the actual number.
I'm aware that SEDE data can be 7 days old but at the time of posting SEDE was updated 7 hours ago...