Fork of 2021 eligible voters for Board elections - FINAL by MPossoupe (WMF)
This query is marked as a draft This query has been published by Geraki.

SQL

AخA
 
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 > '20210712000000' -- edits from  12 May 2021
  group by actor_user
  having count(*) >= 1
) onefive -- at least 15 edits from 05 January 2021 to 05 July 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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...