Possible violations of global rights policy (cascade)

Not added due to extremely low volume (6 entries in last 10 months, 9 in last 32). May incoroprate in main GRP query if main page editor rights get created.

The first true positive this found was Sophovirus's 2017 edit, which was an improper use of GIE permissions

SQL

select distinct 
  tl_namespace, tl_title, rev_id, actor_name, comment_text
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
  join revision on rev_page=dpage.page_id
  join actor_revision on actor_id=rev_actor
  join comment_revision on comment_id=rev_comment_id
where
  pr_cascade = 1
  and dpage.page_namespace = 10
  and not exists (select 1 from user_groups where ug_user=actor_user and ug_group="sysop")
  and not exists (select 1 from user_former_groups where ufg_user=actor_user and ufg_group="sysop")
  order by rev_timestamp desc
limit 15;

SQL

Checking query status...