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

  srcpage.page_namespace = 10

  AND (

    ( srcrestrs.pr_level = "sysop" AND dstrestrs.pr_level != "sysop")

    OR (srcrestrs.pr_level = "templateeditor" and dstrestrs.pr_level != "templateeditor" AND dstrestrs.pr_level != "sysop")

    OR (srcrestrs.pr_level = "extendedconfirmed" and dstrestrs.pr_level != "templateeditor" AND dstrestrs.pr_level != "sysop" 

        and dstrestrs.pr_level != "extendedconfirmed"

       )

    OR (srcrestrs.pr_level = "editsemiprotected" and dstrestrs.pr_level = NULL)

  )

;