Underprotected templates used in MediaWiki namespace

SQL

select distinct 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 page_restrictions where pr_page = dst.page_id and pr_type = "edit" and 
                (pr_level = "sysop" or pr_level = "templateeditor")
               )
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 "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 templatelinks tl2 where tl2.tl_namespace = dst.page_namespace 
                and tl2.tl_title = dst.page_title and tl2.tl_from = 15580374) /* Exclude pages cascade-protected via the main page */
SQL

Checking query status...
