Untitled query #57662

SQL

SELECT COUNT(*) FROM logging
WHERE log_type = "patrol"
AND log_action = "patrol"
AND log_timestamp BETWEEN 20201201000000 AND 20210101000000 
AND log_params NOT LIKE '%"5::previd";s:1%' # Ignore new page patrols
AND log_params LIKE '%"6::auto";i:0%' # Ignore autopatrols
AND # log_params previd needs to be from:
SELECT DISTINCT rev_id FROM revision
INNER JOIN actor on revision.rev_actor = actor.actor_id
WHERE revision.rev_timestamp BETWEEN 20201201000000 AND 20210101000000
# Not comprehensive, but should discount autopatrolled edits in most cases
AND actor.actor_user NOT IN (
	SELECT DISTINCT ug_user FROM user_groups WHERE ug_group IN ('autopatrolled','sysop','bot','reviewer','patroller','eliminator','botadmin')
)
SQL

Checking query status...
