Untitled query #3017

This query is marked as a draft This query has been published by EGalvez (WMF).
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.
SQL

Checking query status...
