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
set @enwiki_checkusers := "-revi,28bytes,AGK,Aaron_Schulz,Alex_Shih,Alison,Amalthea,Ambi,Anthere,Aoidh,Avraham,Azafred,BDD,BU_Rob13,Bahamut0013,Barkeep49,Barras,Base,Bastique,Bbb23,Beeblebrox,Bencmq,Berean_Hunter,Billinghurst,Bjweeks,Blablubbs,Blnguyen,Bradv,Brandon,Brian0918,Brion_VIBBER,Cabayi,Callanecc,CaptainEek,Carcharoth,Cary_Bass,Casliber,Chase_me_ladies,_I'm_the_Cavalry,Cool_Hand_Luke,Coren,Courcelles,DGG,Danny,Darkoneko,DatGuy,Datrio,David_Fuchs,David_Gerard,Dbl2010,DeltaQuad,Deskana,Dferg,Dmcdevit,DoRD,Dominic,Donald_Albury,Dougweller,Dreamy_Jazz,Drini,Drmies,EdJohnston,Einsbor,Elen_of_the_Roads,Elockid,Eloquence,Enterprisey,Erwin,Essjay,Euryalus,FT2,FayssalF,Ferret,Firefly,FloNight,Floquenbeam,Fr33kman,Frank,Fred_Bauder,Fritzpoll,Gamaliel,GeneralNotability,Girth_Summit,GorillaWarfare,Guerillero,HJ_Mitchell,Hasley,Hei_ber,Hersfold,Iridescent,Ivanvector,Izno,J.delanoy,JamesF,Jayjg,Jayvdb,Jclemens,Jdforrester,Jimbo_Wales,Joe_Decker,Joe_Roe,John_Vandenberg,Jon_Harald_Søby,Jpgordon,Jredmond,Keegan,Kelapstick,Kelly_Martin,Kirill_Lokshin,KnightLago,KrakatoaKatie,Krimpet,Ks0stm,Kylu,L235,LFaraone,Laaknor,Lar,Linedwell,Lucasbfr,Luk,Luna_Santin,MBisanz,Mackensen,Mailer_diablo,Mardetanha,Martin_Urbanec,Masti,Matanya,Materialscientist,Mathonius,Matiia,MaxSem,Maxim,Midom,Mike_V,Millosh,Mkdw,Moneytrees,Morven,MuZemike,MusikAnimal,Mykola7,Mz7,NativeForeigner,Newyorkbrad,NinjaRobotPirate,Nishkid64,NuclearWarfare,Opabinia_regalis,Oscar,Oshwah,Paginazero,Pathoschild,PhilKnight,Philippe,Ponyo,Premeditated_Chaos,Primefac,Pundit,Quentinv57,RadiX,Raul654,Rdsmith4,Reaper_Eternal,Rebecca,Redux,Richwales,RickinBaltimore,Risker,Rlevse,Roger_Davies,RoySmith,SQL,ST47,Salvio_giuliano,Sam_Korn,Sdrqaz,Seraphimblade,Shanel,Shanmugamp7,Shell_Kinney,Shizhao,SilkTork,SirFozzie,SoWhy,Sotiale,Spicy,Stephen_Bain,Steve_Smith,Stryn,Stwalkerster,Suisui,Superpes15,Tegel,Teles,Thatcher,The_Epopt,Thebainer,There'sNoTime,TheresNoTime,Thryduulf,Tim_Starling,Timotheus_Canens,Tiptoety,Tks4Fish,Tnxman307,ToBeFree,TonyBallioni,Trijnstel,Tznkai,UninvitedCompany,Vanamonde93,Vassyana,Versageek,Vituzzu,Voice_of_All,WilliamH,Wizardman,Worm_That_Turned,Wugapodes,Xeno,Yamla,Yann,YellowMonkey,Yunshui,Z1720,Zzuuzz,علاء"; /* from query/80721 */ select distinct log_title from logging_logindex where log_type = "block" and FIND_IN_SET(log_title, @enwiki_checkusers);
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...