Replicas browser and optimizer
Comments talk subpages
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:", target.page_title) as target FROM page com JOIN page target ON target.page_title = REPLACE(com.page_title, "/Comments", "") WHERE com.page_namespace = 1 AND target.page_namespace = 1 AND com.page_title LIKE "%/Comments" AND com.page_is_redirect = 0 AND com.page_len = 0 AND target.page_is_redirect = 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