Replicas browser and optimizer
This query is marked as a draft
This query has been published
Redirects that are not used, and were created by a specific user after 2019-02-23 and before 2019-03-04 (when he said he would stop creating such redirects)
USE itwiki_p; SELECT CONCAT('# [[',page_title,']]') FROM page LEFT JOIN pagelinks ON pl_title = page_title AND pl_namespace = page_namespace JOIN revision_userindex AS r ON rev_user_text = 'Micejerry' WHERE pl_namespace IS NULL AND page.page_namespace =0 AND page.page_is_redirect = 1 AND r.rev_timestamp > '20190223000001' AND r.rev_timestamp < '20190304000001' AND rev_page = page_id LIMIT 1000;
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