Dabs which list many people

SQL

SET STATEMENT max_statement_time=600 FOR
SELECT Pd.page_title AS dab, COUNT(DISTINCT Pp.page_id) AS people
FROM categorylinks Cd
JOIN page Pd ON Pd.page_id = Cd.cl_from AND Pd.page_namespace = 0 AND Pd.page_title REGEXP "^[^_]+(_\\(disambiguation\\))?$"
JOIN pagelinks ON pl_from = cl_from AND pl_namespace = 0
JOIN page Pp ON Pp.page_namespace = 0 AND Pp.page_title = pl_title
JOIN categorylinks Cp ON Cp.cl_from = Pp.page_id AND (Cp.cl_to = "Living_people" OR Cp.cl_to REGEXP "^\\d+_(BC_)?(births|deaths)")
WHERE Cd.cl_to = "All_disambiguation_pages" AND Cd.cl_type = "page"
GROUP BY dab
HAVING people > 20
ORDER BY people DESC, dab
SQL

Checking query status...
