Top linked disambiguation pages on dewiki

SQL

SELECT CONCAT('# [[', pl.pl_title, ']] <small>(', COUNT(pl.pl_from), ' Links)</small>')
 FROM pagelinks pl
 INNER JOIN page pd ON (pd.page_title = pl.pl_title AND pd.page_namespace = pl.pl_namespace)
 LEFT JOIN page ps ON (ps.page_id = pl.pl_from)
 LEFT JOIN pagelinks pls ON (pls.pl_title = ps.page_title AND pls.pl_namespace = 0 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 pl.pl_namespace = 0
 AND pl.pl_from_namespace = 0
 GROUP BY pl.pl_title
 ORDER BY COUNT(pl.pl_title) DESC, pl.pl_title
 LIMIT 10000
SQL

Checking query status...
