Untitled query #68678

SQL

SELECT CONCAT('[[', REPLACE(dp_title,'_',' '), ']]') AS dp_title, CONCAT('[[', REPLACE(lp_title,'_',' '), ']]') AS lp_title
FROM (
  		SELECT page_id AS dp_id, page_title AS dp_title, REGEXP_REPLACE(page_title, '_\\(.*\\)$', '') AS dp_label
		FROM page
  		WHERE
  			page_namespace=0 AND
  			page_is_redirect=0 AND
  			page_title REGEXP '^[ABCDEFGHIJKLMNOPQRSTUVWXYZ]' AND
  			(page_title NOT REGEXP '\\)$' OR page_title REGEXP '_\\(doorverwijspagina\\)$') AND
  			EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation')
  	) dp, (
    	SELECT page_title AS lp_title, REGEXP_REPLACE(page_title, '_\\(.*\\)$', '') AS lp_label
    	FROM page
      	WHERE
      		page_namespace=0 AND 
      		page_is_redirect=0 AND
      		page_title REGEXP '^[ABCDEFGHIJKLMNOPQRSTUVWXYZ].*_\\(.*\\)$' AND
      		page_title NOT REGEXP '_\\(seizoen_[0-9]+\\)$' AND
      		#page_title NOT REGEXP '_\\(seizoen_[0-9]+\\)$|^O2_\\(' AND
      		NOT EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation')
  	) lp
WHERE
	dp_label=lp_label AND
    NOT EXISTS (SELECT * FROM pagelinks WHERE pl_from=dp_id AND pl_namespace=0 AND pl_title=lp_title)
ORDER BY lp_title
SQL

Checking query status...
