Wikidata Edit Count in time frame

This query was used to determine participants with the highest Wikidata edit count in the Parliament of Ghana Challenge that run from 25 January 2020  UTC to 24 February  2020 UTC. See:  https://w.wiki/G6n

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",
"Muhibudeen",
"Sunkanmi12",
"Oladipupo193",
"Kinvidia",
"Malak10",
"Darkemperror",
"PymeFA",
"Mwintirew",
"Amuzujoe",
"DaSupremo",
"NawafSageSumani",
"Mukaram123",
"Elkay20",
"Warmglow",
"Piousmaiden",
"Hafiz9362",
"DarkNORTHning",
"Roihanot Musbaudeen Ajoke",
"Rahma Momie",
"Hajj Cissey",
"SalimQuo",
"Yussif Salamatu",
"Sanimuhaimin94",
"Rahma Momie"
)
and rev_timestamp between 20200125000000 and 20200224235959 # from January 25, 2020 00:00:00 UTC to February 24, 2020 23:59:59 UTC
and page_namespace in (0, 118) # Main and Draft
group by rev_actor

SQL

Checking query status...