Untitled query #66079

SQL

select actor_name, count(*) as items
from wikidatawiki_p.item_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 (
"Henry Ojonugwa",
"AgnesAbah",
"Hesyomi",
"Afolabi ilerioluwa",
"Macocobovi",
"Nwonwu Uchechukwu P",
"Accuratecy051",
"Princejvic",
"Newtrains",
"Samstringz",
"Jeremyida002",
"Korie uchechi Jennifer",
"Nwosuphayvour",
"Sayvhior",
"Obedmakolo",
"Johnlegendbest147",
"Celetex",
"Emmafman1",
"Trailblazher",
"Chomsibaby",
"Olugold"
)
and rev_timestamp between 20220604000000 and 20220704235959 # from June 04, 2022 00:00:00 UTC to July 04, 2022 11:59:59 UTC
and page_namespace in (0,487) # Wikidata main and drafts
group by rev_actor
SQL

Checking query status...
