Untitled query #37836

SQL

SELECT page_title, r.rev_timestamp
FROM page
LEFT JOIN revision r
    on r.rev_page = page.page_id
    AND r.rev_timestamp = (
      SELECT min(rev_timestamp) from revision
      where rev_page = page_id
    )
LEFT JOIN templatelinks t1
	ON t1.tl_namespace=10 AND t1.tl_title=page_title
WHERE page_namespace=10
	AND r.rev_timestamp < 20191225000000
	AND t1.tl_from IS NULL
	AND page_is_redirect=0
	AND page_title LIKE '%/doc%'
    AND NOT EXISTS (SELECT 1 FROM categorylinks cl
					WHERE cl.cl_from=page_id
                        AND cl.cl_to IN ("Templates_for_deletion")
					LIMIT 1)
ORDER BY page_title          
LIMIT 5000
SQL

Checking query status...
