User:DWalden (WMF)/IPInfo/edit

Query[edit]

To find these, I ran this query on the beta database:

SELECT DISTINCT page_title
FROM revision_actor_temp AS rat
INNER JOIN actor ON rat.revactor_actor = actor.actor_id
INNER JOIN page ON rat.revactor_page = page.page_id
WHERE actor.actor_user IS NULL AND actor.actor_name RLIKE "^[0-9A-F]{1,4}[\.:][0-9A-F]{1,4}"
LIMIT 100;

enwiki beta[edit]

First 100 found:

testwiki[edit]