"Top tags without excerpts" query returning incorrect values, likely using it incorrectly

Question

A few days ago, I noticed the "Top tags requiring a wiki" question. For those unfamiliar, it is an old post, directing users to update the wiki for popular tags.

In the answer, there is a useful list of the "Top 20", with a link to the query used to determine the 20 most used tags that do not have wiki excerpts.

After adding a few excerpts, and seeing they were approved, I ran the query and updated the list. I since noticed another user adding back in the tags I had completed, and removing other tags, that I confirmed to have no wiki. I rolled back the edit, and left a comment explaining my actions.

I have gone back in, today, having pushed a wiki to the mortal-kombat-x tag. I click on the query, and I click "Run Query", confirming I am a human with a Capthca.

However, the query still shows tags that have wikis. In fact, the supposed "top 2" are ff-record-keeper and mortal-kombat-x. I added these both, myself. I have since been awarded reputation for the approvals, and there is no comment on either wiki to note that they are still awaiting approval.

Am I missing something that I potentially lucked out on, the first time? Or is there a different reason this query is no longer returning accurate data?

Answer 1

The query given on the 'Top Tags without a Wiki' post can be up to a week out of date. The Stack Exchange Data Explorer from which the query is run isn't updated in realtime:

Therefore, the best day to check and update the query is on Mondays. However, if you click on the tags in the query, it will take you to the Arqade page for that tag:

Which will show an updated wiki in realtime. This is how I check when adding new tags to the answer.

I doubt there's any malice here, just a simple misunderstanding. I've edited in a warning to the post in question, hopefully in future, situations like this one will not crop up as often.