Underprotected templates used in MediaWiki namespace

SQL

use arwiki_p;
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") /* I personally think that this rule shouldn't be there, but consensus says it is OK */
               )
and (dst.page_namespace = 10 or dst.page_namespace = 828)

/* 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 not like "%.js"
and dst.page_title not like "Editnotices/%" /* this is covered by the title blacklist */
SQL

Checking query status...
