nlwiki Disambiguation page titles with parenthesis

SQL

SELECT
	page_title,
    REGEXP_REPLACE(page_title, '^(.*)_\\(.*$', '\\1') AS prefix,
    REGEXP_REPLACE(page_title, '^.*_\\((.*)\\)$', '\\1') AS suffix,
    GROUP_CONCAT(tl_title) AS templates
FROM page, templatelinks
WHERE
    page_namespace IN (0,4,6,8,10,12,14,16,100,828) AND
    page_title REGEXP '_\\(.*\\)$' AND
    page_title NOT REGEXP '_\\(doorverwijspagina\\)$' AND
    tl_from=page_id AND tl_namespace=10 AND
	EXISTS (SELECT * FROM page_props WHERE page_id=pp_page AND pp_propname='disambiguation')
GROUP BY page_title

SQL

Checking query status...