Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Permanently protected redirects that were protected by a move
by
Naypta
This query is marked as a draft
This query has been published
by
Anarchyte
.
See https://en.wikipedia.org/wiki/Wikipedia:Village_pump_(proposals)?action=edit§ion=16#Automatically_remove_protection_from_a_page_when_it_is_moved
Toggle Highlighting
SQL
SELECT DISTINCT CONCAT("[https://en.wikipedia.org/w/index.php?title=", `page_title`, "&redirect=no ", `page_title`, "]") as "Redirect", `pr_level` as "Protection Level" FROM `page` JOIN page_restrictions ON page_id = pr_page WHERE `page_title` IN ( SELECT REPLACE(`log_params`, " ", "_") FROM `logging_logindex` WHERE `log_type` = "protect" AND `log_action` = "move_prot" AND `log_params` IS NOT NULL AND `log_namespace` = 0 ) AND `page_id` IN ( SELECT `pr_page` FROM `page_restrictions` WHERE `pr_expiry` IN (NULL, "infinity") ) AND `page_namespace` = 0 AND `page_is_redirect` = 1 ORDER BY `page_id` ASC
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...