Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
5th Parliament Wikidata Edit Count in Time Frame
by
Celestinesucess
This query is marked as a draft
This query has been published
by
Masssly
.
This query was used to determine participants with the highest Wikidata edit count in the 5th Parliament of Ghana Challenge that run from 1 July 2020 UTC to 12 July 2020 UTC. See: http://bit.ly/GOIF_3rd_Contest
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 ( "Masssly", "Shahadusadik", "Celestinesucess", "Nana yaa series", "Sunkanmi12", "Oladipupo193", "Kinvidia", "Malak10", "Abdul2274", "Mwintirew", "Rosy86", "DaSupremo", "Mukaram123", "Elkay20", "Warmglow", "Piousmaiden", "Naa2Darkoa", "Mody Mickey", "Roihanot Musbaudeen Ajoke", "Dhee jah", "E4Esau", "Nimot123", "Hannah Nyame", "FZ007", "KBoateng77", "Raby2020", "Halimzylat", "Nana Akua Adobea" ) and rev_timestamp between 20200701000000 and 20200712235959 # from June 30, 2020 00:00:00 UTC to July 12, 2020 23:59:59 UTC and page_namespace in (0, 118) # 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...