Untitled query #63531

SQL

WITH dabs_and_redirects AS (
  WITH dabs AS (
    SELECT page_title AS dab
    FROM categorylinks
    JOIN page ON page_id=cl_from AND page_namespace=0 AND page_title NOT LIKE "%_(disambiguation)"
    WHERE cl_to="All_disambiguation_pages" AND cl_type='page'
  )
  SELECT dab, dab AS target FROM dabs
  UNION
  SELECT dab, page_title
  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)"
)  
SELECT dab, COUNT(*) AS links, CONCAT("[","[Special:Whatlinkshere/",dab,"{{!}}list]","]") AS list
FROM dabs_and_redirects
JOIN pagelinks ON pl_namespace=0 AND pl_title=target AND pl_from_namespace=10
JOIN page ON page_id=pl_from AND page_namespace=10 AND page_is_redirect=0
GROUP BY dab
ORDER BY links DESC, dab
SQL

Checking query status...
