Replicas browser and optimizer
This query is marked as a draft
This query has been published
Content of recentchanges rc_patrolled and flaggedrevs review status when user is autoreviewed but he is not autopatrolled. - All lines should have rc_patrolled=1 , but currently only users which have autopatrol user right OR edit is patrolled manually are rc_patrolled=1
USE ptwiki_p; SELECT rc_title, rc_patrolled, fr_flags, rc_user_text, rc_this_oldid FROM flaggedrevs, recentchanges WHERE fr_rev_id=rc_this_oldid AND fr_flags LIKE "%auto%" AND rc_source="mw.edit" AND rc_namespace=0;
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