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 page_id, page_title, page_namespace FROM page LEFT JOIN revision ON rev_page = page_id AND page_namespace = 0 AND rev_user IN ( SELECT user_id FROM user LEFT JOIN user_groups ON user_id = ug_user AND user_editcount IS NOT NULL AND user_editcount >= 100 AND (ug_group != "bot" OR ug_group IS NULL) 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" INNER JOIN recentchanges ON user_id = rc_user );
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...