Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; select page_title from page as p1 join redirect as r on rd_from = page_id where -- talk page is a redirect page_namespace = 1 and page_is_redirect = 1 and exists ( select null from page as p2 -- related article is not a redirect where page_namespace = 0 and page_title = p1.page_title and page_is_redirect = 0 ) and exists ( select null from page -- target's related article is not a redirect where page_namespace = 0 and page_title = r.rd_title and 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