IPv6 /64 subnets w/most edits

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

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;

AخA
 
SELECT COUNT(*), CONCAT(SUBSTRING_INDEX(actor_name, ':', 4), '::/64') AS subnetFROM revision_userindexJOIN actor_revision ON rev_actor = actor_idWHERE actor_user IS NULL  AND actor_name LIKE '%:%'GROUP BY subnetHAVING COUNT(*) >= 5000ORDER 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.

SQL

Checking query status...