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(log_title) AS Anzahl_der_Sperren, log_title FROM logging_userindex WHERE log_namespace=2 AND log_type='block' AND log_action='block' AND -- aber nicht 'reblock' oder 'unblock' log_title NOT REGEXP '^[0-9]{1,3}(.[0-9]{1,3}){0,3}(/[0-9]{1,2})?$' AND -- keine IPv4-Adressen (und Bereiche) log_title NOT REGEXP '^[0-9A-Fa-f]{1,4}(:([0-9A-Fa-f]{1,4})?){1,7}(/[0-9]{1,2})?$' -- keine IPv6-Adressen (und Bereiche) GROUP BY log_title HAVING COUNT(log_title)>=10 -- sonst schnell ineffizient ORDER BY Anzahl_der_Sperren 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...