nlwiki IPv4/IPv6 edits

SQL

SELECT COUNT(actor_name)
FROM actor, recentchanges
WHERE rc_source REGEXP '^mw.' AND actor_user IS NULL AND actor_id=rc_actor;

SELECT 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 '\\.';

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