User is autoreviewed but not autopatrolled

This query is marked as a draft This query has been published by Zache.

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

SQL

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;

AخA
 
USE ptwiki_p;SELECT   rc_title,   rc_patrolled,   fr_flags,   rc_user_text,   rc_this_oldid FROM   flaggedrevs,   recentchangesWHERE   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 Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...