Fork of Pickled accounts at FA WP by Huji
This query is marked as a draft This query has been published by Alfa80.

SQL

x
 
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
*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...