Contributions by IP octet (subnet invariant)

Fork of Pickled accounts at FA WP by Huji

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

SQL

use fawiki_p;
# logging.logtype = 
# 				  abusefilter, block, create, delete, import, lock, move, newusers, patrol
#				, protect, renameuser, review, rights, spamblacklist, thanks, upload

select actor.* from actor
  
#and actor_name like '81.%'
join revision  
on revision.rev_user_text=actor_user.actor_user
where actor_user IS NULL 
LIMIT  50

/*
select distinct (user_name) from user
where user_name like '81.%'
LIMIT  50

select distinct (log_type) from logging
where 
log_timestamp < '20210425'
and log_timestamp > '20210420'

LIMIT  50
*/

SQL

Checking query status...