nlwiki IPv4/IPv6 edits

SQL

SELECT 'total' AS `family`, COUNT(actor_name) AS `count`
FROM actor, recentchanges
WHERE rc_source REGEXP '^mw.' AND actor_user IS NULL AND actor_id=rc_actor
UNION
SELECT 'IPv4', COUNT(an4.actor_name)
FROM (SELECT actor_name FROM actor, recentchanges WHERE rc_source REGEXP '^mw.' AND actor_user IS NULL AND actor_id=rc_actor) an4
WHERE an4.actor_name REGEXP '\\.'
UNION
SELECT 'IPv6', COUNT(an6.actor_name)
FROM (SELECT actor_name FROM actor, recentchanges WHERE rc_source REGEXP '^mw.' AND actor_user IS NULL AND actor_id=rc_actor) an6
WHERE an6.actor_name REGEXP ':'
SQL

Checking query status...
