First Part - Quarry

SQL

use fawiki_p;
select count(*)
from user
join actor
  on actor_user = user_id
where
  (
    exists (
      select 1
      from logging_userindex
      where log_actor = actor_id
      and log_type = 'newusers'
      and log_action in ('create', 'autocreate')
      and log_timestamp < '20200712000000' -- occured 3 or more months prior to nomination start date
    )
    or exists (
      select 1
      from revision_userindex
      where rev_actor = actor_id
      and rev_timestamp < '20200712000000' -- occured 3 or more months prior to nomination start date
    )
  ) and
  not exists (
    select 1
    from user_groups
    where ug_user = user_id
    and ug_group = 'bot'
  )
order by user_name
SQL

Checking query status...
