nlwiki User talk by IPv6 users

SQL

SELECT actor_name, page_title, rev_timestamp
FROM revision, actor, page
WHERE
	rev_actor=actor_id AND
    rev_page=page_id AND
    page_namespace=3 AND
    actor_user IS NULL AND
    actor_name REGEXP '^[0-9A-F:]+$' AND
    page_title REGEXP '^[0-9A-F:]+/[0-9]+$'
ORDER BY rev_timestamp DESC
LIMIT 100;
SELECT actor_name, page_title, rev_timestamp
FROM revision, actor, page
WHERE
	rev_actor=actor_id AND
    rev_page=page_id AND
    page_namespace=3 AND
    actor_user IS NULL AND
    actor_name REGEXP '^[0-9A-F:]+$' AND
    page_title REGEXP '^[0-9A-F:]+$'
ORDER BY rev_timestamp DESC
LIMIT 100
SQL

Checking query status...
