Template redirects with too high protection level (target level: TE)

SQL

SELECT
  concat(
    "* [[Template:",
    replace(srcpage.page_title, "_", " "),
    "]]"
  ) AS srctitle
FROM
  page as srcpage
  JOIN page_restrictions as srcrestrs ON srcrestrs.pr_page = srcpage.page_id
  AND srcrestrs.pr_type = "edit"
  JOIN redirect ON rd_from = srcpage.page_id
  JOIN page as dstpage ON dstpage.page_namespace = rd_namespace
  AND dstpage.page_title = rd_title
  JOIN page_restrictions as dstrestrs ON dstrestrs.pr_page = dstpage.page_id
  AND dstrestrs.pr_type = "edit"
WHERE
  srcrestrs.pr_level = "sysop"
  AND srcpage.page_namespace = 10
  AND dstrestrs.pr_level = "templateeditor"
;

SQL

Checking query status...