New edits marked as patrolled

SQL

SELECT (
  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
	) / (
  SELECT COUNT(DISTINCT rev_id) FROM revision
  INNER JOIN actor on revision.rev_actor = actor.actor_id
  INNER JOIN user_groups on actor.actor_user = user_groups.ug_user
  WHERE revision.rev_timestamp BETWEEN 20201201000000 AND 20210101000000
  AND user_groups.ug_group NOT IN ('autopatrolled','sysop','bot','reviewer','patroller','eliminator','botadmin') # Not comprehensive, but should discount unpatrollable edits in most cases
  ) * 100
SQL

Checking query status...
