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

SQL

SELECT
  concat(
    "Template:",
    replace(srcpage.page_title, "_", " ")
  ) AS srctitle,
  dstpage.page_namespace as dstns,
  replace(dstpage.page_title, "_", " ") as dsttitle
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 != "sysop"
;

SQL

Checking query status...