ECP removals, 2018-present

SQL

SELECT log_timestamp,actor_name,log_title,comment_text,log_params from logging
  INNER JOIN actor ON logging.log_actor=actor.actor_id
  INNER JOIN comment on logging.log_comment_id = comment.comment_id
  WHERE logging.log_type="rights" AND logging.log_action="rights" AND log_timestamp > 20180000000000
  AND logging.log_params NOT REGEXP '"extendedconfirmed".*"extendedconfirmed"' AND logging.log_params REGEXP '.*extendedconfirmed.*' AND NOT logging.log_params REGEXP 'newgroups".*"extendedconfirmed"' AND NOT logging.log_params LIKE '%sysop%'
  AND NOT comment_text LIKE "%Wikipedia:Requests for adminship%" AND NOT comment_text LIKE "%WP:VANISH%" AND NOT comment_text LIKE "%Wikipedia:Bots" AND NOT comment_text LIKE "%days after event%";
SQL

Checking query status...
