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.