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(*) 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')
      )
    ) * 100
SQL

Checking query status...
