Cascade-protected templates lacking full protection

SQL

select distinct
  spage.page_namespace,
  spage.page_title,
  tl_namespace,
  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
  /* and spage.page_title = "Cascade_protected_items/content" */
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
  );

SQL

Checking query status...