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
Stalaga
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT DISTINCT user_id, user_name, user_registration, user_editcount FROM user LEFT JOIN user_groups ON user.user_id = user_groups.ug_user WHERE user_editcount >= 100 AND (ug_group != "bot" OR ug_group IS NULL) AND user_id IN ( SELECT rc_user FROM recentchanges ) AND ( user_name = ".anacondabot" OR user_name = "28bot" OR user_name = "A4bot" OR user_name = "AFD Bot" OR user_name = "AP.BOT" OR user_name = "ARSBot" OR user_name = "AWeenieBot" OR user_name = "AccReqBot" OR user_name = "AdambroBot" OR user_name = "AfDBot" OR user_name = "AilurophobiaBot" OR user_name = "AkhtaBot" OR user_name = "Aksibot" OR user_name = "Alaibot" OR user_name = "AlanBOT" OR user_name = "AlekseyBot" OR user_name = "AlexNewArtBot" OR user_name = "Alexbot" OR user_name = "AlleborgoBot" OR user_name = "Almabot" OR user_name = "AlnoktaBOT" OR user_name = "AloysiusLiliusBot" OR user_name = "Alph Bot" OR user_name = "Alphachimpbot" OR user_name = "AlptaBot" OR user_name = "AmeliorationBot" OR user_name = "Amirobot" OR user_name = "Anchor Link Bot" OR user_name = "AndersBot" OR user_name = "Andrea105Bot" OR user_name = "Android Mouse Bot" OR user_name = "Android Mouse Bot 2" OR user_name = "Android Mouse Bot 3" OR user_name = "Android Mouse Bot 4" OR user_name = "AntiAbuseBot" OR user_name = "AntiSpamBot" OR user_name = "AntiVandalBot" OR user_name = "Antischmitzbot" OR user_name = "Anybot" OR user_name = "ArbComBot" OR user_name = "ArkyBot" OR user_name = "ArthurBot" OR user_name = "ArticleAlertbot" OR user_name = "AstRoBot" OR user_name = "AvicBot2" OR user_name = "AvocatoBot" OR user_name = "BAGBot" OR user_name = "BHGbot" OR user_name = "BJBot" OR user_name = "BOT-Superzerocool" OR user_name = "BenjBot" OR user_name = "BenzolBot" OR user_name = "BetacommandBot" OR user_name = "Bluebot" OR user_name = "BodhisattvaBot" OR user_name = "BorgardeBot" OR user_name = "BoricuaBot" OR user_name = "Bot0612" OR user_name = "BotCompuGeek" OR user_name = "BotKung" OR user_name = "Bota47" OR user_name = "BotanyBot" OR user_name = "Botx" OR user_name = "Broadbot" OR user_name = "BrokenAnchorBot" OR user_name = "BryanBot" OR user_name = "Byrialbot" OR user_name = "COBot" OR user_name = "CSDWarnBot" OR user_name = "CapitalBot" OR user_name = "CarsracBot" OR user_name = "Chlewbot" OR user_name = "Chris G Bot 3" OR user_name = "Chrisbot" OR user_name = "ChuispastonBot" OR user_name = "ChzzBot IV" OR user_name = "ChzzBot II" OR user_name = "CleanupListingBot" OR user_name = "CloudNineBot" OR user_name = "ClueBot" OR user_name = "ClueBot Commons" OR user_name = "ClueBot IV" OR user_name = "ClueBot NG" OR user_name = "ClueBot VI" OR user_name = "CobraBot" OR user_name = "CocuBot" OR user_name = "Collabsearch" OR user_name = "Commander Keane bot" OR user_name = "Commons fair use upload bot (usurped)" OR user_name = "CommonsNotificationBot" OR user_name = "CopyToWiktionaryBot" OR user_name = "CounterVandalismBot" OR user_name = "CrimsonBot" OR user_name = "Crypticbot" OR user_name = "Curpsbot-unicodify" OR user_name = "CwraschkeDataBot" OR user_name = "D'ohBot" OR user_name = "D6" OR user_name = "DASHBot" OR user_name = "DFBot" OR user_name = "DHN-bot" OR user_name = "DHN-bot~enwiki" OR user_name = "DOI bot" OR user_name = "DSisyphBot" OR user_name = "DYKadminBot" OR user_name = "Danumber1bot" OR user_name = "DarafshBot" OR user_name = "Darkicebot" OR user_name = "DarknessBot" OR user_name = "DavidWSBot" OR user_name = "DeadBot" OR user_name = "DefaultsortBot" OR user_name = "Dexbot" OR user_name = "Diligent Terrier Bot" OR user_name = "Dinamik-bot" OR user_name = "DinoBot" OR user_name = "DinoBot2" OR user_name = "DinoSizedBot" OR user_name = "DodoBot" OR user_name = "DomBot" OR user_name = "DorganBot" OR user_name = "DragonBot" OR user_name = "DrilBot" OR user_name = "Drinibot" OR user_name = "DumZiBoT" OR user_name = "DyceBot" OR user_name = "EBot IV" OR user_name = "ENewsBot" OR user_name = "EagleAstroidBot" OR user_name = "EarwigBot I" OR user_name = "EarwigBot III" OR user_name = "Ebrambot" OR user_name = "EddieBot" OR user_name = "EdoBot" OR user_name = "EdwardsBot" OR user_name = "El bot de la dieta" OR user_name = "EmxBot" OR user_name = "Erik9bot" OR user_name = "Erwin85Bot" OR user_name = "Escarbot" OR user_name = "Eskimbot" OR user_name = "EssjayBot" OR user_name = "Estirabot" OR user_name = "Eubot" OR user_name = "Fbot" OR user_name = "Femto Bot" OR user_name = "Fettgesicht" OR user_name = "FileBot" OR user_name = "FlBot" OR user_name = "FlaBot" OR user_name = "FlagBot" OR user_name = "FoxBot" OR user_name = "Full-date unlinking bot" OR user_name = "GA bot" OR user_name = "GargoyleBot" OR user_name = "Gdrbot" OR user_name = "GeorgeMoneyBot-status" OR user_name = "Gerakibot" OR user_name = "Giggabot" OR user_name = "Gnome (Bot)" OR user_name = "Grafikbot" OR user_name = "GrinBot" OR user_name = "GrinBot~enwiki" OR user_name = "GrouchoBot" OR user_name = "Guanabot" OR user_name = "GurchBot" OR user_name = "HBC AIV helperbot" OR user_name = "HBC AIV helperbot 8" OR user_name = "HBC AIV helperbot2" OR user_name = "HBC AIV helperbot4" OR user_name = "HBC AIV helperbot7" OR user_name = "HBC NameWatcherBot" OR user_name = "HMBot" OR user_name = "HRoestBot" OR user_name = "HagermanBot" OR user_name = "Helpful Pixie Bot" OR user_name = "HerculeBot" OR user_name = "HersfoldArbClerkBot" OR user_name = "HiW-Bot" OR user_name = "HotArticlesBot" OR user_name = "IPLRecordsUpdateBot" OR user_name = "Idioma-bot" OR user_name = "IluvatarBot" OR user_name = "Image Screening Bot" OR user_name = "ImageBacklogBot" OR user_name = "Invadibot" OR user_name = "JYBot" OR user_name = "JaGaBot" OR user_name = "JatBot" OR user_name = "JdforresterBot" OR user_name = "JhsBot" OR user_name = "Jitse's bot" OR user_name = "JoeBot" OR user_name = "Jogersbot" OR user_name = "John Bot" OR user_name = "John Bot III" OR user_name = "Jotterbot" OR user_name = "Justincheng12345-bot" OR user_name = "KaiserbBot" OR user_name = "Kakashi Bot" OR user_name = "KamikazeBot" OR user_name = "KarlsenBot" OR user_name = "Kasirbot" OR user_name = "Kbdankbot" OR user_name = "KevinBot" OR user_name = "KevinalewisBot" OR user_name = "KharBot" OR user_name = "Kingbotk" OR user_name = "KittyBot" OR user_name = "KnightRider" OR user_name = "KocjoBot~enwiki" OR user_name = "KolBot" OR user_name = "Kotbot" OR user_name = "KrimpBot" OR user_name = "KslotteBot" OR user_name = "KuduBot" OR user_name = "Kumi-Taskbot" OR user_name = "Kyle the bot" OR user_name = "LaaknorBot" OR user_name = "LatitudeBot" OR user_name = "LawBot" OR user_name = "Legobot III" OR user_name = "Lightbot" OR user_name = "Ligulembot" OR user_name = "LinkFA-Bot" OR user_name = "ListasBot" OR user_name = "Locobot" OR user_name = "LordAnubisBOT" OR user_name = "LostBot" OR user_name = "Louperibot" OR user_name = "LucienBOT" OR user_name = "Luckas-bot" OR user_name = "LyricsBot" OR user_name = "MMABot" OR user_name = "MPUploadBot" OR user_name = "MSBOT" OR user_name = "MTSbot" OR user_name = "Maelgwnbot" OR user_name = "Mairibot" OR user_name = "Maksim-bot" OR user_name = "MalafayaBot" OR user_name = "Margosbot" OR user_name = "Margosbot~enwiki" OR user_name = "MarshBot" OR user_name = "MartinBot" OR user_name = "MartinBotIII" OR user_name = "MastiBot" OR user_name = "MauchoBot" OR user_name = "MauritsBot" OR user_name = "McM.bot" OR user_name = "MelonBot" OR user_name = "MenasimBot" OR user_name = "Mentibot" OR user_name = "MerlIwBot" OR user_name = "MessageDeliveryBot" OR user_name = "MessengerBot~enwiki" OR user_name = "MetaplasticityBot" OR user_name = "MetsBot" OR user_name = "Milk's Favorite Bot II" OR user_name = "MiszaBot" OR user_name = "MiszaBot I" OR user_name = "MiszaBot II" OR user_name = "MiszaBot III" OR user_name = "Mjbmrbot" OR user_name = "MondalorBot" OR user_name = "Mulder416sBot" OR user_name = "Muro Bot" OR user_name = "MystBot" OR user_name = "NTBot" OR user_name = "NVS(bot)" OR user_name = "NW557Bot" OR user_name = "Nallimbot" OR user_name = "NedBot" OR user_name = "NeraBot" OR user_name = "NetBot" OR user_name = "NjardarBot" OR user_name = "Nobot" OR user_name = "NolBot" OR user_name = "Nomenclaturebrowser" OR user_name = "Nono le petit robot" OR user_name = "NoomBot" OR user_name = "NrhpBot" OR user_name = "Numbo3-bot" OR user_name = "Obersachsebot" OR user_name = "One bot" OR user_name = "OpenlibraryBot" OR user_name = "Ops Monitor (WMF)" OR user_name = "OrBot" OR user_name = "OrphanBot" OR user_name = "Orphaned image deletion bot" OR user_name = "OverlordQBot" OR user_name = "PALZ9000" OR user_name = "PC78-bot" OR user_name = "PDBbot" OR user_name = "PNG crusade bot" OR user_name = "Pageview bot" OR user_name = "PbBot" OR user_name = "Pearle" OR user_name = "Peelbot" OR user_name = "Pegasusbot" OR user_name = "Peti610botH" OR user_name = "Phe-bot" OR user_name = "PipepBot" OR user_name = "PixelBot" OR user_name = "PlangeBot" OR user_name = "Pokbot" OR user_name = "Polbot" OR user_name = "Project Messenger Bot" OR user_name = "PseudoBot" OR user_name = "PsychAWB" OR user_name = "Ptbotgourou" OR user_name = "RBot" OR user_name = "RBot~enwiki" OR user_name = "RFC bot" OR user_name = "RFC posting script" OR user_name = "Ralbot" OR user_name = "Rambot" OR user_name = "RaptureBot" OR user_name = "RebelRobot" OR user_name = "RedBot" OR user_name = "Redirect fixer" OR user_name = "RefDeskBot" OR user_name = "Rei-bot" OR user_name = "Rezabot" OR user_name = "Rfambot" OR user_name = "RibotBOT" OR user_name = "Riccardobot" OR user_name = "Ripchip Bot" OR user_name = "Rob110178bot" OR user_name = "Robbot" OR user_name = "RobotE" OR user_name = "RobotG" OR user_name = "Roboto de Ajvol" OR user_name = "RonaldBot" OR user_name = "RoryBot" OR user_name = "RotlinkBot" OR user_name = "Rschen7754bot" OR user_name = "Rubinbot" OR user_name = "SEWilcoBot" OR user_name = "SPCUClerkbot" OR user_name = "SQLBot" OR user_name = "SQLBot-Hello" OR user_name = "STBot" OR user_name = "STBotD" OR user_name = "STBotI" OR user_name = "STTWbot" OR user_name = "Sagabot" OR user_name = "SamatBot" OR user_name = "Sambot" OR user_name = "Sandbot" OR user_name = "SandgemBot" OR user_name = "SashatoBot" OR user_name = "SassoBot" OR user_name = "Scepbot" OR user_name = "Seedbot" OR user_name = "SelectionBot" OR user_name = "SelketBot" OR user_name = "Selmobot" OR user_name = "Sethbot" OR user_name = "Sgeo-BOT" OR user_name = "Shadowbot3" OR user_name = "SharedIPArchiveBot" OR user_name = "ShepBot" OR user_name = "SieBot" OR user_name = "Signpost Book Bot" OR user_name = "SilvonenBot" OR user_name = "SkiersBot" OR user_name = "SlakrBot" OR user_name = "SmackBot" OR user_name = "Smallbot" OR user_name = "SoxBot" OR user_name = "SoxBot II" OR user_name = "SoxBot III" OR user_name = "SoxBot IV" OR user_name = "SoxBot V" OR user_name = "SoxBot VI" OR user_name = "SoxBot VII" OR user_name = "SpBot" OR user_name = "SpebiBot" OR user_name = "SpellCheckerBot" OR user_name = "SpellingBot" OR user_name = "Staeckerbot" OR user_name = "StatsBot" OR user_name = "StatusBot" OR user_name = "SteenthIWbot" OR user_name = "StigBot" OR user_name = "Sumibot" OR user_name = "SunCreatorBot" OR user_name = "Svenbot" OR user_name = "Synthebot" OR user_name = "Syrcatbot" OR user_name = "T13bot" OR user_name = "TPO-bot" OR user_name = "TXiKiBoT" OR user_name = "TaBOT-zerem" OR user_name = "TaeBot" OR user_name = "Tangobot" OR user_name = "Tawkerbot" OR user_name = "Tawkerbot2" OR user_name = "Tawkerbot4" OR user_name = "Taxobot" OR user_name = "Taxobot (usurped)" OR user_name = "Taxobot 1" OR user_name = "Taxobot 2" OR user_name = "Taxobot 3" OR user_name = "Taxobot 6" OR user_name = "Taxobot 7" OR user_name = "TechBot" OR user_name = "ThePhantomBot" OR user_name = "Thijs!bot" OR user_name = "TinucherianBot" OR user_name = "TjBot" OR user_name = "TobeBot" OR user_name = "Town-bot" OR user_name = "Tsca.bot" OR user_name = "TuHan-Bot" OR user_name = "Ugur Basak Bot" OR user_name = "UnCatBot" OR user_name = "Uncle G's 'bot" OR user_name = "Uncle G's major work 'bot" OR user_name = "VVVBot" OR user_name = "Vagobot" OR user_name = "VedeBOT" OR user_name = "VeinorBot" OR user_name = "Vina-iwbot" OR user_name = "Vina-iwbot~enwiki" OR user_name = "VixDaemonBot" OR user_name = "VoABot II" OR user_name = "VolkovBot" OR user_name = "VsBot" OR user_name = "WASDbot" OR user_name = "WMUKBot" OR user_name = "WPArkansas Bot" OR user_name = "WalkingSoulBot" OR user_name = "WatchlistBot" OR user_name = "WeggeBot" OR user_name = "Werdnabot" OR user_name = "Wherebot" OR user_name = "Whobot" OR user_name = "WikiDreamer Bot" OR user_name = "WikiStatsBOT" OR user_name = "Wikinews Importer Bot" OR user_name = "WikitanvirBot" OR user_name = "WinBot" OR user_name = "WolfBot" OR user_name = "Wpp research bot" OR user_name = "XLerateBot" OR user_name = "XLinkBot" OR user_name = "Xenobot" OR user_name = "Xenobot Mk V" OR user_name = "Xqbot" OR user_name = "XyBot" OR user_name = "YFdyh-bot" OR user_name = "YonaBot" OR user_name = "YpnBot" OR user_name = "YurikBot" OR user_name = "ZhBot" OR user_name = "Zorglbot" OR user_name = "Zorrobot" OR user_name = "ZsinjBot" OR user_name = "Zwobot" OR user_name = "ZéroBot" OR user_name = "^demonBot2" OR user_name = "Δbot" );
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...