Underprotected templates used in MediaWiki namespace

SQL

select concat("* [[{{subst:ns:", tl_namespace, "}}:", tl_title, "]]"), 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 dst.page_namespace != 8 /* messages that transclude other messages are OK */
and dst.page_namespace != 9 /* Exclude messages that transclude their own talk page */
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 not exists (select 1 from page_restrictions where pr_page = dst.page_id and pr_type = "edit" and 
                (pr_level = "sysop" or pr_level = "templateeditor")
               )
and not exists (select 1 from templatelinks tl2 where tl2.tl_namespace = dst.page_namespace 
                and tl2.tl_title = dst.page_title and tl2.tl_from = 15580374) /* 15580374 is the page ID of the main page */
group by src.page_title;
SQL

Checking query status...
