Deletes by stewards

SQL

select
  log_id,
  actor_name,
  log_namespace,
  log_title,
  log_timestamp,
  (select comment_text from comment where comment_id=log_comment_id) as "comment",
  (select count(*) from archive where ar_namespace=log_namespace and ar_title=log_title) as "deleted revision count"
from
  actor
  join centralauth_p.globaluser on gu_name = actor_name
  join centralauth_p.global_user_groups on gug_user = gu_id
  -- local
  join logging on log_actor = actor_id
where
  gug_group = 'steward'
  and log_type="delete"
  and log_timestamp > "20180000000000"
  and not exists (select * from user_groups where ug_user = actor_user and ug_group="sysop")
order by log_timestamp asc
  limit 100;
SQL

Checking query status...
