USE zhwiki_p;

select distinct

  CONCAT("Template:", tl_title)

from

  page_restrictions sres

  join templatelinks on tl_from = sres.pr_page

  join page spage on pr_page = spage.page_id

  join page dpage on dpage.page_namespace = tl_namespace

  and dpage.page_title = tl_title

where

  pr_cascade = 1

  and not exists (

    select

      1

    from

      page_restrictions dres

    where

      dres.pr_type = "edit"

      and dres.pr_level = "sysop"

      and dres.pr_page = dpage.page_id

  )

  and dpage.page_namespace = 10;