1st Parliament of the 2nd Republic of Ghana Wikipedia Edit Count in Time Frame

This query was used to determine participants with the highest Wikipedia edit count in the 3rd Parliament of Ghana Challenge that run from 1 September 2020  UTC to 15 September  2020 UTC. See:  https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Ghana/Parliament_of_Ghana/Members_of_the_3rd_Parliament_of_the_4th_Republic_of_Ghana/Contest

SQL

select actor_name, count(*) as edits
from enwiki_p.revision_userindex r
join enwiki_p.actor a on r.rev_actor = a.actor_id
join enwiki_p.page p on r.rev_page = p.page_id
where actor_name in (
"Masssly",
"Shahadusadik",
"Celestinesucess",
"Nana yaa series",
"Sunkanmi12",
"Kinvidia",
"Piousmaiden",
"Mwintirew",
"Rosy86",
"DaSupremo",
"Amoaniwaa",
"Emmanuel Kems",
"Warmglow",
"Naa2Darkoa",
"Oladipupo193",
"Roihanot Musbaudeen Ajoke",
"Dhee jah",
"E4Esau",
"Kisualhassan",
"Hannah Nyame",
"Kjkwik",
"Jemima2019",
"Mody Mickey",
"Nimot123",
"Afiriyie1Otabil",
"Lydiadj",
"Raby2020"
)
and rev_timestamp between 20200901000000 and 20200915235959 # from September 1, 2020 00:00:00 UTC to September 15, 2020 23:59:59 UTC
and page_namespace in (0, 118) # Main and Draft
group by rev_actor

SQL

Checking query status...