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 IS ( '1234qwer1234qwer4', '0x010C', '4ing', '511KeV', 'A1', 'Abhijitsathe', 'Abisys', 'Achates', 'Adamant1', 'Afrank99bot', 'Agathoclea', 'Ahecht', 'Alan_Liefting', 'Aldnonymous', 'Alex_Spade', 'Alex_brollo', 'Alex_Noble', 'AndreasPraefcke', 'Andyzweb', 'AnemoneProjectors', 'Angusmclellan', 'Anonimski', 'AntonierCH', 'Anythingyouwant', 'Apocheir', 'Araisyohei', 'Armbrust', 'Arsonal', 'Artem_Korzhimanov', 'Aron_Manning', 'Arthena', 'Arthur_Rubin', 'Aschroet', 'Askeuhd', 'Auntof6', 'Averater', 'Avicennasis', 'Avocato', 'Baidax', 'Balajijagadesh', 'BaldBoris', 'BD2412', 'Belbury', 'Beleg_Tâl', 'Bellayet', 'Benchill', 'Bennv3771', 'Bff', 'Bigdelboy', 'Bioneer1', 'Bitmapped', 'Black_Falcon', 'Bluemask', 'Bomazi', 'Brackenheim', 'Brainulator9', 'Bricktop', 'Brightgalrs', 'Brochon99', 'BrokenSphere', 'Bryan', 'BU_Rob13', 'BureibuNeko', 'Capmo', 'CAPTAIN_RAJU', 'Carn', 'CD', 'Celina_Strzelecka_(WMPL)', 'CennoxX', 'Chandres', 'Chase_me_ladies,_I\'m_the_Cavalry', 'Checkingfax', 'Cherkash', 'Chowbok', 'Chzz', 'Ciaurlec', 'Cnbrb', 'Codrinb', 'Coekon', 'CoolCanuck', 'CptViraj', 'Cpt.a.haddock', 'Croquant', 'CT_Cooper', 'Curlyrnd', 'Cwbm_(commons)', 'Cycn', 'Dainomite', 'Dan_Koehl', 'Danmichaelo', 'DannyS712', 'Darafsh', 'Darklanlan', 'Darkwind', 'Darwinek', 'DatGuy', 'Davykamanzi', 'Denis_Apel', 'Diaa_abdelmoneim', 'Diego_Grez-Cañete', 'Dim_Grits', 'Diwas', 'Djsasso', 'Docu', 'Dogears', 'Dominic', 'Drilnoth', 'Drogosław', 'Droll', 'Dual_Freq', 'Duja', 'Ebyabe', 'EdoAug', 'Екатерина_Борисова', 'Electron', 'Elvey', 'Emptywords', 'Epbr123', 'Epicgenius', 'Erutuon', 'Estopedist1', 'Estopedist1forAWB', 'EvilFreD', 'Evrik', 'FalconL', 'FDMS4', 'Figure19', 'Find_bruce', 'Firsfron', 'Firilacroco', 'Flickerd', 'Flor!an', 'Fl.schmitt', 'Fluffy89502', 'FRacco', 'Fredddie', 'Frood', 'Frozeficent', 'Fructibot', 'Funandtrvl', 'Gaeser', 'Gamaliel', 'GAndy', 'Ganeshk', 'Gazoth', 'Gdgourou', 'GeorgHH', 'Geraki', 'Gikü', 'GiW', 'GoEThe', 'Gonnym', 'Grey_Wanderer', 'Grybukas', 'GualdimG', 'Guerillero', 'Gunnar.offel', 'GVarnum-WMF', 'Hagar66', 'Ham', 'Hasenläufer', 'Haus', 'Hike395', 'Hmains', 'Hoverfish', 'Hsuepfle', 'Htonl', 'HueMan1', 'IagoQnsi', 'Ibadibam', 'IJohnKennady', 'Iketsi', 'Imzadi1979', 'Info-farmer', 'Infovarius', 'Insider', 'Intforce', 'Ixocactus', 'Ipankonin', 'Irate', 'Ivi104', 'IviBot', 'Iwaqarhashmi', 'JPxG', 'Jabbi', 'Jackaranga', 'Jagro', 'Jahobr', 'Jake_Wartenberg', 'Jakob.scholbach', 'Jalexander', 'Janbery', 'Jane023', 'Jarry1250', 'Jayantanth', 'Jbribeiro1', 'Jc86035', 'JeanBono', 'Jeanenawhitney1', 'Jeff_G.', 'Jerome_Charles_Potts', 'Jheald', 'Jim_Carter', 'JJ_Harrison', 'Joey-das-WBF', 'John_Andersson_(WMSE)', 'JoKalliauer2', 'Jon_Kolbert', 'Jonteemil', 'JotaCartas', 'Jwillbur', 'Jürgen_Krause', 'Kaganer', 'Katarighe', 'Kcx36', 'KCVelaga', 'Kerry_Raymond', 'Kevin_Payravi', 'Kiran_Gopi', 'Knua', 'Koavf', 'Kognos', 'Kozuch', 'KTC', 'Kurmanbek', 'Kwamikagami', 'Kwj2772_(tester)', 'Kyykaarme', 'LamBoet', 'Lavallen', 'LD', 'LeastCommonAncestor', 'Leppus', 'Letartean', 'Lexein', 'LeZibou', 'Liesel', 'Liridon', 'Locpac', 'Llywelyn2000', 'LZ6387', 'M.casanova', 'Mabdul', 'MaGa', 'Maggot666PL', 'Mahanga', 'Maikking', 'Makecat', 'Maliepa', 'Mariluna', 'Martin_Urbanec', 'MartinPoulter', 'Mary_Mark_Ockerbloom', 'MaxxL', 'Mdaniels5757', 'Mdann52', 'MdsShakil', 'Meghmollar2017', 'Melos', 'Mich.kramer', 'Mifter', 'Mikael_Häggström', 'Mikey641', 'Milliped', 'MJL', 'Moe_Epsilon', 'Mohamed_Ouda', 'MoondyneAWB', 'Moralist', 'Morgankevinj_AWB', 'Morgoth666', 'Morray', 'Mr_Accountable', 'MrBill3', 'Mr.Z-man', 'Mussklprozz', 'Nachcommonsverschieber', 'Nachosan', 'Nadzik', 'Naraht', 'Nard_the_Bard', 'Nasko', 'Natl1', 'NE2', 'Nehaoua', 'NeilK', 'Neriah', 'Neurolysis', 'Neveselbert_(mobile)', 'NewtonCourt', 'Nillerdk', 'Niteshift', 'Noodle_snacks', 'Nthep', 'Nux', 'Obayd', 'Odie5533', 'Olivier_LPB', 'Omar_Ghrida', 'Omnedon', 'Oosoom', 'Orderinchaos', 'Orderinchaos_2', 'OsamaK', 'OSX', 'Paul_012', 'Pbm', 'Pbrks', 'Peacearth', 'Peteforsyth', 'PeterFisk', 'Perumalism', 'PF95-SAuto', 'Pharos', 'Philosopher', 'Phoenix-wiki', 'Pietro', 'Pkbwcgs', 'Plozessor', 'PolarBot', 'Pompidom', 'Poulpy', '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' );
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...