Wikidata edits count [Translate Wikidata properties event]

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

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 (
"Ngostary2k",
"Obuezie",
"Akwugo",
"Accuratecy051",
"Kingsley Nkem",
"Timzy D'Great",
"Lebron jay",
"Dera xoxo",
"Queenbella001",
"Iwuala Lucy",
"Chrysella",
"Nzechimere",
"Daberechi16",
"Nwonwu Uchechukwu P",
"Korie uchechi Jennifer",
"Viva33",
"Senator Choko",
"Nneka Ibeanu",
"Juliegwen",
"Frankincense Diala",
"Palow s coba11",
"Sayvhior",
"Ennydavids",
"Nwosuphayvour",
"Chomsibaby",
"Onyeike Izuchi",
"Decherub",
"Celetex",
"Ngoudechi",
"AmarachukwuEbo",
"Adaemelumgini",
"Immaculata Joan"
"Ngoudechi",
"Odogwu123"
)
and rev_timestamp between 20220804095959 and 20220804205959 # from August 04, 2022 09:59:59 UTC to August 07, 2022 18:30:59 UTC
group by rev_actor

AخA
 
select actor_name, count(*) as editsfrom wikidatawiki_p.revision_userindex rjoin wikidatawiki_p.actor a on r.rev_actor = a.actor_idjoin wikidatawiki_p.page p on r.rev_page = p.page_idwhere actor_name in ("Ngostary2k","Obuezie","Akwugo","Accuratecy051","Kingsley Nkem","Timzy D'Great","Lebron jay","Dera xoxo","Queenbella001","Iwuala Lucy","Chrysella","Nzechimere","Daberechi16","Nwonwu Uchechukwu P","Korie uchechi Jennifer","Viva33","Senator Choko","Nneka Ibeanu","Juliegwen","Frankincense Diala","Palow s coba11","Sayvhior","Ennydavids","Nwosuphayvour","Chomsibaby","Onyeike Izuchi","Decherub","Celetex","Ngoudechi","AmarachukwuEbo","Adaemelumgini","Immaculata Joan""Ngoudechi","Odogwu123")and rev_timestamp between 20220804095959 and 20220804205959 # from August 04, 2022 09:59:59 UTC to August 07, 2022 18:30:59 UTCgroup by rev_actor

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...