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
CptViraj
.
Toggle Highlighting
SQL
SELECT ROW_NUMBER() OVER (ORDER BY user_name) AS 'No.', user_name AS 'User', ipb_by_text AS 'Blocker', ipb_expiry AS 'Expiry', ipb_reason AS 'Reason' FROM user JOIN ipblocks_compat ON user_id = ipb_user WHERE user_name IN ( 'Trialpears', 'Trigenibinion', 'TUBS', 'TwinsMetsFan', 'Typ932', 'Ubcule', 'Uncitoyen', 'Uziel302', 'V-wolf', 'ValterVB', 'Vanisaac', 'Varnent', 'Vascer', 'Vauxford', 'VIGNERON_en_résidence', 'Viswaprabha', 'Voice_of_Clam', 'Voidxor', 'Voll', 'VulcanSphere', 'Wasiul_Bahar', 'Was_a_bee', 'Wieralee', 'WikiLaurent', 'WikiLucas00', 'Winiar', 'WolfgangRieger', 'WorldTraveller101', 'Wvk', 'Xaosflux', 'Xaris333', 'Yamaha5', 'Yarnalgo', 'Yeeno', 'yousaf465', 'YuriNikolai', 'Zabe', 'Zaccarias', 'Zachary', 'ZLEA', 'Zyxw', 'ZI_Jony', 'আফতাবুজ্জামান' );
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...