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 ( 'Pratyya_Ghosh', 'Prenn', 'Psubhashish', 'Pyfisch', 'QEDK', 'Quenhitran', 'Quibik', 'Queen_of_Hearts', 'QueerEcofeminist', 'R\'n\'B', 'Racconish', 'Rachel_Helps_(BYU)', 'Racso', 'Ravidreams', 'Rcsprinter123', 'Reedy', 'Reinhard_Kraasch', 'Rhododendrites', 'Rich_Farmbrough', 'RL0919', 'Robby', 'Robot_Monk', 'RodRabelo7', 'Rock_drum', 'Rodrigolopes', 'Rrburke', 'Rschen7754', 'Rsocol', 'Rubin16', 'Ryan_Vesey', 'Ryse93', 'Sadads', 'SamB', 'Samee', 'Samuel_Wiki', 'SamuelFreli', 'SamuelRiv', 'Sannita', 'Sannita_(WMIT)', 'Sarang', 'SarekOfVulcan', 'Sbb1413', 'SchuminWeb', 'Schwede66', 'Seb26', 'Ser_Amantio_di_Nicolao', 'Sevela.p', 'SiBr4', 'Sic19', 'Skarabeusz', 'Skorp24', 'Slaunger', 'Slb_nsk', 'Smalljim', 'Smallman12q', 'Smasongarrison', 'Snowmanradio', 'Sodabottle', 'Spinster', 'Spyder_Monkey', 'Sreejithk2000_AWB', 'Stannered', 'Stegop', 'Stevenfruitsmaak', 'Stillwaterising', 'Strainu', 'Stratosphere', 'Strobilomyces', 'Stuart.Jamieson', 'Suntooooth', 'Svensson1', 'Takipoint123', 'Taweetham', 'Technical_13', 'The_New_Mikemoral', 'The_Photographer', 'The_Polish', 'The_Squirrel_Conspiracy', 'Thehelpfulone', 'Themeparkgc', 'Therud', 'TheSandDoctor', 'Thesupermat', 'Thorbjoern.Joerger', 'Timmyshin', 'Tippopotamus', 'Titodutta', 'Tiven2240', 'Tobyc75', 'Tokorokoko', 'TommyG', 'Tom_Morris', 'ToprakM', 'Torsch', 'Touzrimounir', 'Train2104', 'TreasuryTag', 'Trialpears', 'Trigenibinion', 'TUBS', 'TwinsMetsFan', 'Typ932', 'Ubcule', 'Uncitoyen', 'Uziel302', 'V-wolf' );
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...