Red links with parenthesis without a disambiguation page in ruwiki

Fork of nlwiki Red links with parenthesis without a disambiguation page by Bdijkstra

This query is marked as a draft This query has been published by Stjn.

SQL

SELECT *
FROM pagelinks
WHERE pl_namespace=0 AND pl_from_namespace=0 AND pl_title REGEXP '_\\(.*\\)$' AND pl_title NOT REGEXP '_\\((значения)\\)$' AND
	NOT EXISTS (SELECT * FROM page WHERE page_namespace=pl_namespace AND page_title=pl_title) AND
	NOT EXISTS (SELECT * FROM page WHERE page_namespace=pl_namespace AND page_title=REGEXP_REPLACE(pl_title, '_\\(.*\\)$', '_\\(значения\\)$')) AND
	NOT EXISTS (SELECT * FROM page WHERE page_namespace=pl_namespace AND page_title=REGEXP_REPLACE(pl_title, '_\\(.*\\)$', ''))
LIMIT 500

SQL

Checking query status...