Replicas browser and optimizer
This query is marked as a draft
This query has been published
#unreviewed pages that have been taged with mw-removed-redirect SELECT DISTINCT CONCAT('*[[', page_title, ']]') FROM change_tag JOIN revision ON ct_rev_id = rev_id JOIN page ON rev_page = page_id JOIN pagetriage_page ON page_id = ptrp_page_id WHERE ct_tag = 'mw-removed-redirect' AND page_namespace = 0 AND page_is_redirect = 0 AND ptrp_reviewed = 0;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in