Unused templates

SQL

select ROW_NUMBER() OVER(order by page_title) num, -- get row number
       CONCAT('[[Template:', replace(page_title, '_', ' '), ']]') as 'Page title' -- Format as wikilink, replace _ with space
from page
left join linktarget on page_namespace = lt_namespace
                        and page_title = lt_title
where page_namespace = 10 -- Template namespace
and page_is_redirect = 0 -- Not a redirect
and lt_id is null
and page_title not in (select page_title -- Excludes templates if they are in one of the categories below
                       from page
                       join categorylinks on page_id = cl_from
                       where cl_to in ('Wikipedia_substituted_templates',
                                       'Wikipedia_transclusionless_templates',
                                       'Deprecated_templates_kept_for_historical_reasons',
                                       'Inactive_project_pages',
                                       'Parameter_shared_content_templates',
                                       'Computer_language_user_templates',
                                       'Language_user_templates',
                                       'Template_test_cases',
                                       'Template_sandboxes',
                                       'Level-zero_userbox_templates')
                        and page_namespace = 10)
and page_title not in (select page_title -- Excludes templates with title matching any on the below patterns
                       from page
                       where page_title like 'Attached_KML%'
                       or page_title like 'Did_you_know_nominations%'
                       or page_title like 'Editnotices/Page/%'
                       or page_title like 'TFA_title/%'
                       or page_title like '%stub')
order by page_title asc; -- Arrange in ascending order
SQL

Checking query status...
