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%';
SQL

Checking query status...
