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 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
*/
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.
Query status: failed
Error
Unknown column 'revision.rev_user_text' in 'on clause'