Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Cryptic
.
Pages whose rows in categorylinks weren't deleted when the pages were, for a single given category. This causes a miscount in {{PAGESINCATEGORY}} for the categories they're in, in such a way that purging the category page - the usual solution - doesn't fix it. (Speedy deletion-related categories are particularly prone to such errors.) The problem is that rows in categorylinks tying the old page id to the category remain, and the recount triggered by purging doesn't check to see if those pages still exist. Restoring then re-deleting the page usually does fix it, though only if no other revisions have been placed at that page title in the meantime (which assigns a new page_id). (See query 69117 for a version that checks all immediate subcategories of a given category.)
Toggle Highlighting
SQL
SET @cat = 'Proposed deletion as of 27 April 2024'; SELECT DISTINCT log_namespace, log_title FROM logging_logindex JOIN categorylinks ON cl_from = log_page JOIN archive ON ar_namespace = log_namespace AND ar_title = log_title AND ar_page_id = log_page -- this filters out redirects left by moves WHERE cl_to = REPLACE(@cat, ' ', '_') AND NOT EXISTS (SELECT 1 FROM page WHERE page_id = log_page);
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...