1st Parliament Wikidata Edit Count in Time Frame

This query was used to determine participants with the highest Wikidata edit count in the 1st Parliament of Ghana Challenge that run from 1 February 2021  UTC to 27 February  2021 UTC. See:  https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Ghana/Parliament_of_Ghana/Members_of_the_1st_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 (
"Celestinesucess",
"Nana yaa series",
"Sunkanmi12",
"Kinvidia",
"Piousmaiden",
"Mwintirew",
"Mukaram123",
"Naa2Darkoa",
"Leonelawidi10",
"Warmglow",
"Lydiadj",
"Roihanot Musbaudeen Ajoke",
"E4Esau",
"Hannah Nyame",
"OkuJet",
"Jemima2019",
"Shayaw Mohammed Abubakar",
"Nimot123",
"Emirdanbaba",
"Alinho14",
"Amana401",
"Douglas Tabariyeng",
"Faatimaa"
)
and rev_timestamp between 20210130000000 and 20210227235959 # from February 1, 2021 00:00:00 UTC to February 27, 2021 23:59:59 UTC
and page_namespace in (0, 118) # Main and Draft
group by rev_actor

SQL

Checking query status...