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 log_title, COUNT(log_title) 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})?$' -- no IPv6 addresses (and ranges) AND log_params LIKE '%WikiBayer%e%' -- only consider blocks by user xxx GROUP BY log_title HAVING COUNT(log_title)>=10 -- otherwise quickly inefficient ORDER BY number_of_blocks DESC;
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...