nlwiki Unused templates

SQL

SELECT page_title, r1.rev_timestamp AS 'last edit', r2.rev_timestamp AS 'created'
FROM page, revision r1, revision r2
WHERE
	page_is_redirect=0 AND
	page_namespace=10 AND
    page_title NOT REGEXP '^Array_|/preload$|^Gebruiker_[a-z\\-]+(-[1-4])?$' AND
    page_latest=r1.rev_id AND
    NOT EXISTS (SELECT * FROM templatelinks, linktarget WHERE tl_target_id=lt_id AND lt_namespace=page_namespace AND lt_title=page_title) AND
    NOT EXISTS (
		SELECT *
		FROM categorylinks
		WHERE cl_from=page_id AND cl_to REGEXP '^Wikipedia:Sjablonen_(scripting$|vlag_met_|[HPRS]-zinnen$|Davis_Cup$)') AND
    r2.rev_page=page_id AND r2.rev_parent_id=0
ORDER BY r1.rev_timestamp
SQL

Checking query status...
