统计启用$wgUseRCPatrol特定时间内统计巡查标识

具体信息参见 Recentchanges 表：
https://www.mediawiki.org/wiki/Manual:Recentchanges_table
字段rc_type代表编辑类型，其中0为页面编辑
字段rc_patrolled代表巡查类型，0 为 未标记（默认），1为 手工标记， 2 为 自动标记（例如有自动自标记权限的）

SQL

begin
select count(rc.id) sum_count
from recentchanges rc
inner join revision rv on rc.rc_this_oldid = rv.rev_id 
inner join page p on rv.rev_page = p.page_id
left join actor ac on rv.rev_actor = ac.actor_id
where rc.rc_type in ('1')   and rc.rc_timestamp >  '20220523131438'
;
select rc.rc_patrolled,count(rc.id) patrolled_count
from recentchanges rc
inner join revision rv on rc.rc_this_oldid = rv.rev_id 
inner join page p on rv.rev_page = p.page_id
left join actor ac on rv.rev_actor = ac.actor_id
where rc.rc_type in ('1')   and rc.rc_timestamp >  '20220523131438'
group by rc.rc_patrolled;
end;

SQL

Checking query status...