DisambiguationPageLinks excluding template_links

Fork of DisambiguationPageLinks excluding template_links by Mile.Horizon

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

SQL

SELECT DISTINCT from_page.page_title AS from_page,
                to_page.page_title AS disambig_page
FROM pagelinks AS pl

JOIN page AS from_page 
  ON pl.pl_from = from_page.page_id

JOIN linktarget AS lt 
  ON pl.pl_target_id = lt.lt_id

JOIN page AS to_page 
  ON lt.lt_title = to_page.page_title
  AND to_page.page_namespace = 0

JOIN page_props AS pp 
  ON to_page.page_id = pp.pp_page
  AND pp.pp_propname = 'disambiguation'

LEFT JOIN templatelinks AS tl
  ON tl.tl_from = from_page.page_id

WHERE tl.tl_from IS NULL
  AND from_page.page_is_redirect = 0
  AND from_page.page_namespace = 0
LIMIT 10000;

SQL

Checking query status...