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

1. Deaths in 2017 (20907)
2. 2017 Atlantic hurricane season (6309)
3. 2017 in South Korean music (5573)
4. List of most-viewed YouTube videos (5146)
5. 2017 Pacific typhoon season (5101)
6. Index of Italy-related articles (4863)
7. Donald Trump (4621)
8. La Luna Sangre (4596)
9. 2017 in sports (4580)
10. Transformers: The Last Knight (4496)
11. Asia's Next Top Model (4302)
12. Political appointments by Donald Trump (4237)
13. The Voice (4201)
14. 2017 Women's March (4153)
15. 2017 in film (4133)
16. Grenfell Tower fire (4062)
17. United Kingdom general election (3913)
18. Beauty and the Beast (3835)
19. List of Confederate monuments and memorials (3807)
20. 2017 Liga 1 (3701)
21. 2017 in Philippine television (3696)
22. 2017 Las Vegas shooting (3657)
23. 2017 in American television (3618)
24. The Voice (3614)
25. Manchester Arena bombing (3602)
26. 2017 Westminster attack (3565)
27. 2017 (3539)
28. Unite the Right rally (3509)
29. Escape the Night (3416)
30. 2017 ATP Challenger Tour (3253)
31. Wonder Woman (3228)
32. Despacito (3210)
33. Executive Order 13769 (3210)
34. Dunkirk (3196)
35. List of original programs distributed by Netflix (3093)
36. List of 2017 albums (2980)
37. Russian interference in the 2016 United States elections (2966)
38. Strictly Come Dancing (2817)
39. List of most-subscribed YouTube channels (2811)
40. Cars 3 (2771)
41. 2017 World Snooker Championship (2740)
42. Hurricane Irma (2735)
43. DC Extended Universe (2728)
44. 2017 ATP World Tour (2703)
45. X-Men (2665)
46. Spider-Man: Homecoming (2616)
47. Garage rock (2565)
48. WrestleMania 33 (2552)
49. Bailando 2017 (2548)
50. List of Nintendo Switch games (2542)
51. List of current UFC fighters (2536)
52. The Holocaust (2506)
53. Eurovision Song Contest 2017 (2496)
54. Logan (2480)
55. Dancing with the Stars (2472)
56. Ulysses S. Grant (2446)
57. List of people who disappeared mysteriously (2445)
58. List of EastEnders characters (2432)
59. Joseph Stalin (2369)
60. Lonnie Mack (2331)
61. Brexit (2331)
62. Miss Universe 2017 (2327)
63. Thor: Ragnarok (2297)
64. Guardians of the Galaxy Vol. 2 (2276)
65. MTA Regional Bus Operations bus fleet (2228)
66. My Little Pony: The Movie (2216)
67. Blade Runner 2049 (2216)
68. 2017 Monster Energy NASCAR Cup Series (2168)
69. 2017 WTA Tour (2158)
70. List of current champions in WWE (2149)
71. List of WWE personnel (2145)
72. 2017–18 Premier League (2135)
73. Dancing with the Stars (2117)
74. 2017 Pacific hurricane season (2117)
75. June 2017 London Bridge attack (2110)
76. Big Brother 19 (2078)
77. List of Marvel Cinematic Universe films (2070)
78. Mersal (2063)
79. Battle of Mosul (2033)
80. Justice League (2033)
81. Yuttha Medai All Stars (2024)
82. 2017 AFL season (2020)
83. United States Senate special election in Alabama (2010)
84. List of Bollywood films of 2017 (2001)
85. List of White Pass and Yukon Route locomotives and cars (2000)
86. Timeline of Russian interference in the 2016 United States elections (1991)
87. Ang Probinsyano (1989)
88. 2017 Kelantan FA season (1985)
89. RuPaul's Drag Race (1981)
90. 2017 Barcelona attacks (1979)
91. 2017 Southeast Asian Games (1975)
92. United States presidential election (1973)
93. Australian Marriage Law Postal Survey (1965)
94. List of most-liked YouTube videos (1960)
95. Harvard–Yale football rivalry (1958)
96. Underworld Unleashed (1941)
97. Paul Martin (1940)
98. List of earthquakes in 2017 (1914)
99. List of Dragon Ball Super episodes (1904)
100. Lead (1903)
101. 89th Academy Awards (1900)
102. Star Wars: The Last Jedi (1893)
103. Miss World 2017 (1887)
104. 2017–18 FC Barcelona season (1875)
105. Pirates of the Caribbean: Dead Men Tell No Tales (1854)
106. Stardust the Super Wizard (1854)
107. Battle of Marawi (1849)
108. 2017 WTA Finals (1847)
109. Open Era tennis records – men's singles (1845)
110. List of Impact Wrestling personnel (1838)
111. Riverdale (1834)
112. 2017 ATP Finals (1832)
113. Hurricane Maria (1828)
114. List of Transformers film series characters (1827)
115. 2018 in film (1814)
116. Presidency of Donald Trump (1802)
117. 2017 in hip hop music (1801)
118. List of European countries by average wage (1794)
119. Twin Peaks (1791)
120. Hurricane Harvey (1778)
121. United States House of Representatives elections (1767)
122. Dismissal of James Comey (1766)
123. 2017 in heavy metal music (1761)
124. Roger Federer (1749)
125. 2017 Philippines Football League (1747)
126. Bigg Boss Tamil (1746)
127. 2017–18 Indian Super League season (1743)
128. Produce 101 Season 2 (1738)
129. 2017 Major League Soccer season (1733)
130. Power Rangers (1733)
131. Miss Earth 2017 (1729)
132. 2017 NBA Playoffs (1721)
133. List of conspiracy theories (1719)
134. WannaCry ransomware attack (1718)
135. Legalism (1716)
136. Index of Austria-related articles (1708)
137. Alien: Covenant (1701)
138. Sasural Simar Ka (1694)
139. Tornadoes of 2017 (1689)
140. List of 2017–18 NBA season transactions (1688)
141. 2017 in spaceflight (1684)
142. Get Out (1682)
143. Kartamyshevska Street (1682)
144. List of adventure films of the 1950s (1681)
145. 2017 in video gaming (1675)
146. Coco (1673)
147. Nintendo Switch (1673)
148. It (1673)
149. Sutherland Springs church shooting (1668)
150. Royal Rumble (1667)
151. 2018 in sports (1664)
152. Slavic Native Faith (1660)
153. Look What You Made Me Do (1655)
154. Meghan Markle (1655)
155. Kenzō Shirai (1653)
156. List of adventure films of the 1960s (1647)
157. Roy Moore (1641)
158. 2017 in professional wrestling (1610)
159. 2017 in American music (1607)
160. 2017–18 Chelsea F.C. season (1605)
161. 2017 Stockholm attack (1605)
162. America's Got Talent (1602)
163. 2017 in British television (1599)
164. Big Brother 18 (1595)
165. Index of Hawaii-related articles (1594)
166. List of highest-grossing Indian films (1592)
167. List of American Horror Story cast members (1584)
168. 42nd Ontario general election (1581)
169. Stranger Things (1579)
170. Milo Yiannopoulos (1579)
171. List of The Loud House episodes (1573)
172. 2018 Monster Energy NASCAR Cup Series (1571)
173. List of Kamen Rider Ex-Aid characters (1570)
174. The Fate of the Furious (1570)
175. Super Bowl LI (1566)
176. Andrew Jackson (1563)
177. Catalan independence referendum (1554)
178. All-time tennis records – men's singles (1552)
179. List of programs broadcast by TV Land (1551)
180. 2017 World Series (1546)
181. Padmavati (1538)
182. Baahubali 2: The Conclusion (1535)
183. List of Cars characters (1533)
184. Emmanuel Macron (1525)
185. Reputation (1524)
186. List of American film actresses (1514)
187. 2017 Qatar diplomatic crisis (1513)
188. French presidential election (1512)
189. List of Falcon 9 and Falcon Heavy launches (1510)
190. List of deaths from drug overdose and intoxication (1509)
191. Eurovision Song Contest 2018 (1500)
192. 2017 North Indian Ocean cyclone season (1499)
193. Fake news (1488)
194. 2016–17 La Liga (1488)

The Query

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;