Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
WikiBayer
.
Toggle Highlighting
SQL
SELECT COUNT(*) AS number_of_blocks FROM logging_userindex WHERE log_namespace=2 AND log_type='block' AND log_action='block' AND -- but not 'reblock' or 'unblock' log_title NOT REGEXP '^[0-9]{1,3}(\.[0-9]{1,3}){0,3}(\/[0-9]{1,2})?$' AND -- no IPv4 addresses (and ranges) log_title NOT REGEXP '^[0-9A-Fa-f]{1,4}(:([0-9A-Fa-f]{1,4})?){1,7}(\/[0-9]{1,2})?$' AND -- no IPv6 addresses (and ranges) user_id = 'Seewolf' GROUP BY user_id
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...