Untitled query #11121

This query is marked as a draft This query has been published by Staeiou.
SQL

select page_title, rev_timestamp, user_name IN ("718 Bot", "AAlertBot", "AMbot", "APersonBot", "ARSBot", "AWeenieBot", "AccReqBot", "Acebot", "AdambroBot", "Addbot", "AdminStatsBot", "AilurophobiaBot", "Alaibot", "AlanBOT", "AlekseyBot", "AloysiusLiliusBot", "Alphachimpbot", "Amalthea (bot)", "AmeliorationBot", "AndreasJSbot", "AnkitAWB", "AnomieBOT", "AnomieBOT II", "AnomieBOT III", "Arbitrarily0Bot", "ArmbrustBot", "ArticlesForCreationBot", "AstRoBot", "AttributionBot", "AudeBot", "AvicBot", "AvicBot2", "B-bot", "BAGBot", "BD2412bot", "BG19bot", "BOTarate", "BOTijo", "BU RoBOT", "BattyBot", "BernsteinBot", "Bibcode Bot", "BogBot", "Bot1058", "Bot24", "BotMultichill", "BotMultichillT", "BotPuppet", "BracketBot", "BrokenAnchorBot", "BrownBot", "COIBot", "CactusBot", "CanisRufus", "CeraBot", "Cerabot~enwiki", "Chartbot", "CheMoBot", "CheckBot", "Chem-awb", "Chobot", "Chris G Bot", "Chris G Bot 3", "Chrisbot", "Citation bot", "Citation bot 1", "Citation bot 2", "Citation bot 3", "Citation bot 4", "CitationCleanerBot", "CleanupListingBot", "CloudNineBot", "ClueBot", "ClueBot II", "ClueBot III", "ClueBot IV", "ClueBot NG", "ClueBot VI", "CmdrObot", "Collabsearch", "Commander Keane bot", "CommonsDelinker", "CommonsNotification", "CommonsNotificationBot", "Community Tech bot", "ContinuityBot", "CorenSearchBot", "CountryBot", "CrazynasBot", "CwraschkeDataBot", "Cyberbot I", "Cyberbot II", "Cydebot", "D6", "DASHBotAV", "DPL bot", "DRN clerk bot", "DYKHousekeepingBot", "DYKUpdateBot", "DefconBot", "DeltaQuadBot", "Detroiterbot", "Dexbot", "DixonDBot", "DodoBot", "DpmukBOT", "DrTrigonBot", "DumbBOT", "DyceBot", "EarwigBot", "EberBot", "EmausBot", "EranBot", "ExpertIdeasBot", "FACBot", "FPBot", "FairuseBot", "FastilyBot", "FeedBot", "Femto Bot", "Filedelinkerbot", "FlBot", "Flow talk page manager", "Fluxbot", "FrescoBot", "GA bot", "Ganeshbot", "GimmeBot", "GrashoofdBot", "GurchBot", "H3llBot", "HBC AIV helperbot", "HBC AIV helperbot 8", "HBC AIV helperbot11", "HBC AIV helperbot2", "HBC AIV helperbot3", "HBC AIV helperbot4", "HBC AIV helperbot5", "HBC AIV helperbot7", "HBC Archive Indexerbot", "HBC NameWatcherBot", "Harej bot", "HasteurBot", "Hazard-Bot", "HersfoldArbClerkBot", "Hmainsbot1", "HostBot", "HotArticlesBot", "HtonlBot", "IPLRecordsUpdateBot", "Image Screening Bot", "Image-req-proj-bot", "ImageRemovalBot", "ImageTaggingBot", "InceptionBot", "InternetArchiveBot", "Italic title bot", "J Milburn Bot", "JAnDbot", "JBradley Bot", "JCbot", "JJMC89 bot", "JL-Bot", "JVbot", "JackieBot", "JamietwBot", "JarBot", "JatBot", "JeffGBot", "JhealdBot", "John of Reading Bot", "Josvebot", "KLBot2", "Kakashi Bot", "KaldariBot", "KasparBot", "KharBot", "KingpinBot", "KolBot", "Kotbot", "LaraBot", "LawBot", "Legobot", "Legobot II", "ListManBot", "ListeriaBot", "LivingBot", "Lonjers french region rename bot", "Lowercase sigmabot", "Lowercase sigmabot II", "Lowercase sigmabot III", "LuasÃ³g bot", "Lucasbfrbot", "Lucia Bot", "Luke081515Bot", "LyricsBot", "MBisanzBot", "MGA73bot", "MMABot", "MadmanBot", "Maintenance script", "Makecat-bot", "MandelBot", "Manishbot", "MartinBotIII", "MartinBot", "Mathbot", "Mdann52 IMG bot", "Mdann52 bot", "MedcabBot", "MediaWiki default", "MediaWiki message delivery", "MediationBot", "MenoBot", "MenoBot II", "Merge bot", "MerlLinkBot", "MessageDeliveryBot", "MessengerBot~enwiki", "MetaplasticityBot", "MifterBot", "MifterBot I", "MilHistBot", "MiszaBot", "Monkbot", "MoohanBOT", "MotinBot", "Mr.Z-bot", "MuZebot", "Muro Bot", "MusikBot", "NVS(bot)", "NationalRegisterBot", "NekoBot", "Nomenclaturebrowser", "NoomBot", "NukeBot", "OKBot", "OgreBot", "Ohms Law Bot", "One bot", "OpenlibraryBot", "OrphanBot", "Orphaned image deletion bot", "PC78-bot", "PDBbot", "PDFbot", "PeerReviewBot", "People-n-photo-bot", "People-photo-bot", "Petan-Bot", "Philosopher-Bot", "PhotoCatBot", "Portal box bot", "PotatoBot", "ProcseeBot", "Project Messenger Bot", "ProteinBoxBot", "QOTDBot", "RFC bot", "RFC posting script", "RM bot", "RMCD bot", "RagesossBot", "RaptureBot", "Reedy Bot", "ReferenceBot", "Reports bot", "Rfambot", "Rick Bot", "RileyBot", "RjwilmsiBot", "Rob110178bot", "Robert SkyBot", "RoboMaxCyberSem", "RockfangBot", "RscprinterBot", "RussBot", "Ryan Vesey Bot", "SD5bot", "SDPatrolBot", "SDPatrolBot II", "SPPatrolBot", "SandgemBot", "SatyrBot", "Scsbot", "SelectionBot", "SelketBot", "SeveroBot", "ShepBot", "Signpost Book Bot", "SineBot", "SkiersBot", "Smallbot", "Snotbot", "Snowbot", "SoxBot", "SoxBot II", "SoxBot V", "SoxBot VI", "SoxBot VII", "SpaceFactsBot", "SporkBot", "SprinterBot", "StatisticianBot", "Stefan2bot", "SteveBot", "Stwalkerbot", "SuggestBot", "SunCreatorBot", "SvickBOT", "TAP Bot", "TFA Protector Bot", "TPBot", "TTObot", "TedderBot", "Thadius856AWB", "The Anomebot2", "The Anonybot", "The wubbot", "Thehelpfulbot", "TowBot", "Town-bot", "UcuchaBot", "UnCatBot", "VIAFbot", "VWBot", "VeblenBot", "VoABot", "VoxelBot", "WASDbot", "WMUKBot", "WP 1.0 bot", "WaldirBot", "WalkingSoulBot", "WebCiteBOT", "WelcomerBot", "Werdnabot", "WikiProject Notification Service", "WikiStatsBOT", "Wikinews Importer Bot", "Wikipedia Signpost", "WildBot", "WolfBot", "WoodwardBot", "Wpp research bot", "WxBot", "XLerateBot", "Xqbot", "XyBot", "YiFeiBot", "Yobot", "YpnBot")

from page
join revision on rev_page = page_id 
join user on rev_user = user_id 
where page_namespace = 4

limit 10;
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...
