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
A smart kitten
.
Toggle Highlighting
SQL
select bl_id, DATE_FORMAT(bl_timestamp, '%Y-%m-%d %H:%i:%s'), actor_name, bt_address, bt_ip_hex, comment_text, bl_expiry, bl_anon_only, bl_create_account, bl_enable_autoblock, bl_block_email, bl_allow_usertalk, bl_sitewide, bt_count, bl_deleted, bl_parent_block_id, bt_user, bt_user_text, bt_auto, bt_range_start, bt_range_end from block inner join block_target on bt_id = bl_target inner join actor on actor_id = bl_by_actor inner join comment on comment_id = bl_reason_id where bt_address in ('203.160.001.146', '195.175.037.008', '195.175.037.006', '061.220.150.002');
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...