This will require an okay from legal (though I do not anticipate difficulties).

Only concern that I can see is how often these get stale? is there any risk that a page with sensitive content would be suppressed or reverted but still available through the cache?

(In reply to Luis Villa (personal-for work use lvilla@wikimedia.org) from comment #2)

Only concern that I can see is how often these get stale? is there any risk
that a page with sensitive content would be suppressed or reverted but still
available through the cache?

Yes. Most are updated once every 4 days, some take longer. But in that case i believe it would still be visible on main site (not 100% sure about that, but pretty sure)

You mean, we're still showing suppressed stuff on the main site in some cases? Or that more generally we may just have some stale caching around?

(In reply to Luis Villa (WMF Legal) from comment #4)

You mean, we're still showing suppressed stuff on the main site in some
cases? Or that more generally we may just have some stale caching around?

If someone deletes a page, (and then suppresses it or whatever) the page name may still appear on some list special pages for a bit of time - e.g. mostlinkedtopages and the like. However nobody can view the content of such a page, just that it was on the list

@scfc, I'm curious which user groups can see the data in querycache/querycachetwo through MediaWiki. Are any of these special pages restricted to admins? Can you post/link to a list of special pages that are in the table?

@Bawolff, as I would have to make educated guesses, could you please answer @Slaporte's questions if you can?

In T65782#1689724, @Slaporte wrote:

@scfc, I'm curious which user groups can see the data in querycache/querycachetwo through MediaWiki. Are any of these special pages restricted to admins? Can you post/link to a list of special pages that are in the table?

querycachetwo -> Special:ActiveUsers

querycache:

Extensions can add additional pages. On enwikipedia the list includes (Taken from API - https://en.wikipedia.org/w/api.php?action=help&modules=query%2Bquerypage):

Ancientpages, BrokenRedirects, Deadendpages, DoubleRedirects, ListDuplicatedFiles, Listredirects, Lonelypages, Longpages, MediaStatistics, Mostcategories, Mostimages, Mostinterwikis, Mostlinkedcategories, Mostlinkedtemplates, Mostlinked, Mostrevisions, Fewestrevisions, Shortpages, Uncategorizedcategories, Uncategorizedpages, Uncategorizedimages, Uncategorizedtemplates, Unusedcategories, Unusedimages, Wantedcategories, Wantedfiles, Wantedpages, Wantedtemplates, Unwatchedpages, Unusedtemplates, Withoutinterwiki, DisambiguationPages, DisambiguationPageLinks, UnconnectedPages, Badges

In particular Wantedpages is restricted. The biggest risk is probably if somebody adds a restricted query page at a later date.

These are internal names. The actual special page name might be different.

If an extension adds stuff to $wgAPIUselessQueryPages, it will be excluded from this list, however things that use querycache table, is not supposed to be added to that variable. I don't think any extensions add stuff to that variable, so I don't think its relavent, but mentioning for completeness.

hmm. Special:MostGloballyLinkedFilesPage doesn't seem to be listed there on commons, but I think that's due to https://gerrit.wikimedia.org/r/242790

Ping @Slaporte :)