First Part - Quarry

SQL

use fawiki_p;
select count(*)
from user
join actor
  on actor_user = user_id
join 
(
  select rev_actor
  from revision_userindex
  join page
    on page_id = rev_page
  where
    page_namespace = 0
    and rev_timestamp < '20201012000000' -- edits prior to nomination start date
  group by rev_user
  having count(*) >= 500
) fivehundred -- at least 500 edits in main namspace
  on actor_id = fivehundred.rev_actor
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...
