Fork of
Blocked users in fawiki
by Woolshin
This query is marked as a draft
This query has been published
by PaigePhault.
SQL
AخA
Use eswiki_p;
SELECT log_comment, log_user, log_title, log_user_text FROM logging
WHERE
log_type = 'block'
AND log_action in ('block', 'reblock')
AND log_comment LIKE '%User:%'
LIMIT 10000;
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.