Title (variant of disambiguation) redirects

SQL

SELECT page_title AS Redirect, rd_title AS Target, page_len AS Len, page_touched AS Touched, COUNT(*) AS Revisions, MAX(rev_len) AS Largest
FROM page
JOIN redirect ON rd_from = page_id AND rd_namespace = 0
JOIN revision ON rev_page = page_id
WHERE page_namespace = 0 AND page_title REGEXP BINARY "\\(_*[Dd]is[a-z]*[mbg][a-z]*[mbg][a-z]*[mbg][a-z]*[io]n_*\\)$"
AND page_title NOT REGEXP BINARY "_\\(disambiguation\\)$" AND page_is_redirect = 1
AND NOT EXISTS (SELECT 1 FROM pagelinks WHERE pl_from_namespace = 0 AND pl_namespace = 0 AND pl_title = page_title)
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_type = "page" AND cl_to = "Redirects_with_history")
GROUP BY page_title HAVING Largest < 1000
ORDER BY page_title
SQL

Checking query status...
