Untitled query #21769

SQL

USE cswiki_p;
SELECT art.page_namespace, art.page_title, COUNT(*) AS ct, GROUP_CONCAT(dab.page_title ORDER BY dab.page_title ASC SEPARATOR ', ') AS list
FROM pagelinks
JOIN page AS dab ON dab.page_title = pl_title AND dab.page_namespace = pl_namespace
JOIN page_props AS pp_dab ON pp_dab.pp_page = dab.page_id AND pp_dab.pp_propname = 'disambiguation'
JOIN page AS art ON art.page_id = pl_from
LEFT JOIN page_props AS pp_art ON pp_art.pp_page = art.page_id AND pp_art.pp_propname = 'disambiguation'
WHERE art.page_is_redirect = 0 AND art.page_namespace = 0
AND pp_art.pp_page IS NULL
GROUP BY pl_from
HAVING ct > 9
ORDER BY ct DESC, art.page_namespace, art.page_title;
SQL

Checking query status...
