Unused templates

SQL

select page_id, page_title
from page
left join linktarget on page_namespace = lt_namespace
                        and page_title = lt_title
where page_namespace = 10
and page_is_redirect = 0
and lt_id is null
and page_title not in (select page_title
                       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
                       from page
                       where page_title like 'Attached_KML%')
order by page_title asc;
SQL

Checking query status...
