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

SQL

SELECT
  concat(
    "* [[Template:",
    replace(srcpage.page_title, "_", " "),
    "]]"
  ) AS srctitle,
  srcrestrs.pr_level,
  dstrestrs.pr_level
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
  1 = 1
LIMIT 1
;

SQL

Checking query status...