Count orphaned User talk: pages

SQL

SET STATEMENT max_statement_time = 1000 FOR
SELECT CASE
 WHEN Pt.page_title REGEXP "/[Aa]rchive" THEN "Archive"
 WHEN Pt.page_title REGEXP "/[Ss]andbox" THEN "Sandbox"
 WHEN Pt.page_title REGEXP "/talk_page_tutorial" THEN "Talk page tutorial"
 WHEN Pt.page_title REGEXP "/TWA$" THEN "TWA"
 WHEN Pt.page_title REGEXP "/[12][901][0-9][0-9]/[A-Z]" THEN "Monthly archive"
 WHEN Pt.page_title REGEXP "\.[0-9]+/[0-9][0-9]$" THEN "IP range"
 ELSE "Other" END AS type,
 COUNT(*), MIN(Pt.page_title), MAX(Pt.page_title)
FROM page Pt
WHERE Pt.page_namespace=3 AND Pt.page_title LIKE "%/%"
AND NOT EXISTS (SELECT * FROM page Pu WHERE Pu.page_namespace=2 AND Pu.page_title = Pt.page_title)
GROUP BY type WITH ROLLUP
ORDER BY type
SQL

Checking query status...
