Count orphaned User talk: pages

SQL

SET STATEMENT max_statement_time = 1000 FOR
SELECT Pt.page_title
FROM page Pt
WHERE Pt.page_namespace=3 AND Pt.page_title LIKE "%/%"
AND Pt.page_title NOT LIKE "%/Archive%" AND Pt.page_title NOT LIKE "%/archive%" AND Pt.page_title NOT LIKE "%/sandbox%" AND Pt.page_title NOT LIKE "%/Sandbox%"
AND Pt.page_title NOT LIKE "%/talk_page_tutorial"  AND Pt.page_title NOT LIKE "%/TWA" AND Pt.page_title NOT LIKE "%/19%" AND Pt.page_title NOT LIKE "%/20%"
AND NOT EXISTS (SELECT * FROM page Pu WHERE Pu.page_namespace=2 AND Pu.page_title = Pt.page_title)
LIMIT 1000;
SQL

Checking query status...
