Possible violations of global rights policy (March 2020+, simplewiki)

SQL

select user_name, user_editcount, user_registration, rev_id, page_namespace, page_title from revision 
join page_restrictions on pr_page=rev_page join page on page_id=rev_page join actor on rev_actor=actor_id join user on user_id=actor_user
where pr_type="edit" and pr_level="templateeditor" and rev_timestamp > "20190501010101"
and not exists (select * from user_groups where ug_user=user_id and (ug_group="templateeditor" || ug_group="sysop")) limit 10
/* Full protection */
select user_name, user_editcount, user_registration, rev_id, page_namespace, page_title from revision 
join page_restrictions on pr_page=rev_page join page on page_id=rev_page join actor on rev_actor=actor_id join user on user_id=actor_user
where pr_type="edit" and pr_level="templateeditor" and rev_timestamp > "20190501010101"
and not exists (select * from user_groups where ug_user=user_id and ug_group="sysop") limit 10
SQL

Checking query status...
