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