Untagged templates used in MediaWiki namespace

SQL

select concat("* [[{{subst:ns:", tl_namespace, "}}:", tl_title, "]]"), count(src.page_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 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 dst.page_is_redirect = 0
group by dst.page_title;
SQL

Checking query status...
