nlwiki Number of recently active IPv6 users grouped by /64

Fork of nlwiki Anonymous edits rc_patrolled summary by Bdijkstra

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

SQL

# anonymous edits totals
SELECT actor_name
FROM recentchanges, actor
WHERE rc_actor=actor_id AND actor_user IS NULL
GROUP BY rc_patrolled
LIMIT 10;

# anonymous edits per day
SELECT *
FROM recentchanges, actor
WHERE rc_actor=actor_id AND actor_user IS NULL
GROUP BY day
LIMIT 10;

# top 10 anonymous users with the most unpatrolled edits
SELECT actor_name AS `user`, COUNT(*) AS `unpatrolled`
FROM recentchanges, actor
WHERE rc_actor=actor_id AND actor_user IS NULL AND rc_patrolled=0
GROUP BY actor_name
ORDER BY `unpatrolled` DESC
LIMIT 10;

SQL

Checking query status...