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
Fish and karate
.
Toggle Highlighting
SQL
--Most edits to a single page by a single user use enwiki_p; select data.page_title, data.user_name rank() over (partition by data.page_title,data.user_name order by data.Revisions desc) ( select p.page_title, count(distinct r.rev_id) Revisions, u.user_name from page p join revision r on r.page_id = p.page_id join users u on u.user_id = p.user_id group by p.page_title, u.user_name ) data where data.rank = 1
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...