Untitled query #77149

SQL

use fawiki_p;
select
  user_id,
  user_name
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 > '20221009000000' -- last 12 months leading to nomination start date
    and rev_timestamp < '20231009000000'
  group by rev_actor
  having count(*) >= 100
) onehundred -- at least 100 edits in main namespace
  on actor_id = onehundred.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 < '20230709000000' -- occurred 3 or more months prior to nomination start date
    )
    or exists (
      select 1
      from revision_userindex
      where rev_actor = actor_id
      and rev_timestamp < '20230709000000' -- occurred 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_id,
  user_name
SQL

Checking query status...
