Possible non-CONCISE titles on enwiki

SQL

SELECT *
FROM page dabbed
WHERE dabbed.page_namespace = 0
AND dabbed.page_is_redirect = 0
AND dabbed.page_title LIKE "_%(_%)"
AND dabbed.page_title NOT LIKE "%(disambiguation)" -- often valid; MALPLACED already monitored
AND EXISTS (SELECT 1
            FROM page base
            INNER JOIN redirect ON base.page_id = rd_from
            WHERE base.page_title = REGEXP_REPLACE(dabbed.page_title, "_\\([^)]+\\)$", "")
            AND rd_title NOT LIKE "%(disambiguation)") -- [[Jack Smith (plumber)]] is fine if [[Jack Smith]] → [[John Smith]]
LIMIT 1

SQL

Checking query status...