Replicas browser and optimizer
Blank Comments talk subpages of redirects
This query is marked as a draft
This query has been published
USE enwiki_p; SELECT CONCAT("Talk:", com.page_title) as title, CONCAT("Talk:", REPLACE(com.page_title, "/Comments", "")) as target, target.page_is_redirect FROM page com LEFT JOIN page target ON target.page_title = REPLACE(com.page_title, "/Comments", "") AND target.page_namespace = 1 WHERE com.page_namespace = 1 AND com.page_title LIKE "%/Comments" AND com.page_is_redirect = 0 AND com.page_len = 0 AND ( target.page_id IS NULL OR target.page_is_redirect = 1 )
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