My Northern Achiever Challenge Dagbani (Incubator) edit count

Fork of My Northern Achiever Challenge Wikidata edit count by Shahadusadik

This query is marked as a draft This query has been published by Shahadusadik.

SQL

select actor_name, count(*) as edits
from incubatorwiki_p.revision_userindex r
join incubatorwiki_p.actor a on r.rev_actor = a.actor_id
join incubatorwiki_p.page p on r.rev_page = p.page_id
where actor_name in (
"Masssly",
"Abubakari Khadijah",
"Shahadusadik",
"Dnshitobu",
"SalimQuo",
"Alhassan Mohammed Awal",
"Din-nani1",
"Zak Raha",
"Hidrash",
"Achiri Bitamsimli",
"Alhaj Darajaati",
"Yabeha wiki",
"Hasslaebetch",
"Alhassan Peter",
"Musahfm",
"IBS-Gh",
"Dhee jah",
"Kum1989",
"Karimba Asani",
"Ernesztina",
"Alidu Shafawu",
"Lukmanbamba"
)
and rev_timestamp between 20201001000000 and 20201031235959 # from October 1, 2020 00:00:00 UTC to October 31, 2020 23:59:59 UTC
and page_namespace in (0, 118) # Main and Draft
group by rev_actor

SQL

Checking query status...