SELECT page_title

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_namespace = 0

            AND rd_namespace = 0

            AND base.page_title = REGEXP_REPLACE(dabbed.page_title, "_\\([^)]+\\)$", "")

            AND rd_title NOT LIKE "%(disambiguation)" -- [[Jack Smith (plumber)]] is fine if [[Jack Smith]] → [[John Smith (disambiguation)]]

            AND NOT (rd_title LIKE "List%"

                     AND INSTR(rd_title, base.page_title))

            AND LOWER(base.page_title) != LOWER(rd_title))