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
EGalvez (WMF)
.
Toggle Highlighting
SQL
SELECT page_title, Rev1.`rev_len` as NewRev, Rev2.`rev_len` as OldRev from enwiki_p.revision as Rev1 JOIN enwiki_p.`revision` as Rev2 on Rev2.rev_id = Rev1.rev_parent_id JOIN enwiki_p.page AS p on `page_id` = Rev1.rev_page WHERE page_title IN ( "1804_Antigua–Charleston_hurricane", "1806_Great_Coastal_hurricane", "1815_North_Carolina_hurricane", "1858_Atlantic_hurricane_season", "1917_Atlantic_hurricane_season", "1958_Asian_Games", "1958_Asian_Games_medal_table", "1978_Atlantic_hurricane_season", "1990–91_South-West_Indian_Ocean_cyclone_season", "1992_Cape_Mendocino_earthquakes", "1997–98_South-West_Indian_Ocean_cyclone_season", "2000_CECAFA_Cup", "2000–01_South-West_Indian_Ocean_cyclone_season", "2001_CECAFA_Cup", "2003_North_Indian_Ocean_cyclone_season", "2003_Sri_Lanka_cyclone", "2013_Penn_State_Nittany_Lions_football_team", "2014_Belmont_Stakes", "2014_Lamu_attacks", "2014_National_League_Wild_Card_Game", "2014_South_African_platinum_strike", "7:15_A.M.", "Aasa_Helgesen", "Acacia_cultriformis", "Acacia_pycnantha", "Action_Button_Entertainment", "Adam_Peaty", "Adenomus_kelaartii", "Admiral_Spiridov-class_monitor", "Adriana_Hoffmann", "Afghan_pika", "African_giant_toad", "Agnes_Abuom", "Al-Jarrah_ibn_Abdallah", "Al-Risalah_al-Dhahabiah", "Alejandro_Villanueva_(American_football)", "Alex_Rae_(rugby_union)", "Alexei_Cherepanov", "Alnus_glutinosa", "Ambrosi''s_cave_salamander", "Amietophrynus_vittatus", "Ancient_Trader", "Andrea_Cambini", "Angola_Avante", "Anna_Maria_Rückerschöld", "Anthony_Hewitt_(baseball)", "Apple_Pay", "April_2014_lunar_eclipse", "Art_Sherman", "Australian_raven", "Bad_Elk_v._United_States", "Balkan_whip_snake", "Baseball''s_Sad_Lexicon", "Be_More_(Adventure_Time)", "Begum_Akhtar_Riazuddin", "Ben_Wetzler", "Benevolent_and_Protective_Order_of_Elks_Lodge_(Montrose,_Colorado)", "Berkshire_No._7", "Bird_migration", "Black_jackrabbit", "Black_Rock_Harbor_Light", "Black_wildebeest", "Blek", "Blow_(Beyoncé_Knowles_song)", "Blue_wildebeest", "BNP_Paribas", "Bob_Mariano_(executive)", "Body_Language_(Kylie_Minogue_album)", "Bogotá_Women''s_Race", "Brian_McGrattan", "Burmese_hare", "Cabot''s_tragopan", "Caelum", "California_Chrome", "Canadian_Platinum_Maple_Leaf", "Canidae", "Cape_starling", "Carli_Lloyd", "Carlos_Ruiz_(baseball)", "Carpathian_newt", "Cars_(film)", "Charles_M._Williams_(American_academic)", "Cheddar_Palace", "Chinese_goral", "Chocolate_(Kylie_Minogue_song)", "Cody_Asche", "Cody_Ross", "Crawl_(video_game)", "Cruachan_Power_Station", "Cumberland_Island_horse", "Cuphead", "Cuvier''s_dwarf_caiman", "Cyclone_Bejisa", "Cyclone_Winifred", "Davies''_tree_frog", "Deimatic_behaviour", "Derrick_Gordon", "Development_of_Deus_Ex", "Development_of_Fez", "Development_of_L.A._Noire", "Development_of_Mother_3", "Divergence_(Star_Trek:_Enterprise)", "Drunk_in_Love", "Dutch_brick", "EarthBound_fandom", "Eastern_green_mamba", "Edgar_Quinet-class_cruiser", "Edinburgh_International_Climbing_Arena", "Edward_II_of_England", "El_Norte_de_Castilla", "Elizabeth_Campbell,_Duchess_of_Argyll", "Elmer_S._Dailey", "Enter_the_Dominatrix", "Epacris_impressa", "Ernest_Radcliffe_Bond", "Escape_from_Woomera", "Eurasian_eagle-owl", "Evan_Gattis", "Fabien_Cousteau", "Fairey_Spearfish", "Fairy_lorikeet", "Fan_Lau_Fort", "Fernanda_Lima", "Fez_(video_game)", "Fiery-shouldered_parakeet", "Filipinos_in_Belgium", "Finnieston_Crane", "Fire_and_Darkness", "Flag_of_Gabon", "Flag_of_Saint_Lucia", "Flotilla_(video_game)", "Forest_cobra", "Fort_Srebrna_Góra", "Frank_Facer", "Freedom_Planet", "French_cruiser_Amiral_Charner", "French_cruiser_Chanzy", "French_cruiser_Edgar_Quinet", "French_cruiser_Waldeck-Rousseau", "French_Riviera_Marathon", "Fulvous_harvest_mouse", "Gaga_(genus)", "Gasketball", "Genesis_(2005)", "Geologic_map_of_Georgia", "German_destroyer_Z14_Friedrich_Ihn", "German_destroyer_Z15_Erich_Steinbrinck", "Géza_I_of_Hungary", "Girl_(Destiny''s_Child_song)", "Glarentza", "Glik_v._Cunniffe", "Grapevine,_Texas", "Gray-collared_chipmunk", "Great_Captain_Island", "Greater_long-tailed_shrew_tenrec", "Greek_rock_lizard", "Greg_Wohlwend", "Grevillea_juniperina", "Gulf_Coast_kangaroo_rat", "Hank_(dog)", "Hanpu", "Harriet_Leveson-Gower,_Countess_Granville", "Heck_horse", "Helen_C._White", "Henriette_Schønberg_Erken", "Henry_Alexander_Stuart-Menteth", "Henry_du_Pont", "Hestercombe_House", "Hilda_Vaughan", "Hillforts_in_Scotland", "Himalayan_pika", "His_Last_Vow", "Historical_coats_of_arms_of_the_U.S._states_from_1876", "HMS_Formidable_(67)", "Hohokum", "Holy_Rosary_Cathedral_(Vancouver)", "Horn_OK_Please_(song)", "House_at_130_Mohegan_Avenue", "Humpback_smooth-hound", "Hundreds_(video_game)", "Hurricane_Manuel", "Hurricane_Nate_(2011)", "Hurricane_Paul_(2012)", "I_Don''t_Give_A", "Ian_Smith_(Scottish_rugby_player_born_1903)", "Iftah_Ya_Simsim", "Ignacy_Skorupka", "Isopoda", "Italian_cave_salamander", "Italian_cruiser_Calabria", "Italian_pool_frog", "Jan_Zamoyski", "Japanese_common_toad", "Japanese_ironclad_Fusō", "Javier_Báez", "Johann_Erich_Thunmann", "John_Baker_White_(Virginia)", "Johnny_Leach", "Jonathan_Pettibone", "Jumping_Flash!_2", "Kazanie_Skargi", "Keeper_of_the_Flame_(film)", "Kevin_Durant", "Killing_Is_My_Business..._and_Business_Is_Good!", "King_Alfred''s_Tower", "King_Charles''s_Castle", "King_John''s_Hunting_Lodge,_Axbridge", "Kingstonian_F.C.", "Kirtlandian", "Ko_e_Iki_he_Lagi", "Kyle_Kendrick", "Lady_Augusta_Gordon", "Lady_Gaga_Live_at_Roseland_Ballroom", "Lågskär", "Lake_Chillisquaque", "Least_weasel", "Lined_pocket_mouse", "Lipizzan", "List_of_Chocobo_media", "List_of_English_Heritage_properties_in_Somerset", "List_of_National_Football_League_season_receiving_yards_leaders", "List_of_National_Natural_Landmarks_in_Colorado", "List_of_Pakistan_women_ODI_cricketers", "List_of_Pakistan_women_Twenty20_International_cricketers", "List_of_songs_recorded_by_Marina_and_the_Diamonds", "Little_desert_pocket_mouse", "Little_Sumba_hawk-owl", "Lizard_catshark", "Lomatia_arborescens", "Lomatia_fraseri", "Long-tailed_marmot", "Macroscelides_micus", "Mahmona_Khan", "Malacostraca", "Malcolm''s_Ethiopian_toad", "Mallica_Reynolds", "Mannargudi", "Marcus_Lindblom", "María_Josefa_Mujía", "Maria_Komissarova", "Marie_Simonsen", "Mario_Hollands", "Marte_Wexelsen_Goksøyr", "Martin_AM_Mauler", "Mary_Ellen_Best", "Mat_Latos", "Megan_Fletcher", "Merriam''s_pocket_mouse", "Michoacan_pocket_gopher", "Mikengreg", "Millie_Knight", "Minyobates_steyermarki", "Mirrors_(Natalia_Kills_song)", "Mission_31", "Monsters_Ate_My_Birthday_Cake", "Monument_to_the_Fallen_and_Murdered_in_the_East", "Monument_Valley_(video_game)", "Mother_(video_game)", "Mother_3", "Mother_3_fan_translation", "Mountain_parakeet", "Mullum_Malarum", "Musca", "My_Lord_John", "Myotis_moluccarum", "Narrow-headed_vole", "Narrow-skulled_pocket_mouse", "Nasal_strip", "Nasreddin_Murat-Khan", "National_Dairy_Goat_Awareness_Week", "Nelson''s_kangaroo_rat", "Nelson''s_pocket_mouse", "New_England_tree_frog", "New_York_State_Route_370", "Nidhogg_(video_game)", "Nile_Delta_toad", "Nonius_horse", "Olive-backed_pocket_mouse", "Ontario_Highway_19", "Parental_Advisory", "Patrick_Allen_(Governor-General)", "Paul_Palaiologos_Tagaris", "Peruvian_thick-knee", "Phil_Fish", "Pictor", "Pike-Pawnee_Village_Site", "Pilot_(Lost)", "Podarcis_carbonelli", "Podarcis_hispanica", "Pointy_ears", "Pokémon_Channel", "Por_Debajo_de_la_Mesa", "Poultry", "Princess_Marie_Amelie_of_Baden", "Priscilla_Dailey", "Purvis_Short", "Puzzlejuice", "Pyramid_of_Capitalist_System", "Pyrenean_frog", "Queen_(soundtrack)", "Radish", "Ratac_Abbey", "Red_Blooded_Woman", "Red_whip_snake", "Red-tailed_chipmunk", "Reed_vole", "Regioni-class_cruiser", "Resogun", "Ridiculous_Fishing", "Rodent", "Roseland_Theater", "Russian_battleship_Pobeda", "Russian_monitor_Charodeika", "Russian_monitor_Latnik", "Russian_monitor_Lava", "Rymdkapsel", "Saints_Row:_The_Third_downloadable_content", "Sam_Manekshaw", "SAS_(software)", "Saurolophus_angustirostris", "Scott_Wagner", "Seal_of_Niue", "Secrets_of_Rætikon", "Sega_CD", "Seiken_Densetsu_3", "Sesame_Street_international_co-productions", "Seth_Blair", "Seumas_McNally_Grand_Prize", "Shark:_Mind_of_a_Demon", "Sharp-snouted_rock_lizard", "Sicilian_wall_lizard", "Silver_certificate_(Cuba)", "Sinclair_Executive", "Sinclair_Sovereign", "Sinoceratops", "Small_dorcopsis", "SMS_(Bangerz)", "Sneak_King", "Solar_2", "Solipskier", "Solsbury_Hill", "Someone_Else_(Miley_Cyrus_song)", "Sonoran_green_toad", "Sophie_Taylor", "Southern_grasshopper_mouse", "Southern_spotted_skunk", "Southern_toad", "SpaceX_reusable_launch_system_development_program", "Speckled_smooth-hound", "Speleomantes", "SpongeBob_SquarePants_(season_7)", "Spot-tail_shark", "Spotted_houndshark", "SS_Bosnia_(1898)", "St_Andrew''s_Church,_Chew_Stoke", "Stanton_Drew_stone_circles", "Stefan_Wever", "Steve_Bechler", "Sundarbans", "Sutton_Court", "Sydney_Marathon", "Symphony,_D._708a_(Schubert)", "Syringa_Marshall-Burnett", "Szombierki_Heat_Power_Station", "Tabula_Rasa_(Lost)", "Telengard", "Templeton_Thompson", "Texas_Park_Road_1", "Texas_toad", "The_Boat_Race_1978", "The_Castle_Doctrine", "The_Christmas_Sessions", "The_Dog_and_Pony_Show", "The_French_Counts_of_St_Hubert,_Saskatchewan", "The_French_Lieutenant''s_Woman", "The_Price_of_Gold", "The_Real_Housewives_of_Atlanta_(season_6)", "Thirsty_(song)", "Threes!", "Tim_Rogers_(journalist)", "Timeline_of_the_2013_Atlantic_hurricane_season", "Titan_Clydebank", "Today_the_Sun''s_on_Us", "TowerFall", "Townsend''s_vole", "Tree", "Trichilogaster_signiventris", "Tropical_Storm_Andrea_(2013)", "Troy_(submarine)", "Turning_Point_(2005_wrestling)", "Turquoise_parrot", "Two_Black_Cadillacs", "Typhoon_Betty_(1987)", "Typhoon_Irma_(1981)", "Typhoon_Lee_(1981)", "Typhoon_Nabi", "Ulla_Salzgeber", "Urania''s_Mirror", "US_Treasury_specimen_book", "Vampire:_The_Masquerade_–_Bloodlines", "VetUK", "Victory_Road_(2008)", "Villanelle", "Violet_Manners,_Duchess_of_Rutland", "Waka_Waka_(This_Time_for_Africa)", "Wally_Pipp", "Warsaw_Uprising_Monument", "Waterbuck", "Western_green_mamba", "Who_Ya_Gonna_Call?", "Wildebeest", "Wilhelmina_FitzClarence,_Countess_of_Munster", "William_B._Cornwell", "Wipeout_(video_game)", "Wipeout_2097", "Wipeout_64", "WonderSwan", "Wookey_Hole_Caves", "Yellow-cheeked_chipmunk", "Young_Love_(Janet_Jackson_song)", "Zaisan_mole_vole", "Zelous_Wheeler", "Ziggurat_(video_game)" ) AND Rev1.rev_user_text IN ( '11JORN', '12george1', 'Abductive', 'Acather96', 'Achowat', 'Adam Cuerden', 'Another Believer', 'Antidiskriminator', 'Awardgive', 'Bananasoldier', 'Bill william comptom', 'Bill william compton', 'Bloom6132', 'Buffbills7701', 'Calvin999', 'Caponer', 'Carcharoth', 'Casliber', 'Cekli829', 'Charlie the Pig', 'Chris857', 'ChrisGualtieri', 'Cliftonian', 'Cloudchased', 'Cloudz679', 'Clyde1998', 'Coemgenus', 'Courcelles', 'Cwmhiraeth', 'CycloneIsaac', 'Czar', 'Dana boomer', 'DarthBotto', 'DendroNaja', 'Double sharp', 'Ealdgyth', 'EditorE', 'EuroCarGT', 'FairyTailRocks', 'Figureskatingfan', 'Finnegas', 'Fourthords', 'Foxj', 'Gatoclass', 'Giants2008', 'Gilderien', 'Go Phightins!', 'Gobonobo', 'Godot13', 'Green Giant', 'Greengreengreenred', 'Guerillero', 'Guettarda', 'Hahc21', 'Harrias', 'HueSatLum', 'Hurricanehink', 'Igordebraga', 'In Transit', 'Iselilja', 'JDC808', 'Jamesx12345', 'Jarry1250', 'Jason Rees', 'Everymorning', 'Juliancolton', 'K. Annoyomous', 'Ks0stm', 'Leech44', 'Lucky102', 'Magiciandude', 'Mar4d', 'MarshalN20', 'MasterOfHisOwnDomain', 'Matt294069', 'Matthewedwards', 'Matthewrbowker', 'Matty.007', 'Mentoz86', 'Miszatomic', 'Mohamed CJ', 'Montanabw', 'Moswento', 'Muboshgu', 'NativeForeigner', 'Nergaal', 'Newyorkadam', 'Nutopia', 'Philosopher', 'Pi', 'Piotrus', 'PrairieKid', 'Pratyya Ghosh', 'PresN', 'Prism', 'QatarStarsLeague', 'Rcsprinter123', 'Reaper Eternal', 'Red Phoenix', 'Reid,iain james', 'Resolute', 'Rodw', 'Royroydeb', 'Ruby2010', 'STATicVapor', 'Sahara4u', 'Samwalton9', 'Sasuke Sarutobi', 'Seattle', 'Secret', 'SethAllen623', 'Soham', 'Solomon7968', 'Soman', 'Sp33dyphil', 'Spencer', 'Sportsguy17', 'Squeamish Ossifrage', 'Stone', 'StringTheory11', 'Sturmvogel 66', 'Sven Manguard', 'São Tomé and Príncipe', 'Taylor Trescott', 'Tazerdadog', 'Tecmo', 'ThaddeusB', 'TheAustinMan', 'The C of E', 'The wub', 'Thine Antique Pen', 'Toa Nidhiki05', 'Tomica', 'Torchiest', 'TropicalAnalystwx13', 'Vantine84', 'Wamiq', 'Well-rested', 'WikiRedactor', 'Wilhelmina Will', 'Wizardman', 'WonderBoy1998', 'Wrestlinglover', 'Yellow Evan', 'Ynhockey', 'Ypnypn', 'ТимофейЛееСуда' ) AND Rev1.rev_timestamp > '20140101000000' AND Rev1.rev_timestamp < '20141101000000';
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...