Unused Templates

SQL

SELECT page_title, r.first_edit
FROM page
LEFT JOIN revision r
    on r.rev_page = page.page_id
    AND r.first_edit = (
      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
LEFT JOIN logging_logindex
	ON log_type='create' AND log_namespace=10 AND log_title=page_title
WHERE page_namespace=10
	AND t1.tl_from IS NULL
	AND page_is_redirect=0
	AND page_title NOT LIKE '%/sandbox'
	AND page_title NOT LIKE '%/testcases'
	AND page_title NOT LIKE '%/doc'
LIMIT 10
SQL

Checking query status...
