Skip to content

Instantly share code, notes, and snippets.

@slaporte

slaporte/averages

Last active December 31, 2015 00:09
Show Gist options
  • Save slaporte/7905727 to your computer and use it in GitHub Desktop.
Save slaporte/7905727 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
averages
MariaDB [enwiki_p]> SELECT rc_title, AVG(rc_new_len - rc_old_len) FROM recentchanges WHERE rc_namespace = 0 AND rc_timestamp > 20131203000000 GROUP BY rc_title ORDER BY AVG(rc_new_len - rc_old_len) DESC LIMIT 10;
+---------------------------------------------------------------------------------+------------------------------+
| rc_title | AVG(rc_new_len - rc_old_len) |
+---------------------------------------------------------------------------------+------------------------------+
| Richard_Helms,_early_career | 145301.0000 |
| List_of_Scheduled_prehistoric_Monuments_in_Pembrokeshire_(domestic_and_defence) | 75804.0000 |
| Opinion_polling_for_the_German_federal_election,_2013 | 53762.0000 |
| Taikyoku_shogi | 52598.0000 |
| 1998_Philadelphia_Phillies_season | 40958.0000 |
| 1997_Philadelphia_Phillies_season | 40604.0000 |
| List_of_Wigan_Warriors_internationals | 40351.0000 |
| Production_(economics) | 35218.0000 |
| 2013_in_molluscan_paleontology | 34635.5000 |
| List_of_mathematical_constants | 34142.0000 |
+---------------------------------------------------------------------------------+------------------------------+
10 rows in set (16.60 sec)
Raw
counts
MariaDB [enwiki_p]> SELECT count(*) FROM recentchanges WHERE rc_namespace = 0 AND rc_timestamp > 20131203000000;
+----------+
| count(*) |
+----------+
| 1271525 |
+----------+
1 row in set (10.23 sec)
MariaDB [enwiki_p]> SELECT count(*) FROM recentchanges WHERE rc_namespace = 1 AND rc_timestamp > 20131203000000;
+----------+
| count(*) |
+----------+
| 96429 |
+----------+
1 row in set (0.73 sec)
MariaDB [enwiki_p]> SELECT count(DISTINCT rc_title) FROM recentchanges WHERE rc_namespace = 0 AND rc_timestamp > 20131203000000;
+--------------------------+
| count(DISTINCT rc_title) |
+--------------------------+
| 615454 |
+--------------------------+
1 row in set (12.83 sec)
MariaDB [enwiki_p]> SELECT count(DISTINCT rc_title) FROM recentchanges WHERE rc_namespace = 1 AND rc_timestamp > 20131203000000;
+--------------------------+
| count(DISTINCT rc_title) |
+--------------------------+
| 66121 |
+--------------------------+
1 row in set (0.94 sec)
Raw
mainspace
MariaDB [enwiki_p]> SELECT rc_title, count(*) FROM recentchanges WHERE rc_namespace = 0 AND rc_timestamp > 20131203000000 GROUP BY rc_title ORDER BY count(*) DESC LIMIT 25;
+---------------------------------------------------------------+----------+
| rc_title | count(*) |
+---------------------------------------------------------------+----------+
| Euromaidan | 689 |
| Nelson_Mandela | 546 |
| Deaths_in_2013 | 483 |
| List_of_companies_of_the_United_States | 416 |
| List_of_college_sports_team_nicknames | 411 |
| Reactions_to_the_death_of_Nelson_Mandela | 320 |
| 2013–14_Hong_Kong_Reserve_Division_League | 319 |
| Jacoby_Ellsbury | 312 |
| Telexfree | 311 |
| Frozen_(2013_film) | 274 |
| The_X_Factor_(U.S._season_3) | 271 |
| I'm_a_Celebrity...Get_Me_Out_of_Here!_(UK_series_13) | 263 |
| Soka_Gakkai | 244 |
| 2013_Vietnam_Open_Grand_Prix | 244 |
| 2014_FIFA_World_Cup | 239 |
| Medical_cannabis | 238 |
| List_of_dignitaries_at_the_memorial_service_of_Nelson_Mandela | 237 |
| Jimi_Hendrix | 234 |
| House_of_Sabah | 227 |
| List_of_Stars_in_Their_Eyes_episodes | 225 |
| Carolina_Parakeet | 222 |
| Bird_migration_perils | 217 |
| Survivor:_Blood_vs._Water | 211 |
| List_of_Monster_High_characters | 207 |
| Cyclone_Bodil | 204 |
+---------------------------------------------------------------+----------+
25 rows in set (20.45 sec)
Raw
sums
MariaDB [enwiki_p]> SELECT rc_title, SUM(rc_new_len - rc_old_len) FROM recentchanges WHERE rc_namespace = 0 AND rc_timestamp > 20131203000000 GROUP BY rc_title ORDER BY SUM(rc_new_len - rc_old_len) DESC LIMIT 10;
+---------------------------------------------------------------------------------+------------------------------+
| rc_title | SUM(rc_new_len - rc_old_len) |
+---------------------------------------------------------------------------------+------------------------------+
| List_of_Scheduled_prehistoric_Monuments_in_Pembrokeshire_(domestic_and_defence) | 151608 |
| Richard_Helms,_early_career | 145301 |
| Euromaidan | 141025 |
| List_of_Scheduled_Roman_to_modern_Monuments_in_Gwynedd | 119275 |
| Tennis_records_of_All_Time_-_Men's_Singles | 113317 |
| South_African_criminal_law | 112946 |
| List_of_NFL_players_with_chronic_traumatic_encephalopathy | 107973 |
| Deaths_in_November_2013 | 105441 |
| List_of_Stars_in_Their_Eyes_episodes | 89499 |
| Commemoration_of_the_American_Civil_War | 82651 |
+---------------------------------------------------------------------------------+------------------------------+
10 rows in set (16.24 sec)
Raw
talkspace
MariaDB [enwiki_p]> SELECT rc_title, count(*) FROM recentchanges WHERE rc_namespace = 1 AND rc_timestamp > 20131203000000 GROUP BY rc_title ORDER BY count(*) DESC LIMIT 25;
+----------------------------------------------+----------+
| rc_title | count(*) |
+----------------------------------------------+----------+
| Rupert_Sheldrake | 534 |
| Medical_cannabis | 332 |
| Nelson_Mandela | 321 |
| Thomas_Jefferson | 196 |
| Madai | 163 |
| United_States | 154 |
| Cities_and_towns_during_the_Syrian_civil_war | 149 |
| Main_Page | 145 |
| Euromaidan | 145 |
| Australia_national_association_football_team | 130 |
| Bantu_peoples | 130 |
| Edward_Snowden | 107 |
| Dilemma_of_determinism | 104 |
| Soka_Gakkai | 102 |
| War_on_Women | 102 |
| Anthony_Holland_(composer) | 99 |
| Natural_product | 98 |
| Political_activities_of_the_Koch_brothers | 98 |
| Holodomor | 93 |
| Libertarianism | 90 |
| Patient_Protection_and_Affordable_Care_Act | 89 |
| American_Legislative_Exchange_Council | 89 |
| Assault_weapon | 85 |
| Doctor_(Doctor_Who) | 85 |
| China/GA3 | 84 |
+----------------------------------------------+----------+
25 rows in set (1.02 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment