Edit counts by time of +sysop CTE standalone

SQL

SELECT log_timestamp, actor_name, actor_id
  FROM logging
  JOIN actor_logging ON actor_name = REPLACE(log_title, '_', ' ')
  JOIN comment on log_comment_id = comment_id
  WHERE log_type = 'rights'
    AND log_action = 'rights'
    AND ( -- pre-Nov-2012 format
          (log_params LIKE '%\n%sysop%' -- new groups include sysop
           AND log_params NOT LIKE '%sysop%\n%' AND NOT log_params LIKE '%bot%' AND NOT comment_text LIKE '%Wikipedia:Bots%') -- old groups don't include sysop
          OR -- post-Nov-2012 format
          (log_params LIKE '%newgroups%sysop%' -- new groups include sysop
           AND log_params NOT LIKE '%oldgroups%sysop%newgroups%' AND NOT log_params LIKE '%bot%' AND NOT comment_text LIKE '%Wikipedia:Bots%') -- old groups don't include sysop
      	  OR -- early sysops 
      	  (comment_text LIKE '%+sysop%' AND NOT comment_text LIKE '%Wikipedia:Bots%' AND NOT log_params LIKE '%bot%')
        )
    AND actor_name NOT LIKE '%bot'
    AND actor_name not like '%Bot'
    AND log_timestamp > 20220000000000 AND log_timestamp < 20230000000000
  GROUP BY actor_name
SQL

Checking query status...
