SQL
x
use hewiki_p;
select distinct 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, len(p2.page_title)))
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.