Cascade-protected templates lacking full protection

SQL

select distinct
  concat("* [[Template:", replace(lt_title,"_"," "), "]]")
from
  page_restrictions sres
  join templatelinks on tl_from = sres.pr_page
  join linktarget on lt_id=tl_target_id
  join page spage on pr_page = spage.page_id
  join page dpage on dpage.page_namespace = lt_namespace
  and dpage.page_title = lt_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_title not like "POTD_protected%"
  and dpage.page_title not like "Selected_anniv%"
  and dpage.page_title not like "Today's_featured_article%"
  -- and spage.page_title not like "%Main_Page%";
SQL

Checking query status...
