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

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

具体信息参见 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
from recentchanges rc
where rc.rc_type in ('1')   and rc.rc_timestamp >  '20220523131438' /* T308976 */
;
select rc.rc_patrolled,count(rc.rc_id) patrolled_count
from recentchanges rc
where rc.rc_type in ('1')   and rc.rc_timestamp >  '20220523131438' /* T308976 */
group by rc.rc_patrolled;
commit;

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...