4th Parliament Wikidata Edit Count in Time Frame

This query was used to determine participants with the highest Wikidata edit count in the 4th Parliament of Ghana Challenge that run from 1 August 2020  UTC to 12 August  2020 UTC. See:  https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Ghana/Parliament_of_Ghana/Members_of_the_4th_Parliament_of_the_4th_Republic_of_Ghana/Contest

SQL

select actor_name, count(*) as edits
from wikidatawiki_p.revision_userindex r
join wikidatawiki_p.actor a on r.rev_actor = a.actor_id
join wikidatawiki_p.page p on r.rev_page = p.page_id
where actor_name in (
"Masssly",
"Shahadusadik",
"Celestinesucess",
"Nana yaa series",
"Sunkanmi12",
"Kinvidia",
"Abdul2274",
"Mwintirew",
"Rosy86",
"DaSupremo",
"Amoaniwaa",
"Emmanuel Kems Bigodza",
"Warmglow",
"Naa2Darkoa",
"Delalorm",
"Roihanot Musbaudeen Ajoke",
"Dhee jah",
"E4Esau",
"Babbiegurl1",
"Hannah Nyame",
"Kjkwik",
"Jemima2019",
"Raby2020"
)
and rev_timestamp between 20200801000000 and 20200812235959 # from June 30, 2020 00:00:00 UTC to July 12, 2020 23:59:59 UTC
and page_namespace in (0, 118) # Main and Draft
group by rev_actor

SQL

Checking query status...