Replicas browser and optimizer
This query is marked as a draft
This query has been published
use hewiki_p; select pl_from, pl_title from pagelinks where pl_namespace = 0 and pl_from_namespace = 0 and pl_title like '%(%)' and not exists (select * from page as p1 where p1.page_namespace = 0 and p1.page_title = pl_title) and exists (select * from page as p2 where p2.page_namespace = 0 and p2.page_title = left(pl_title, length(p2.page_title)) and right(pl_title, length(pl_title)-length(p2.page_title)) like "_(%")
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