Disambiguation pages with links

SQL

WITH dabs_and_redirects AS
  WITH dabs AS (
    SELECT Pd.page_title AS dab
    FROM categorylinks
    JOIN page Pd ON Pd.page_id=cl_from AND Pd.page_namespace=0 AND Pd.page_title NOT LIKE "%_(disambiguation)"
    WHERE cl_to="All_disambiguation_pages" AND cl_type='page'
  )
  SELECT dab FROM dabs
  UNION
  SELECT Pr.page_title AS dab
  FROM dabs
  JOIN redirect ON rd_namespace=0 AND rd_title=dab
  JOIN page ON page_id=rd_from AND page_namespace=0 AND page_title NOT LIKE "%_(disambiguation)"
  WHERE cl_to="All_disambiguation_pages" AND cl_type='page'
)  
SELECT dab, COUNT(*) AS links
FROM dabs
JOIN pagelinks ON pl_namespace=0 AND pl_title=dab AND pl_from_namespace=0
JOIN page ON page_id=pl_from AND page_namespace=0 AND page_is_redirect=0
GROUP BY dab
ORDER BY links DESC
SQL

Checking query status...
