Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Olugold
.
total edits by this users for BLT contest (ran for the 2nd time, added total number of revisions from the dashboard)
Toggle Highlighting
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 ( "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 (22,000) # Wikidata main and draft group 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
.
Checking query status...
