Unused Templates

SQL

SELECT COUNT(IF (log_id IS NULL, 1, NULL)) AS '# created before creation log', COUNT(*) AS 'total'
FROM page
LIMIT 100
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'
	AND NOT EXISTS (SELECT 1 FROM templatelinks t2
					WHERE t2.tl_from=page_id
						AND t2.tl_namespace=10
						AND t2.tl_title IN ('Require_subst', 'Subst_only', 'Substed', 'Substitute',
											'Substituted', 'Substme', 'Substonly')
					LIMIT 1);
SQL

Checking query status...
