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" or srcrestrs.pr_level = "templateeditor")

  AND srcpage.page_namespace = 10

  AND dstrestrs.pr_level = "extendedconfirmed"

;