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

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

SQL

begin;
select count(rc.rc_id) sum_count,min(rc.rc_timestamp) min_tc_time,max(rc.rc_timestamp) max_tc_time
from recentchanges rc
where rc.rc_type in ('0')   and rc.rc_timestamp >  '20220522145422' /* T308976 */
;
select rc.rc_patrolled,count(rc.rc_id) patrolled_count
from recentchanges rc
where rc.rc_type in ('0')   and rc.rc_timestamp >  '20220522145422' /* T308976 */
group by rc.rc_patrolled;
commit;
/* 上面查询为第一次提交修订的提交时间，下面查询为合并生产时间 */
begin;
select count(rc.rc_id) sum_count,min(rc.rc_timestamp) min_tc_time,max(rc.rc_timestamp) max_tc_time
from recentchanges rc
where rc.rc_type in ('0')   and rc.rc_timestamp >  '20220523131438' /* T308976 */
;
select rc.rc_patrolled,count(rc.rc_id) patrolled_count
from recentchanges rc
where rc.rc_type in ('0')   and rc.rc_timestamp >  '20220523131438' /* T308976 */
group by rc.rc_patrolled;
/* 合并生产时间后，手工巡查的页面编辑 */
select ac.actor_name,u.user_name,rc.*
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
left join user u on ac.actor_user = u.user_id
where rc.rc_type in ('0')  and rc.rc_patrolled ='1' and rc.rc_timestamp >  '20220523131438'
;
commit;

SQL

Checking query status...