Top edited monthly articles in 2016 on pl.wiki

This query is marked as a draft This query has been published by The Polish.
SQL

USE plwiki_p;
(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201601" AND "201602"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201602" AND "201603"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201603" AND "201604"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201604" AND "201605"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201605" AND "201606"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201606" AND "201607"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201607" AND "201608"
   GROUP BY month, 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 page_namespace, edits DE25SC
LIMIT 20)

UNION ALL | [[:en:Deaths in 2016|]]                                                                  || 18230 
|-
| [[:en:Donald Trump|]]                                                                    ||  8933 
|-
| [[:en:List of Hillary Clinton presidential campaign endorsements, 2016|]]                ||  6527 
|-
| [[:en:United States presidential election, 2016|]]                                       ||  6162 
|-
| [[:en:Republican Party presidential primaries, 2016|]]                                   ||  5715 
|-
| [[:en:2016 Orlando nightclub shooting|]]                                                 ||  5540 
|-
| [[:en:Bailando 2015|]]                                                                   ||  5342 
|-
| [[:en:List of Donald Trump presidential campaign endorsements, 2016|]]                   ||  5328 
|-
| [[:en:2016 in sports|]]                                                                  ||  5277 
|-
| [[:en:2016 in South Korean music|]]                                                      ||  5074 
|-
| [[:en:Beverly Gray|]]                                                                    ||  4957 
|-
| [[:en:Statewide opinion polling for the United States presidential election, 2016|]]     ||  4743 
|-
| [[:en:Panama Papers|]]                                                                   ||  4659 
|-
| [[:en:2016 in Philippine television|]]                                                   ||  4600 
|-
| [[:en:2016 Pacific typhoon season|]]                                                     ||  4244 
|-
| [[:en:2016 Atlantic hurricane season|]]                                                  ||  3874 
|-
| [[:en:Democratic Party presidential primaries, 2016|]]                                   ||  3736 
|-
| [[:en:Batman v Superman: Dawn of Justice|]]                                              ||  3593 
|-
| [[:en:The Life of Pablo|]]                                                               ||  3574 
|-
| [[:en:Vincent van Gogh|]]                                                                ||  3551 
|-
| [[:en:Donald Trump presidential campaign, 2016|]]                                        ||  3513 
|-
| [[:en:United Kingdom European Union membership referendum, 2016|]]                       ||  3433 
|-
| [[:en:2016 ATP Challenger Tour|]]                                                        ||  3412 
|-
| [[:en:Miss Universe 2016|]]                                                              ||  3358 
|-
| [[:en:A.J. Styles|]]                                                                     ||  3357 
|-
| [[:en:WrestleMania 32|]]                                                                 ||  3307 
|-
| [[:en:Occupation of the Malheur National Wildlife Refuge|]]                              ||  3289 
|-
| [[:en:2016 Nice attack|]]                                                                ||  3262 
|-
| [[:en:2016 in film|]]                                                                    ||  3236 
|-
| [[:en:Views (album)|]]                                                                   ||  3168 
|-
| [[:en:2016 Pacific hurricane season|]]                                                   ||  2848 
|-
| [[:en:2016|]]                                                                            ||  2773 
|-
| [[:en:El Coyote (character)|]]                                                           ||  2715 
|-
| [[:en:Transformers: The Last Knight|]]                                                   ||  2711 
|-
| [[:en:List of 2016 albums|]]                                                             ||  2703 
|-
| [[:en:Manchán of Mohill|]]                                                               ||  2702 
|-
| [[:en:List of most viewed YouTube videos|]]                                              ||  2698 
|-
| [[:en:Big Brother 18 (U.S.)|]]                                                           ||  2691 
|-
| [[:en:List of original programs distributed by Netflix|]]                                ||  2603 
|-
| [[:en:Protests against Donald Trump|]]                                                   ||  2592 
|-
| [[:en:The Jungle Book (2016 film)|]]                                                     ||  2582 
|-
| [[:en:The Voice (U.S. season 10)|]]                                                      ||  2567 
|-
| [[:en:2016 in American television|]]                                                     ||  2566 
|-
| [[:en:List of WWE personnel|]]                                                           ||  2559 
|-
| [[:en:RuPaul's Drag Race (season 8)|]]                                                   ||  2554 
|-
| [[:en:Athletics at the 2016 Summer Olympics – Qualification|]]                           ||  2508 
|-
| [[:en:2016 WTA Finals|]]                                                                 ||  2490 
|-
| [[:en:Finding Dory|]]                                                                    ||  2472 
|-
| [[:en:DC Extended Universe|]]                                                            ||  2467 
|-
| [[:en:2016 Turkish coup d'état attempt|]]                                                ||  2464 
|-
| [[:en:The Voice (U.S. season 11)|]]                                                      ||  2458 
|-
| [[:en:RuPaul's Drag Race: All Stars (season 2)|]]                                        ||  2414 
|-
| [[:en:Lonnie Mack|]]                                                                     ||  2351 
|-
| [[:en:2016 WTA Tour|]]                                                                   ||  2335 
|-
| [[:en:2016 ATP World Tour|]]                                                             ||  2327 
|-
| [[:en:Star Wars: The Force Awakens|]]                                                    ||  2320 
|-
| [[:en:Planet Nine|]]                                                                     ||  2318 
|-
| [[:en:List of Autobots|]]                                                                ||  2276 
|-
| [[:en:X-Men: Apocalypse|]]                                                               ||  2271 
|-
| [[:en:American Idol (season 15)|]]                                                       ||  2258 
|-
| [[:en:Deadpool (film)|]]                                                                 ||  2257 
|-
| [[:en:The X Factor (UK series 13)|]]                                                     ||  2252 
|-
| [[:en:Forcade|]]                                                                         ||  2236 
|-
| [[:en:Nationwide opinion polling for the United States presidential election, 2016|]]    ||  2227 
|-
| [[:en:Pokémon Go|]]                                                                      ||  2219 
|-
| [[:en:America's Got Talent (season 11)|]]                                                ||  2216 
|-
| [[:en:Zootopia|]]                                                                        ||  2202 
|-
| [[:en:Jordan|]]                                                                          ||  2201 
|-
| [[:en:Captain America: Civil War|]]                                                      ||  2188 
|-
| [[:en:2016 Brussels bombings|]]                                                          ||  2187 
|-
| [[:en:Political positions of Donald Trump|]]                                             ||  2185 
|-
| [[:en:Great Britain at the 2016 Summer Olympics|]]                                       ||  2140 
|-
| [[:en:Nuestra Belleza Latina 2016|]]                                                     ||  2138 
|-
| [[:en:United States at the 2016 Summer Olympics|]]                                       ||  2120 
|-
| [[:en:2017 in sports|]]                                                                  ||  2118 
|-
| [[:en:Muhammad Ali|]]                                                                    ||  2115 
|-
| [[:en:Sausage Party|]]                                                                   ||  2112 
|-
| [[:en:List of earthquakes in 2016|]]                                                     ||  2107 
|-
| [[:en:Hillary Clinton|]]                                                                 ||  2082 
|-
| [[:en:Independence Day: Resurgence|]]                                                    ||  2081 
|-
| [[:en:EgyptAir Flight 804|]]                                                             ||  2081 
|-
| [[:en:Newspaper endorsements in the United States presidential election, 2016|]]         ||  2072 
|-
| [[:en:Dangerous Woman (album)|]]                                                         ||  2065 
|-
| [[:en:List of current champions in WWE|]]                                                ||  2055 
|-
| [[:en:The Revenant (2015 film)|]]                                                        ||  2044 
|-
| [[:en:Bailando 2016|]]                                                                   ||  2019 
|-
| [[:en:2016 AFL season|]]                                                                 ||  2015 
|-
| [[:en:Brexit|]]                                                                          ||  2014 
|-
| [[:en:Big Brother Canada (season 4)|]]                                                   ||  2007 
|-
| [[:en:Bigg Boss 10|]]                                                                    ||  1997 
|-
| [[:en:List of terrorist incidents, 2016|]]                                               ||  1983 
|-
| [[:en:Garage rock|]]                                                                     ||  1965 
|-
| [[:en:Ghostbusters (2016 film)|]]                                                        ||  1960 
|-
| [[:en:List of American Horror Story characters|]]                                        ||  1958 
|-
| [[:en:Edge, Branscombe|]]                                                                ||  1957 
|-
| [[:en:India at the 2016 Summer Olympics|]]                                               ||  1953 
|-
| [[:en:List of Decepticons|]]                                                             ||  1930 
|-
| [[:en:Legalism (Chinese philosophy)|]]                                                   ||  1929 
|-
| [[:en:David Bowie|]]                                                                     ||  1928 
|-
| [[:en:Twice (band)|]]                                                                    ||  1924 
|-
| [[:en:2016 shooting of Dallas police officers|]]                                         ||  1900 
|-
| [[:en:List of Bernie Sanders presidential campaign endorsements, 2016|]]                 ||  1892 
|-
| [[:en:Big Brother: Over the Top|]]                                                       ||  1891 
|-
| [[:en:Panathinaikos B.C.|]]                                                              ||  1872 
|-
| [[:en:2016 Munich shooting|]]                                                            ||  1867 
|-
| [[:en:Asia's Next Top Model (cycle 4)|]]                                                 ||  1867 
|-
| [[:en:2015–16 Zika virus epidemic|]]                                                     ||  1856 
|-
| [[:en:List of Philippine television specials aired in 2016|]]                            ||  1855 
|-
| [[:en:List of deaths in rock and roll|]]                                                 ||  1854 
|-
| [[:en:Open Era tennis records – men's singles|]]                                         ||  1848 
|-
| [[:en:2016 in video gaming|]]                                                            ||  1841 
|-
| [[:en:Strictly Come Dancing (series 14)|]]                                               ||  1834 
|-
| [[:en:2016–17 United States network television schedule|]]                               ||  1825 
|-
| [[:en:Canada at the 2016 Summer Olympics|]]                                              ||  1818 
|-
| [[:en:Baal Veer|]]                                                                       ||  1814 
|-
| [[:en:2016 in British television|]]                                                      ||  1807 
|-
| [[:en:Turkish military intervention in Syria|]]                                          ||  1807 
|-
| [[:en:The Loud House|]]                                                                  ||  1802 
|-
| [[:en:Naagin (TV series)|]]                                                              ||  1801 
|-
| [[:en:Cary Grant|]]                                                                      ||  1800 
|-
| [[:en:2016 ATP World Tour Finals|]]                                                      ||  1795 
|-
| [[:en:ATP World Tour records|]]                                                          ||  1792 
|-
| [[:en:Eurovision Song Contest 2016|]]                                                    ||  1785 
|-
| [[:en:Suicide Squad (film)|]]                                                            ||  1779 
|-
| [[:en:Endorsements in the United Kingdom European Union membership referendum, 2016|]]   ||  1771 
|-
| [[:en:Rodrigo Duterte|]]                                                                 ||  1764 
|-
| [[:en:List of The Flash episodes|]]                                                      ||  1757 
|-
| [[:en:List of Running Man episodes|]]                                                    ||  1753 
|-
| [[:en:2016 NBA Playoffs|]]                                                               ||  1732 
|-
| [[:en:Prince (musician)|]]                                                               ||  1715 
|-
| [[:en:Hurricane Matthew|]]                                                               ||  1714 
|-
| [[:en:Anti (album)|]]                                                                    ||  1712 
|-
| [[:en:Alt-right|]]                                                                       ||  1704 
|-
| [[:en:Copa América Centenario|]]                                                         ||  1693 
|-
| [[:en:Survivor Series (2016)|]]                                                          ||  1689 
|-
| [[:en:2016 clown sightings|]]                                                            ||  1685 
|-
| [[:en:Flint water crisis|]]                                                              ||  1683 
|-
| [[:en:2016 World Series|]]                                                               ||  1671 
|-
| [[:en:List of highest-grossing animated films|]]                                         ||  1662 
|-
| [[:en:List of Steven Universe characters|]]                                              ||  1659 
|-
| [[:en:2016 Indian Premier League|]]                                                      ||  1658 
|-
| [[:en:88th Academy Awards|]]                                                             ||  1657 
|-
| [[:en:Conor McGregor|]]                                                                  ||  1648 
|-
| [[:en:List of 2016–17 NBA season transactions|]]                                         ||  1646 
|-
| [[:en:List of Steven Universe episodes|]]                                                ||  1640 
|-
| [[:en:2016–17 FC Barcelona season|]]                                                     ||  1632 
|-
| [[:en:The Secret Life of Pets|]]                                                         ||  1624 
|-
| [[:en:Dancing with the Stars (U.S. season 23)|]]                                         ||  1623 
|-
| [[:en:X-Men (film series)|]]                                                             ||  1623 
|-
| [[:en:List of White Pass and Yukon Route locomotives and cars|]]                         ||  1612 
|-
| [[:en:Endorsements for the Republican Party presidential primaries, 2016|]]              ||  1610 
|-
| [[:en:John C. Calhoun|]]                                                                 ||  1609 
|-
| [[:en:2016 World Snooker Championship|]]                                                 ||  1607 
|-
| [[:en:Donald Trump sexual misconduct allegations|]]                                      ||  1607 
|-
| [[:en:Work Capability Assessment|]]                                                      ||  1605 
|-
| [[:en:Legends of Tomorrow|]]                                                             ||  1601 
|-
| [[:en:Doctor Strange (film)|]]                                                           ||  1601 
|-
| [[:en:World Chess Championship 2016|]]                                                   ||  1594 
|-
| [[:en:List of programs broadcast by GMA Network|]]                                       ||  1594 
|-
| [[:en:Pinoy Big Brother: Lucky 7|]]                                                      ||  1593 
|-
| [[:en:2016 in the United States|]]                                                       ||  1588 
|-
| [[:en:United States presidential election, 2020|]]                                       ||  1587 
|-
| [[:en:MTA Regional Bus Operations bus fleet|]]                                           ||  1580 
|-
| [[:en:List of people named in the Panama Papers|]]                                       ||  1577 
|-
| [[:en:Ang Probinsyano|]]                                                                 ||  1577 
|-
| [[:en:Australian federal election, 2016|]]                                               ||  1575 
|-
| [[:en:Cabinet of Donald Trump|]]                                                         ||  1571 
|-
| [[:en:Statewide opinion polling for the Democratic Party presidential primaries, 2016|]] ||  1570 
|-
| [[:en:Dol-de-Bretagne's Cathedral (Cathédrale Saint-Samson de Dol)|]]                    ||  1565 
|-
| [[:en:2016 NASCAR Sprint Cup Series|]]                                                   ||  1562 
|-
| [[:en:2016 Indian Super League season|]]                                                 ||  1561 
|-
| [[:en:SummerSlam (2016)|]]                                                               ||  1561 
|-
| [[:en:2016 in the Philippines|]]                                                         ||  1557 
|-
| [[:en:Heavy metals|]]                                                                    ||  1555 
|-
| [[:en:Work from Home|]]                                                                  ||  1553 
|-
| [[:en:Encantadia (2016 TV series)|]]                                                     ||  1551 
|-
| [[:en:United States House of Representatives elections, 2016|]]                          ||  1551 
|-
| [[:en:Great Britain at the 2016 Summer Paralympics|]]                                    ||  1551 
|-
| [[:en:Fantastic Beasts and Where to Find Them (film)|]]                                  ||  1550 
|-
| [[:en:Dancing with the Stars (U.S. season 22)|]]                                         ||  1548 
|-
| [[:en:Björn Kuipers|]]                                                                   ||  1547 
|-
| [[:en:Zika virus|]]                                                                      ||  1543 
|-
| [[:en:Doble Kara|]]                                                                      ||  1541 
|-
| [[:en:Birds in the Trap Sing McKnight|]]                                                 ||  1541 
|-
| [[:en:Russia at the 2016 Summer Olympics|]]                                              ||  1540 
|-
| [[:en:2016 Summer Olympics medal table|]]                                                ||  1538 
|-
| [[:en:Drake (musician)|]]                                                                ||  1534 
|-
| [[:en:Junior Eurovision Song Contest 2016|]]                                             ||  1534 
|-
| [[:en:Vladimir Putin|]]                                                                  ||  1532 
|-
| [[:en:Portsmouth|]]                                                                      ||  1527 
|-
| [[:en:ASAP (variety show)|]]                                                             ||  1527 
|-
| [[:en:2016–17 Premier League|]]                                                          ||  1525 
|-
| [[:en:Chronological summary of the 2016 Summer Olympics|]]                               ||  1522 
|-
| [[:en:List of EastEnders characters (2016)|]]                                            ||  1515 
|-
| [[:en:List of countries by GDP (nominal)|]]                                              ||  1515 
|-
| [[:en:Moana (2016 film)|]]                                                               ||  1514 
|-
| [[:en:Flydubai Flight 981|]]                                                             ||  1508 
|-
| [[:en:List of countries and dependencies by population|]]                                ||  1502 
|-
| [[:en:Bernie Sanders|]]                                                                  ||  1493 
|-
| [[:en:Snooker world ranking points 2016/2017|]]                                          ||  1488 
|-
| [[:en:Tornadoes of 2016|]]                                                               ||  1484 
|-
| [[:en:Lemonade (Beyoncé album)|]]                                                        ||  1482 
|-
| [[:en:Leicester City F.C.|]]                                                             ||  1480 
|-
| [[:en:Miraculous: Tales of Ladybug & Cat Noir|]]                                         ||  1477 
|-
| [[:en:Kabali (film)|]]                                                                   ||  1476 
|-
| [[:en:Florida Gators football|]]                                                         ||  1472 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201608" AND "201609"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201609" AND "201610"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201610" AND "201611"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201611" AND "201612"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201612" AND "201701"
   GROUP BY month, 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 page_namespace, edits DESC
LIMIT 20);
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...
