Untitled query #88794

This query is marked as a draft This query has been published by CptViraj.
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 (
    '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', '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', 
    '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', 
    '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', 
    'আফতাবুজ্জামান', 'Александр_Сигачёв', 'АтаБот', 'Хомелка', 'Ɱ', 'ديفيد_عادل_وهبة_خليل_2', '烤麵包機' 
);
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.
SQL

Checking query status...
