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 * from revision
#limit 50;

select * from actor a
 where  actor_user IS NULL

#and actor_name like '81.%'
inner join revision r 
on r.rev_actor=a.actor_id
and a.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...