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
.
The problem this time seems to be rows in categorylinks persisting after the page was deleted. [[WP:VPT#Speedy deletion category counts]] circa 15 Apr 2022.
Toggle Highlighting
SQL
SELECT * FROM categorylinks LEFT JOIN page ON page_id = cl_from WHERE cl_to IN ('Candidates_for_speedy_deletion_as_blatant_NOTWEBHOST_violations', 'Candidates_for_speedy_deletion_as_copyright_violations', 'Candidates_for_speedy_deletion_as_vandalism');
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...