Fork of
enwiki proxy blocks by month
by AntiCompositeNumber
This query is marked as a draft
This query has been published
by AntiCompositeNumber.
SQL
AخA
SELECT *
FROM ipblocks_ipindex
JOIN comment_ipblocks ON ipb_reason_id = comment_id
JOIN actor_ipblocks ON ipb_by_actor = actor_id
WHERE
ipb_user = 0
AND ipb_auto = 0
AND actor_name = "ST47ProxyBot"
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.