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
Cryptic
.
IPv6 addresses with the most live edits to enwiki, grouped by /64 subnets. While this is the usual size of a block of addresses assigned to an individual (see e.g. [[WP:/64]]), those with the highest edit counts are likely widely dynamic. For [[WP:VPM#Interesting question about edit counts]] circa 27 June 2022. (The query I mention there that covers IPv4 addresses can't be run on Quarry; it took about 2 hours to complete, well over the time limit Quarry imposes.)
Toggle Highlighting
SQL
SELECT COUNT(*), CONCAT(SUBSTRING_INDEX(actor_name, ':', 4), '::/64') AS subnet FROM revision_userindex JOIN actor_revision ON rev_actor = actor_id WHERE actor_user IS NULL AND actor_name LIKE '%:%' GROUP BY subnet HAVING COUNT(*) >= 5000 ORDER BY COUNT(*) DESC;
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...