Untagged templates used in MediaWiki namespace

SQL

select distinct concat("* [[{{subst:ns:", lt_namespace, "}}:", lt_title, "]]") from templatelinks
join linktarget on lt_id=tl_target_id
join page src on tl_from = src.page_id
join page dst on lt_namespace = dst.page_namespace and lt_title = dst.page_title
where src.page_namespace = 8 
and not exists (select 1 from templatelinks tl2 join linktarget lt2 on 
                lt2.lt_id=tl2.tl_target_id where tl_from = dst.page_id and lt_namespace=10 and lt_title = "Used_in_system")
and (dst.page_namespace = 10 or dst.page_namespace = 828)
and src.page_title != "Deletedtext" and src.page_title != "Filedelete-success" /* these messages transclude their own talk page */
and src.page_title not like "Ffeed%" /* while templates used on the main page are protected, they don't need to be tagged 
as used in system, even though [[mw:Extension:FeaturedFeeds]] is installed */ 
and src.page_title != "Category-move-redirect-override" /* not a system message in the normal sense */
and src.page_title not like "Ipbreason-dropdown%"
and src.page_title not like "Spam-%list/Indicators"
and src.page_title != "Watcheditlist/Check_all"
and src.page_title != "Noautocreatetext" /* Unused message? */
and src.page_title != "Noautocreatetext/en-CA" /* Sigh */
and src.page_title != "Abusefilter-warning-throttled" /* Disabled filter */
and src.page_title != "Abusefilter-warning-NoIPedits" /* Disabled filter */
and src.page_title != "Watchlist-messages" /* Too many false positives from documentation */
and src.page_content_model = "wikitext"
and src.page_is_redirect = 0
and src.page_title != "Move-redirect-text"
and dst.page_content_model != "sanitized-css"
and dst.page_title not like "Documentation%"
and dst.page_title != "Editnotices/Namespace/MediaWiki"
and dst.page_is_redirect = 0
SQL

Checking query status...
