nlwiki Disambiguation pages with missing wikilinks

Fork of nlwiki Disambiguation pages with 0 or 1 outgoing wikilink by Bdijkstra

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

SQL

SELECT dp.*, rp.page_namespace AS rp_ns, rp.page_title AS rp_title
FROM (
	SELECT page_namespace AS dp_ns, page_title AS dp_title, REGEXP_REPLACE(page_title, '_\\(.*\\)', '') AS dp_label
	FROM page, page_props
  	WHERE pp_page=page_id AND pp_propname='disambiguation') dp, page rp
WHERE dp_ns=rp.page_namespace AND dp_title!=rp.page_title AND dp_label=REGEXP_REPLACE(rp.page_title, '_\\(.*\\)', '')
LIMIT 10
    
/*
SELECT page_namespace AS dp_ns, page_title AS dp_title
FROM page, pagelinks
WHERE
	page_id=pl_from AND
    NOT (pl_namespace=4 AND pl_title='Doorverwijspagina') AND
	EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation')
GROUP BY pl_from*/

SQL

Checking query status...