- Quarry

Fork of Top 50 Users with Most Edits in a Single Article by Elph

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

SQL

SELECT page.page_title, actor_name AS user_name, COUNT(rev_id) AS num_revisions
FROM revision
JOIN page ON revision.rev_page = page.page_id
JOIN actor ON revision.rev_actor = actor.actor_id
WHERE page_namespace = 0
GROUP BY page.page_title, actor_name
ORDER BY num_revisions DESC
LIMIT 50;

​x
 
SELECT page.page_title, actor_name AS user_name, COUNT(rev_id) AS num_revisionsFROM revisionJOIN page ON revision.rev_page = page.page_idJOIN actor ON revision.rev_actor = actor.actor_idWHERE page_namespace = 0GROUP BY page.page_title, actor_nameORDER BY num_revisions DESCLIMIT 50;​​

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...