User:EpochFail/Top edits 2017
The following list respresents the most edited articles in English Wikipedia in 2017. Query run on 12/18/2017.
The List
[edit]- Deaths in 2017 (20907)
- 2017 Atlantic hurricane season (6309)
- 2017 in South Korean music (5573)
- List of most-viewed YouTube videos (5146)
- 2017 Pacific typhoon season (5101)
- Index of Italy-related articles (4863)
- Donald Trump (4621)
- La Luna Sangre (4596)
- 2017 in sports (4580)
- Transformers: The Last Knight (4496)
- Asia's Next Top Model (4302)
- Political appointments by Donald Trump (4237)
- The Voice (4201)
- 2017 Women's March (4153)
- 2017 in film (4133)
- Grenfell Tower fire (4062)
- United Kingdom general election (3913)
- Beauty and the Beast (3835)
- List of Confederate monuments and memorials (3807)
- 2017 Liga 1 (3701)
- 2017 in Philippine television (3696)
- 2017 Las Vegas shooting (3657)
- 2017 in American television (3618)
- The Voice (3614)
- Manchester Arena bombing (3602)
- 2017 Westminster attack (3565)
- 2017 (3539)
- Unite the Right rally (3509)
- Escape the Night (3416)
- 2017 ATP Challenger Tour (3253)
- Wonder Woman (3228)
- Despacito (3210)
- Executive Order 13769 (3210)
- Dunkirk (3196)
- List of original programs distributed by Netflix (3093)
- List of 2017 albums (2980)
- Russian interference in the 2016 United States elections (2966)
- Strictly Come Dancing (2817)
- List of most-subscribed YouTube channels (2811)
- Cars 3 (2771)
- 2017 World Snooker Championship (2740)
- Hurricane Irma (2735)
- DC Extended Universe (2728)
- 2017 ATP World Tour (2703)
- X-Men (2665)
- Spider-Man: Homecoming (2616)
- Garage rock (2565)
- WrestleMania 33 (2552)
- Bailando 2017 (2548)
- List of Nintendo Switch games (2542)
- List of current UFC fighters (2536)
- The Holocaust (2506)
- Eurovision Song Contest 2017 (2496)
- Logan (2480)
- Dancing with the Stars (2472)
- Ulysses S. Grant (2446)
- List of people who disappeared mysteriously (2445)
- List of EastEnders characters (2432)
- Joseph Stalin (2369)
- Lonnie Mack (2331)
- Brexit (2331)
- Miss Universe 2017 (2327)
- Thor: Ragnarok (2297)
- Guardians of the Galaxy Vol. 2 (2276)
- MTA Regional Bus Operations bus fleet (2228)
- My Little Pony: The Movie (2216)
- Blade Runner 2049 (2216)
- 2017 Monster Energy NASCAR Cup Series (2168)
- 2017 WTA Tour (2158)
- List of current champions in WWE (2149)
- List of WWE personnel (2145)
- 2017–18 Premier League (2135)
- Dancing with the Stars (2117)
- 2017 Pacific hurricane season (2117)
- June 2017 London Bridge attack (2110)
- Big Brother 19 (2078)
- List of Marvel Cinematic Universe films (2070)
- Mersal (2063)
- Battle of Mosul (2033)
- Justice League (2033)
- Yuttha Medai All Stars (2024)
- 2017 AFL season (2020)
- United States Senate special election in Alabama (2010)
- List of Bollywood films of 2017 (2001)
- List of White Pass and Yukon Route locomotives and cars (2000)
- Timeline of Russian interference in the 2016 United States elections (1991)
- Ang Probinsyano (1989)
- 2017 Kelantan FA season (1985)
- RuPaul's Drag Race (1981)
- 2017 Barcelona attacks (1979)
- 2017 Southeast Asian Games (1975)
- United States presidential election (1973)
- Australian Marriage Law Postal Survey (1965)
- List of most-liked YouTube videos (1960)
- Harvard–Yale football rivalry (1958)
- Underworld Unleashed (1941)
- Paul Martin (1940)
- List of earthquakes in 2017 (1914)
- List of Dragon Ball Super episodes (1904)
- Lead (1903)
- 89th Academy Awards (1900)
- Star Wars: The Last Jedi (1893)
- Miss World 2017 (1887)
- 2017–18 FC Barcelona season (1875)
- Pirates of the Caribbean: Dead Men Tell No Tales (1854)
- Stardust the Super Wizard (1854)
- Battle of Marawi (1849)
- 2017 WTA Finals (1847)
- Open Era tennis records – men's singles (1845)
- List of Impact Wrestling personnel (1838)
- Riverdale (1834)
- 2017 ATP Finals (1832)
- Hurricane Maria (1828)
- List of Transformers film series characters (1827)
- 2018 in film (1814)
- Presidency of Donald Trump (1802)
- 2017 in hip hop music (1801)
- List of European countries by average wage (1794)
- Twin Peaks (1791)
- Hurricane Harvey (1778)
- United States House of Representatives elections (1767)
- Dismissal of James Comey (1766)
- 2017 in heavy metal music (1761)
- Roger Federer (1749)
- 2017 Philippines Football League (1747)
- Bigg Boss Tamil (1746)
- 2017–18 Indian Super League season (1743)
- Produce 101 Season 2 (1738)
- 2017 Major League Soccer season (1733)
- Power Rangers (1733)
- Miss Earth 2017 (1729)
- 2017 NBA Playoffs (1721)
- List of conspiracy theories (1719)
- WannaCry ransomware attack (1718)
- Legalism (1716)
- Index of Austria-related articles (1708)
- Alien: Covenant (1701)
- Sasural Simar Ka (1694)
- Tornadoes of 2017 (1689)
- List of 2017–18 NBA season transactions (1688)
- 2017 in spaceflight (1684)
- Get Out (1682)
- Kartamyshevska Street (1682)
- List of adventure films of the 1950s (1681)
- 2017 in video gaming (1675)
- Coco (1673)
- Nintendo Switch (1673)
- It (1673)
- Sutherland Springs church shooting (1668)
- Royal Rumble (1667)
- 2018 in sports (1664)
- Slavic Native Faith (1660)
- Look What You Made Me Do (1655)
- Meghan Markle (1655)
- Kenzō Shirai (1653)
- List of adventure films of the 1960s (1647)
- Roy Moore (1641)
- 2017 in professional wrestling (1610)
- 2017 in American music (1607)
- 2017–18 Chelsea F.C. season (1605)
- 2017 Stockholm attack (1605)
- America's Got Talent (1602)
- 2017 in British television (1599)
- Big Brother 18 (1595)
- Index of Hawaii-related articles (1594)
- List of highest-grossing Indian films (1592)
- List of American Horror Story cast members (1584)
- 42nd Ontario general election (1581)
- Stranger Things (1579)
- Milo Yiannopoulos (1579)
- List of The Loud House episodes (1573)
- 2018 Monster Energy NASCAR Cup Series (1571)
- List of Kamen Rider Ex-Aid characters (1570)
- The Fate of the Furious (1570)
- Super Bowl LI (1566)
- Andrew Jackson (1563)
- Catalan independence referendum (1554)
- All-time tennis records – men's singles (1552)
- List of programs broadcast by TV Land (1551)
- 2017 World Series (1546)
- Padmavati (1538)
- Baahubali 2: The Conclusion (1535)
- List of Cars characters (1533)
- Emmanuel Macron (1525)
- Reputation (1524)
- List of American film actresses (1514)
- 2017 Qatar diplomatic crisis (1513)
- French presidential election (1512)
- List of Falcon 9 and Falcon Heavy launches (1510)
- List of deaths from drug overdose and intoxication (1509)
- Eurovision Song Contest 2018 (1500)
- 2017 North Indian Ocean cyclone season (1499)
- Fake news (1488)
- 2016–17 La Liga (1488)
The Query
[edit]SELECT CONCAT("# [[:en:", REPLACE(page_title, "_", " "), "|]]") AS article, CONCAT("(", edits, ")") AS edits
FROM (
SELECT rev_page, COUNT(*) AS edits
FROM revision
WHERE rev_timestamp BETWEEN "20170101" AND "20180101"
GROUP BY rev_page
ORDER BY edits DESC
LIMIT 500
) AS top_page_edits
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY edits DESC;