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
  -- local
  join logging_userindex on log_actor = actor_id
where
  and log_type="delete"
  and not exists (select 1 from user_groups where ug_user = actor_user and ug_group="sysop")
  and (select count(*) from archive where ar_namespace=log_namespace and ar_title=log_title) > 5000
order by log_timestamp desc
  limit 100;
SQL

Checking query status...
