nlwiki Unused templates

SQL

SELECT page_title, rev_timestamp
FROM page, revision
WHERE
	page_is_redirect=0 AND
	page_namespace=10 AND
    page_title NOT REGEXP '^Array_|/preload$|^Gebruiker_[a-z\\-]+(-[1-4])?$' AND
    page_latest=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$)')
ORDER BY rev_timestamp
SQL

Checking query status...
