Untitled query #86842

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 (

  "Mercyhamb123",


"

"James",
"Kambai Akau",
"Issahiddris",
"Olugold",
"DaSupremo",
"Amire80",
"Acesuares",
"Onwuka Glory",
"Zak Raha",
"Sannita",
"Shahadusadik",
"Hasslaebetch",
"Daberechi16",
"cdilalo47",
"Caoimhin",
"Zend2020",
"Merlin266",
"Musahfm",
"Auregann"
"Sir Amugi"
)
and rev_timestamp between 20241001100000 and 20241004115959 # from October 01, 2024 10:00:00 UTC to October 04, 2024 11:59:59 UTC
and page_namespace in (0,120) # Wikidata main and draft
group by rev_actor
SQL

Checking query status...
