Wikipedians missing

Query to get lists of eligible voters for 2021 Board elections based on contributions to individuals. Please note that this query doesn't exactly reflect the voting eligibility criteria - while the eligibility criteria counts are across wikis, the counts in this query are based on the selected wiki only.

SQL

use elwiki_p;
select
  user_name,
  twofifty.cnt as edits,
  onefive.cnt as recent_edits
from user
join 
(
  select
    actor_user,
    count(*) cnt
  from revision_userindex
  join actor_revision
    on rev_actor = actor_id
  join page
    on page_id = rev_page
  where
    rev_timestamp < '20210512000000' -- edits prior to 12 May 2021
  group by actor_user
  having count(*) >= 1000 -- at least 1000 edits in main namspace
) twofifty
  on user_id = twofifty.actor_user
join
(
  select
    actor_user,
    count(*) cnt
  from revision_userindex
  join actor_revision
    on rev_actor = actor_id
  join page
    on page_id = rev_page
  where
	rev_timestamp > '20210512000000' -- edits from 13 May 2021
  group by actor_user
  having count(*) >= 0 
) onefive -- 0 edits from 13 May 2021
  on user_id = onefive.actor_user
left join
(
  select ug_user
  from user_groups
  where ug_group = 'bot'
) bots
  on bots.ug_user = user_id
where
  bots.ug_user is null
order by user_name

SQL

Checking query status...