Untitled query #2636

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 (
"1858_Atlantic_hurricane_season",
"1917_Atlantic_hurricane_season",
"Roseland_Theater",
"Andrea_Cambini",
"Johann_Erich_Thunmann",
"Ratac_Abbey",
"1958_Asian_Games",
"1958_Asian_Games_medal_table",
"2014_National_League_Wild_Card_Game",
"Angola_Avante",
"Canadian_Platinum_Maple_Leaf",
"Fan_Lau_Fort",
"Flag_of_Gabon",
"Flag_of_Saint_Lucia",
"Holy_Rosary_Cathedral_(Vancouver)",
"Acacia_cultriformis",
"Acacia_pycnantha",
"Australian_raven",
"Epacris_impressa",
"Frank_Facer",
"Gaga_(genus)",
"Grevillea_juniperina",
"Lomatia_arborescens",
"Lomatia_fraseri",
"Monsters_Ate_My_Birthday_Cake",
"Pictor",
"Trichilogaster_signiventris",
"Turquoise_parrot",
"Benevolent_and_Protective_Order_of_Elks_Lodge_(Montrose,_Colorado)",
"Berkshire_No._7",
"Elmer_S._Dailey",
"Great_Captain_Island",
"House_at_130_Mohegan_Avenue",
"Priscilla_Dailey",
"1804_Antigua–Charleston_hurricane",
"1806_Great_Coastal_hurricane",
"1815_North_Carolina_hurricane",
"Cyclone_Winifred",
"Henry_du_Pont",
"Action_Button_Entertainment",
"Apple_Pay",
"Crawl_(video_game)",
"Cuphead",
"Development_of_Deus_Ex",
"Development_of_Fez",
"Development_of_Mother_3",
"EarthBound_fandom",
"Enter_the_Dominatrix",
"Fez_(video_game)",
"Gasketball",
"Greg_Wohlwend",
"Helen_C._White",
"Hohokum",
"Hundreds_(video_game)",
"Marcus_Lindblom",
"Mikengreg",
"Monument_Valley_(video_game)",
"Mother_(video_game)",
"Mother_3",
"Mother_3_fan_translation",
"Nidhogg_(video_game)",
"Phil_Fish",
"Puzzlejuice",
"Ridiculous_Fishing",
"Rymdkapsel",
"Saints_Row:_The_Third_downloadable_content",
"Secrets_of_Rætikon",
"Solipskier",
"Telengard",
"Threes!",
"Tim_Rogers_(journalist)",
"TowerFall",
"Ziggurat_(video_game)",
"Eastern_green_mamba",
"Forest_cobra",
"Western_green_mamba",
"Symphony,_D._708a_(Schubert)",
"Blow_(Beyoncé_Knowles_song)",
"Iftah_Ya_Simsim",
"Sesame_Street_international_co-productions",
"Alejandro_Villanueva_(American_football)",
"Anthony_Hewitt_(baseball)",
"Carlos_Ruiz_(baseball)",
"Jonathan_Pettibone",
"Kyle_Kendrick",
"Historical_coats_of_arms_of_the_U.S._states_from_1876",
"Silver_certificate_(Cuba)",
"US_Treasury_specimen_book",
"Ancient_Trader",
"Fire_and_Darkness",
"Flotilla_(video_game)",
"Seumas_McNally_Grand_Prize",
"Solar_2",
"Bogotá_Women''s_Race",
"French_Riviera_Marathon",
"Sydney_Marathon",
"Bob_Mariano_(executive)",
"1997–98_South-West_Indian_Ocean_cyclone_season",
"2003_North_Indian_Ocean_cyclone_season",
"2003_Sri_Lanka_cyclone",
"Aasa_Helgesen",
"Agnes_Abuom",
"Henriette_Schønberg_Erken",
"Mahmona_Khan",
"Maria_Komissarova",
"Marie_Simonsen",
"Marte_Wexelsen_Goksøyr",
"Por_Debajo_de_la_Mesa",
"Nasreddin_Murat-Khan",
"Hilda_Vaughan",
"2000_CECAFA_Cup",
"2001_CECAFA_Cup",
"Adam_Peaty",
"Ernest_Radcliffe_Bond",
"Henry_Alexander_Stuart-Menteth",
"His_Last_Vow",
"Kingstonian_F.C.",
"Megan_Fletcher",
"Sophie_Taylor",
"Baseball''s_Sad_Lexicon",
"Ben_Wetzler",
"Derrick_Gordon",
"Evan_Gattis",
"Hank_(dog)",
"Javier_Báez",
"Mario_Hollands",
"Scott_Wagner",
"Seth_Blair",
"Steve_Bechler",
"Wally_Pipp",
"Zelous_Wheeler",
"Pilot_(Lost)",
"Tabula_Rasa_(Lost)",
"Threes!",
"List_of_Chocobo_media",
"Seiken_Densetsu_3",
"Sega_CD",
"WonderSwan",
"Saurolophus_angustirostris",
"Brian_McGrattan",
"Cheddar_Palace",
"Hestercombe_House",
"King_Alfred''s_Tower",
"List_of_English_Heritage_properties_in_Somerset",
"Solsbury_Hill",
"St_Andrew''s_Church,_Chew_Stoke",
"Stanton_Drew_stone_circles",
"Sutton_Court",
"Wookey_Hole_Caves",
"Elizabeth_Campbell,_Duchess_of_Argyll",
"Harriet_Leveson-Gower,_Countess_Granville",
"Lady_Augusta_Gordon",
"My_Lord_John",
"Princess_Marie_Amelie_of_Baden",
"Violet_Manners,_Duchess_of_Rutland",
"Wilhelmina_FitzClarence,_Countess_of_Munster",
"Mary_Ellen_Best",
"The_Castle_Doctrine",
"Purvis_Short",
"Filipinos_in_Belgium",
"Caelum",
"Escape_from_Woomera",
"Mallica_Reynolds",
"Patrick_Allen_(Governor-General)",
"Syringa_Marshall-Burnett",
"2014_Lamu_attacks",
"2014_South_African_platinum_strike",
"April_2014_lunar_eclipse",
"BNP_Paribas",
"Fabien_Cousteau",
"Johnny_Leach",
"Macroscelides_micus",
"Mission_31",
"Shark:_Mind_of_a_Demon",
"Troy_(submarine)",
"VetUK",
"Alex_Rae_(rugby_union)",
"Ko_e_Iki_he_Lagi",
"Seal_of_Niue",
"List_of_National_Football_League_season_receiving_yards_leaders",
"The_Christmas_Sessions",
"Hurricane_Nate_(2011)",
"Timeline_of_the_2013_Atlantic_hurricane_season",
"Stefan_Wever",
"Waka_Waka_(This_Time_for_Africa)",
"Genesis_(2005)",
"Turning_Point_(2005_wrestling)",
"Victory_Road_(2008)",
"Hurricane_Manuel",
"Hurricane_Paul_(2012)",
"Typhoon_Betty_(1987)",
"Mirrors_(Natalia_Kills_song)",
"Today_the_Sun''s_on_Us",
"List_of_Pakistan_women_ODI_cricketers",
"List_of_Pakistan_women_Twenty20_International_cricketers",
"Adenomus_kelaartii",
"Afghan_pika",
"African_giant_toad",
"Alnus_glutinosa",
"Ambrosi''s_cave_salamander",
"Amietophrynus_vittatus",
"Balkan_whip_snake",
"Black_jackrabbit",
"Black_wildebeest",
"Blue_wildebeest",
"Burmese_hare",
"Cabot''s_tragopan",
"Canidae",
"Cape_starling",
"Carpathian_newt",
"Chinese_goral",
"Davies''_tree_frog",
"Eurasian_eagle-owl",
"Fairy_lorikeet",
"Fiery-shouldered_parakeet",
"Fulvous_harvest_mouse",
"Gray-collared_chipmunk",
"Greater_long-tailed_shrew_tenrec",
"Greek_rock_lizard",
"Gulf_Coast_kangaroo_rat",
"Himalayan_pika",
"Humpback_smooth-hound",
"Isopoda",
"Italian_cave_salamander",
"Italian_pool_frog",
"Japanese_common_toad",
"Least_weasel",
"Lined_pocket_mouse",
"Little_Sumba_hawk-owl",
"Little_desert_pocket_mouse",
"Lizard_catshark",
"Long-tailed_marmot",
"Malacostraca",
"Malcolm''s_Ethiopian_toad",
"Merriam''s_pocket_mouse",
"Michoacan_pocket_gopher",
"Minyobates_steyermarki",
"Mountain_parakeet",
"Myotis_moluccarum",
"Narrow-headed_vole",
"Narrow-skulled_pocket_mouse",
"Nelson''s_kangaroo_rat",
"Nelson''s_pocket_mouse",
"New_England_tree_frog",
"Nile_Delta_toad",
"Olive-backed_pocket_mouse",
"Peruvian_thick-knee",
"Podarcis_carbonelli",
"Podarcis_hispanica",
"Poultry",
"Pyrenean_frog",
"Radish",
"Red-tailed_chipmunk",
"Red_whip_snake",
"Reed_vole",
"Rodent",
"Sharp-snouted_rock_lizard",
"Sicilian_wall_lizard",
"Small_dorcopsis",
"Sonoran_green_toad",
"Southern_grasshopper_mouse",
"Southern_spotted_skunk",
"Southern_toad",
"Speckled_smooth-hound",
"Speleomantes",
"Spot-tail_shark",
"Spotted_houndshark",
"Texas_toad",
"Townsend''s_vole",
"Tree",
"Wildebeest",
"Yellow-cheeked_chipmunk",
"Zaisan_mole_vole",
"Heck_horse",
"List_of_National_Natural_Landmarks_in_Colorado",
"Nonius_horse",
"Ulla_Salzgeber",
"2014_Belmont_Stakes",
"Art_Sherman",
"Lipizzan",
"Nasal_strip",
"Templeton_Thompson",
"List_of_songs_recorded_by_Marina_and_the_Diamonds",
"Parental_Advisory",
"Someone_Else_(Miley_Cyrus_song)",
"The_Real_Housewives_of_Atlanta_(season_6)",
"Fort_Srebrna_Góra",
"Ignacy_Skorupka",
"Jan_Zamoyski",
"Kazanie_Skargi",
"Monument_to_the_Fallen_and_Murdered_in_the_East",
"Pointy_ears",
"Pyramid_of_Capitalist_System",
"Szombierki_Heat_Power_Station",
"Warsaw_Uprising_Monument",
"Who_Ya_Gonna_Call?",
"Begum_Akhtar_Riazuddin",
"Nasreddin_Murat-Khan",
"Adriana_Hoffmann",
"María_Josefa_Mujía",
"National_Dairy_Goat_Awareness_Week",
"Cruachan_Power_Station",
"Edinburgh_International_Climbing_Arena",
"Finnieston_Crane",
"Sinclair_Executive",
"Titan_Clydebank",
"Admiral_Spiridov-class_monitor",
"Al-Jarrah_ibn_Abdallah",
"Edgar_Quinet-class_cruiser",
"Fairey_Spearfish",
"French_cruiser_Amiral_Charner",
"French_cruiser_Chanzy",
"French_cruiser_Edgar_Quinet",
"French_cruiser_Waldeck-Rousseau",
"German_destroyer_Z14_Friedrich_Ihn",
"German_destroyer_Z15_Erich_Steinbrinck",
"HMS_Formidable_(67)",
"Italian_cruiser_Calabria",
"Martin_AM_Mauler",
"Regioni-class_cruiser",
"Russian_battleship_Pobeda",
"Russian_monitor_Charodeika",
"Russian_monitor_Lava",
"SS_Bosnia_(1898)",
"Charles_M._Williams_(American_academic)",
"John_Baker_White_(Virginia)",
"William_B._Cornwell",
"El_Norte_de_Castilla",
"Horn_OK_Please_(song)",
"Queen_(soundtrack)"
) 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 < '20140201000000';
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...
