Replicas browser and optimizer
This query is marked as a draft
This query has been published
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
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;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in