Untagged templates used in MediaWiki namespace

SQL

select concat("* [[{{subst:ns:", tl_namespace, "}}:", tl_title, "]]") from templatelinks 
join page src on tl_from = src.page_id
join page dst on tl_namespace = dst.page_namespace and tl_title = dst.page_title
where src.page_namespace = 8 
and not exists (select 1 from templatelinks tl2 where tl_from = dst.page_id and tl_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 != "Course_description"  /* nominated for deletion */
and src.page_title != "Editnotice-8" /* nominated for deletion, anything missing will be covered by other editnotice-XXX */
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 not like "Abusefilter%" /* exclude abusefilter warnings */
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 not like "%.js"
and dst.page_is_redirect = 0
group by dst.page_title;
SQL

Checking query status...
