Top 10.000 linked disambiguation pages on dewiki

SQL

SELECT CONCAT('# [[', ltd.lt_title, ']] <small>(', COUNT(pld.pl_from), ' Links)</small>')
FROM pagelinks pld
  INNER JOIN linktarget ltd ON (pld.pl_target_id = ltd.lt_id)
  INNER JOIN page pd        ON (pd.page_title = ltd.lt_title AND pd.page_namespace = ltd.lt_namespace)
  LEFT JOIN  page ps        ON (ps.page_id = pld.pl_from)
  LEFT JOIN  linktarget lts ON (lts.lt_title = ps.page_title AND lts.lt_namespace = 0)
  LEFT JOIN  pagelinks pls  ON (pls.pl_target_id = lts.lt_id AND pls.pl_from_namespace = 0 AND ps.page_is_redirect = 1)
  LEFT JOIN  page plsp      ON (plsp.page_id = pls.pl_from)
  INNER JOIN page_props pp  ON (pp.pp_page = pd.page_id AND pp.pp_propname = 'disambiguation')
WHERE ltd.lt_namespace = 0
 AND pld.pl_from_namespace = 0
 AND NOT EXISTS(
   SELECT pps.pp_page
   FROM page_props pps
   WHERE (pps.pp_page = ps.page_id)
   AND pps.pp_propname = 'disambiguation'
 )
 AND NOT EXISTS(
   SELECT pps.pp_page
   FROM page_props pps
   WHERE (pps.pp_page = plsp.page_id)
   AND pps.pp_propname = 'disambiguation'
 )
 GROUP BY ltd.lt_title
 ORDER BY COUNT(pld.pl_from) DESC, ltd.lt_title
 LIMIT 10000
SQL

Checking query status...
