Jump to content

User:Ktin/sandbox/adhoc queries

From Wikipedia, the free encyclopedia

February at ITN

[edit]
mysql> select * from february_views where referer = 'Main_Page' and target in (select * from february_itn_posts) order by pageviews desc;
+-----------+----------------------------------------------------+-------+-----------+
| referer   | target                                             | type  | pageviews |
+-----------+----------------------------------------------------+-------+-----------+
| Main_Page | February_13–17,_2021_North_American_winter_storm   | other |     72876 |
| Main_Page | Porfirije,_Serbian_Patriarch                       | link  |     69357 |
| Main_Page | Super_Bowl_LV                                      | other |     57734 |
| Main_Page | Rush_Limbaugh                                      | other |     53847 |
| Main_Page | Mars_2020                                          | link  |     46817 |
| Main_Page | Ngozi_Okonjo-Iweala                                | other |     46599 |
| Main_Page | Emirates_Mars_Mission                              | other |     41683 |
| Main_Page | Second_impeachment_trial_of_Donald_Trump           | link  |     37998 |
| Main_Page | 2021_Myanmar_protests                              | link  |     35955 |
| Main_Page | Zamfara_kidnapping                                 | link  |     34484 |
| Main_Page | Tianwen-1                                          | other |     31163 |
| Main_Page | Christopher_Plummer                                | other |     29733 |
| Main_Page | Hal_Holbrook                                       | other |     28787 |
| Main_Page | Dustin_Diamond                                     | other |     27652 |
| Main_Page | Fanne_Foxe                                         | other |     25438 |
| Main_Page | Prince_Markie_Dee                                  | other |     23234 |
| Main_Page | Martha_Stewart_(actress)                           | other |     22011 |
| Main_Page | 2021_Australian_Open                               | link  |     20865 |
| Main_Page | Anthony_Sowell                                     | other |     17493 |
| Main_Page | Draghi_Cabinet                                     | other |     17425 |
| Main_Page | Carman_(singer)                                    | other |     16698 |
| Main_Page | U-Roy                                              | other |     16276 |
| Main_Page | Robert_A._Altman                                   | other |     15892 |
| Main_Page | James_Ridgeway                                     | other |     14723 |
| Main_Page | Jim_Weatherly                                      | other |     14398 |
| Main_Page | Ronald_Pickup                                      | link  |     13769 |
| Main_Page | Dianne_Durham                                      | other |     13513 |
| Main_Page | Albert_Hale                                        | other |     13325 |
| Main_Page | Heinz_Hermann_Thiele                               | other |     13125 |
| Main_Page | Doug_Wilkerson                                     | other |     12836 |
| Main_Page | Joe_Burke_(accordionist)                           | other |     12789 |
| Main_Page | Barbara_Ann_Rowan                                  | other |     12684 |
| Main_Page | Rennie_Davis                                       | other |     12406 |
| Main_Page | Rupert_Neve                                        | other |     12207 |
| Main_Page | George_Shultz                                      | other |     11914 |
| Main_Page | Đorđe_Balašević                                    | other |     11865 |
| Main_Page | Karen_Lewis                                        | other |     11451 |
| Main_Page | Enda_McDonagh                                      | other |     11309 |
| Main_Page | Lilliane_Brady                                     | other |     11161 |
| Main_Page | Lew_Krausse_Jr.                                    | other |     11141 |
| Main_Page | Raymond_Lévesque                                   | other |     11090 |
| Main_Page | James_Bishop_(artist)                              | other |     10778 |
| Main_Page | Dianna_Ortiz                                       | other |     10710 |
| Main_Page | Billy_Conigliaro                                   | other |     10709 |
| Main_Page | Clotilde_Niragira                                  | other |     10578 |
| Main_Page | Wayne_Terwilliger                                  | other |     10271 |
| Main_Page | Katherine_Creag                                    | other |     10180 |
| Main_Page | Ralph_Backstrom                                    | other |     10103 |
| Main_Page | 2021_Liechtenstein_general_election                | other |     10007 |
| Main_Page | Wolfgang_Boettcher                                 | link  |      9885 |
| Main_Page | John_Geddert                                       | other |      9871 |
| Main_Page | Lynn_Stalmaster                                    | other |      9776 |
| Main_Page | Jack_Palladino                                     | other |      9754 |
| Main_Page | Milford_Graves                                     | other |      9730 |
| Main_Page | Shlomo_Hillel                                      | other |      9697 |
| Main_Page | Marty_Schottenheimer                               | other |      9675 |
| Main_Page | Maria_Guarnaschelli                                | other |      9648 |
| Main_Page | S._Prestley_Blake                                  | other |      9600 |
| Main_Page | Emil_J._Freireich                                  | other |      9563 |
| Main_Page | Arturo_Di_Modica                                   | other |      9426 |
| Main_Page | Isadore_Singer                                     | other |      9364 |
| Main_Page | Abu_Salman_Shahjahanpuri                           | other |      9226 |
| Main_Page | Bruce_Taylor_(New_Zealand_cricketer)               | other |      8960 |
| Main_Page | Libuše_Domanínská                                  | other |      8960 |
| Main_Page | Leslie_E._Robertson                                | other |      8824 |
| Main_Page | Vera_Wülfing-Leckie                                | other |      8815 |
| Main_Page | Robert_R._Glauber                                  | other |      8150 |
| Main_Page | Bob_McCallister                                    | other |      8030 |
| Main_Page | Pedro_Gomez_(journalist)                           | other |      8026 |
| Main_Page | Jamie_Tarses                                       | other |      7991 |
| Main_Page | Douglas_Turner_Ward                                | other |      7928 |
| Main_Page | J._Hillis_Miller                                   | other |      7896 |
| Main_Page | Andrew_Brooks                                      | other |      7847 |
| Main_Page | Stan_Williams_(baseball)                           | other |      7799 |
| Main_Page | Peter_G._Davis                                     | other |      7785 |
| Main_Page | Moufida_Tlatli                                     | other |      7777 |
| Main_Page | Arne_Sorenson_(hotel_executive)                    | other |      7752 |
| Main_Page | Robert_C._Jones                                    | other |      7741 |
| Main_Page | Jerold_Ottley                                      | other |      7484 |
| Main_Page | Ahmed_Zaki_Yamani                                  | other |      7295 |
| Main_Page | Tony_Trabert                                       | other |      7144 |
| Main_Page | Charan_Gill                                        | other |      7066 |
| Main_Page | Ezra_Moseley                                       | other |      6821 |
| Main_Page | Alberto_Corazón                                    | other |      6730 |
| Main_Page | Johnny_Pacheco                                     | other |      6703 |
| Main_Page | Robert_Dean_(Canadian_politician)                  | other |      6644 |
| Main_Page | Gideon_Meir                                        | other |      6632 |
| Main_Page | D._N._Jha                                          | other |      6451 |
| Main_Page | Ruth_Dayan                                         | other |      6414 |
| Main_Page | Jean-Claude_Carrière                               | other |      6140 |
| Main_Page | Hy_Cohen                                           | other |      6132 |
| Main_Page | Raymond_Cauchetier                                 | link  |      6041 |
| Main_Page | Doug_Mountjoy                                      | other |      6002 |
| Main_Page | Gary_Halpin                                        | other |      5822 |
| Main_Page | William_Macpherson_(judge)                         | other |      5813 |
| Main_Page | Ricky_Powell                                       | other |      5768 |
| Main_Page | Millie_Hughes-Fulford                              | other |      5714 |
| Main_Page | Sinyo_Harry_Sarundajang                            | other |      5528 |
| Main_Page | Bukhari_Daud                                       | other |      5423 |
| Main_Page | Simeon_Nyachae                                     | other |      5334 |
| Main_Page | James_L._Nagle                                     | other |      5299 |
| Main_Page | Pat_Russell                                        | other |      5245 |
| Main_Page | Zachary_Wohlman                                    | other |      5063 |
| Main_Page | Ángel_Mangual                                      | other |      5057 |
| Main_Page | Maureen_Colquhoun                                  | other |      5017 |
| Main_Page | Bansi_Kaul                                         | other |      4985 |
| Main_Page | Jacqueline_Shumiatcher                             | other |      4927 |
| Main_Page | Yusriansyah_Syarkawi                               | other |      4916 |
| Main_Page | Tormod_Knutsen                                     | other |      4889 |
| Main_Page | Manfred_Gerstenfeld                                | link  |      4846 |
| Main_Page | Yurnalis_Ngayoh                                    | other |      4815 |
| Main_Page | D._Pandian                                         | link  |      4799 |
| Main_Page | Mathoor_Govindan_Kutty                             | other |      4612 |
| Main_Page | Andréa_Guiot                                       | other |      4471 |
| Main_Page | Jalaluddin_Rakhmat                                 | other |      4371 |
| Main_Page | Elliot_Mazer                                       | other |      4131 |
| Main_Page | Anne_Feeney                                        | other |      4032 |
| Main_Page | Lokman_Slim                                        | other |      3919 |
| Main_Page | M._Bala_Subramanion                                | other |      3816 |
| Main_Page | George_Benneh                                      | other |      3582 |
| Main_Page | Alberto_Oliart                                     | other |      3480 |
| Main_Page | Barry_Pashak                                       | other |      2844 |
| Main_Page | Louise_Elisabeth_Coldenhoff                        | other |      2709 |
| Main_Page | Jean_Obeid                                         | other |      2490 |
| Main_Page | Kadir_Topbaş                                       | other |      2235 |
| Main_Page | Syarifudin_Tippe                                   | other |      2142 |
| Main_Page | Johnny_Briggs_(actor)                              | link  |      2087 |
| Main_Page | Charles_McGee_(painter)                            | other |      1736 |
| Main_Page | Glenn_Roeder                                       | other |      1123 |
| Main_Page | Ng_Man-tat                                         | other |       317 |
| Main_Page | Peter_Gotti                                        | other |       194 |
| Main_Page | Yuri_Vlasov                                        | other |        48 |
| Main_Page | Tony_Collins                                       | other |        33 |
| Main_Page | John_Mallard                                       | other |        32 |
| Main_Page | Grant_Jackson                                      | other |        21 |
| Main_Page | Irving_Grundman                                    | other |        11 |
+-----------+----------------------------------------------------+-------+-----------+
136 rows in set (0.02 sec)

RD Analysis 2/23/2021

[edit]

Base Data (month of February):

[edit]
# Name In Out Time
1 Prince Markie Dee 2/19/2021 16:03 2/22/2021 19:45 75.7
2 U-Roy 2/19/2021 15:27 2/22/2021 5:55 62.5
3 Đorđe Balašević 2/20/2021 9:12 2/22/2021 23:33 62.3
4 Raymond Lévesque 2/19/2021 0:29 2/21/2021 14:26 62.0
5 Lew Krausse Jr. 2/19/2021 0:35 2/21/2021 14:28 61.9
6 Emil J. Freireich 2/4/2021 15:47:00 2/7/2021 0:00:00 56.2
7 Rupert Neve 2/15/2021 0:11:00 2/17/2021 3:14 51.0
8 Jim Weatherly 2/4/2021 23:04:00 2/7/2021 0:34:00 49.5
9 Rennie Davis 2/4/2021 23:02:00 2/7/2021 0:28:00 49.4
10 Libuše Domanínská 2/4/2021 23:00:00 2/7/2021 0:24:00 49.4
11 Milford Graves 2/14/2021 21:56:00 2/16/2021 23:04 49.1
12 S. Prestley Blake 2/15/2021 0:07:00 2/17/2021 1:10 49.0
13 J. Hillis Miller 2/15/2021 0:03:00 2/17/2021 0:58 48.9
14 Lynn Stalmaster 2/14/2021 21:54:00 2/16/2021 22:13 48.3
15 Anthony Sowell 2/11/2021 3:18:00 2/13/2021 2:42:00 47.4
16 Moufida Tlatli 2/11/2021 4:25:00 2/13/2021 3:42:00 47.3
17 Jarnail Singh 2/19/2021 15:25 2/21/2021 14:28 47.1
18 Albert Hale 2/11/2021 4:47:00 2/13/2021 3:42:00 46.9
19 Vera Wülfing-Leckie 2/11/2021 3:15:00 2/13/2021 1:30:00 46.3
20 Ron Wright (politician) 2/9/2021 1:07:00 2/10/2021 22:11:00 45.1
21 Katherine Creag 2/13/2021 4:04:00 2/14/2021 21:54:00 41.8
22 Wayne Terwilliger 2/4/2021 2:51:00 2/5/2021 20:16:00 41.4
23 Karen Lewis (labor leader) 2/9/2021 5:04:00 2/10/2021 22:23:00 41.3
24 Leslie E. Robertson 2/13/2021 3:42:00 2/14/2021 20:53:00 41.2
25 Robert R. Glauber 2/18/2021 16:23 2/20/2021 9:12 40.8
26 Abu Salman Shahjahanpuri 2/4/2021 5:32:00 2/5/2021 20:18:00 38.8
27 Billy Conigliaro 2/12/2021 3:11:00 2/13/2021 16:59:00 37.8
28 Ralph Backstrom 2/9/2021 11:29:00 2/11/2021 0:54:00 37.4
29 James Ridgeway 2/15/2021 15:38:00 2/17/2021 3:44 36.1
30 Tony Collins (footballer) 2/9/2021 10:59:00 2/10/2021 22:27:00 35.5
31 Bruce Taylor (New Zealand cricketer) 2/7/2021 16:07:00 2/9/2021 0:39:00 32.5
32 Hal Holbrook 2/2/2021 14:08:00 2/3/2021 22:34:00 32.4
33 Captain Tom 2/2/2021 16:31:00 2/3/2021 22:38:00 30.1
34 Jamie Tarses 2/2/2021 3:06:00 2/3/2021 8:40:00 29.6
35 Sinyo Harry Sarundajang 2/13/2021 16:59:00 2/14/2021 21:56:00 29.0
36 Shlomo Hillel 2/9/2021 22:26:00 2/11/2021 3:13:00 28.8
37 Dianne Durham 2/9/2021 22:36:00 2/11/2021 3:15:00 28.6
38 Isadore Singer 2/13/2021 17:20:00 2/14/2021 21:56:00 28.6
39 Robert Altman 2/5/2021 20:18:00 2/7/2021 0:43:00 28.4
40 Tony Trabert 2/5/2021 20:16:00 2/7/2021 0:38:00 28.4
41 D. N. Jha 2/7/2021 0:43:00 2/8/2021 4:57:00 28.2
42 Alberto Corazón 2/12/2021 1:38:00 2/13/2021 4:04:00 26.4
43 Yurnalis Ngayoh 2/13/2021 2:45:00 2/14/2021 5:09:00 26.4
44 Marty Schottenheimer 2/13/2021 2:42:00 2/14/2021 4:58:00 26.3
45 Andrew Brooks 2/2/2021 10:21:00 2/3/2021 11:49:00 25.5
46 Ezra Moseley 2/7/2021 23:42:00 2/9/2021 0:59:00 25.3
47 Robert C. Jones 2/7/2021 23:45:00 2/9/2021 0:51:00 25.1
48 Bansi Kaul 2/7/2021 23:38:00 2/9/2021 0:41:00 25.0
49 David Egerton 2/11/2021 0:54:00 2/12/2021 1:38:00 24.7
50 Dustin Diamond 2/3/2021 22:38:00 2/4/2021 23:00:00 24.4
51 Simeon Nyachae 2/3/2021 22:44:00 2/4/2021 23:02:00 24.3
52 Jean-Claude Carrière 2/11/2021 3:13:00 2/12/2021 3:11:00 24.0
53 Cicely Tyson 2/2/2021 10:21:00 2/3/2021 10:15:00 23.9
54 Allan Burns 2/1/2021 10:31:00 2/2/2021 10:21:00 23.8
55 Yusriansyah Syarkawi 2/18/2021 16:20 2/19/2021 16:03 23.7
56 Ruth Dayan 2/7/2021 16:06:00 2/8/2021 15:34:00 23.5
57 Jack Palladino 2/2/2021 10:24:00 2/3/2021 11:49:00 23.5
58 Sonny Fox 2/1/2021 0:13:00 2/1/2021 23:40:00 23.4
59 Bob McCallister 2/3/2021 23:43:00 2/4/2021 23:04:00 23.3
60 Mathoor Govindan Kutty 2/7/2021 0:28:00 2/7/2021 23:38:00 23.2
61 Johnny Pacheco 2/18/2021 16:16 2/19/2021 15:25 23.2
62 Robert Dean (Canadian politician) 2/7/2021 0:34:00 2/7/2021 23:42:00 23.1
63 Gideon Meir 2/18/2021 16:19 2/19/2021 15:27 23.1
64 Hy Cohen 2/7/2021 0:38:00 2/7/2021 23:45:00 23.1
65 Yury Vlasov 2/17/2021 17:14 2/18/2021 16:13 23.0
66 James L. Nagle 2/17/2021 17:21 2/18/2021 16:15 22.9
67 Andréa Guiot 2/17/2021 17:28 2/18/2021 16:19 22.8
68 Jalaluddin Rakhmat 2/17/2021 17:26 2/18/2021 16:16 22.8
69 Rush Limbaugh 2/17/2021 17:34 2/18/2021 16:23 22.8
70 Ángel Mangual 2/17/2021 17:33 2/18/2021 16:20 22.8
71 Paul Crutzen 2/1/2021 1:12:00 2/1/2021 23:43:00 22.5
72 Marc Wilmore 2/1/2021 10:31:00 2/2/2021 8:27:00 21.9
73 Pedro Gomez (journalist) 2/9/2021 0:59:00 2/9/2021 22:36:00 21.6
74 George Shultz 2/9/2021 0:51:00 2/9/2021 22:26:00 21.6
75 Lilliane Brady 2/8/2021 4:57:00 2/9/2021 0:59:00 20.0
76 [Maria Guarnaschelli 2/14/2021 4:58:00 2/15/2021 0:03:00 19.1
77 William Macpherson 2/16/2021 22:13 2/17/2021 17:14 19.0
78 Bukhari Daud 2/14/2021 5:09:00 2/15/2021 0:07:00 19.0
79 Doug Mountjoy 2/16/2021 23:03 2/17/2021 17:21 18.3
80 Alberto Oliar 2/14/2021 21:42:00 2/15/2021 15:38:00 17.9
81 Michael Murr 1/31/2021 23:37 2/1/2021 17:23:00 17.8
82 Grant Jackson 2/3/2021 11:49:00 2/4/2021 5:32:00 17.7
83 Maureen Colquhoun 2/3/2021 22:34:00 2/4/2021 15:47:00 17.2
84 BIll Hammond 2/1/2021 17:23:00 2/2/2021 10:24:00 17.0
85 Tony Momoh 2/1/2021 23:43:00 2/2/2021 16:31:00 16.8
86 Lewis Wolpert 2/1/2021 10:31:00 2/2/2021 3:06:00 16.6
87 Zachary Wohlman 2/17/2021 0:58 2/17/2021 17:28 16.5
88 Pat Russel 2/17/2021 1:10 2/17/2021 17:28 16.3
89 Millie Hughes-Fulford` 2/7/2021 0:00:00 2/7/2021 16:06:00 16.1
90 Elliot Mazer 2/13/2021 1:30:00 2/13/2021 17:20:00 15.8
91 Lokman Slim 2/7/2021 0:23:00 2/7/2021 16:07:00 15.7
92 Charan Gill 2/3/2021 11:49:00 2/4/2021 2:51:00 15.0
93 Wilhelm Knabe 2/1/2021 23:40:00 2/2/2021 14:08:00 14.5
94 George Benneh 2/17/2021 3:14 2/17/2021 17:33 14.3
95 Ricky Powell 2/3/2021 8:40:00 2/3/2021 22:44:00 14.1
96 Arne Sorenson 2/17/2021 3:44 2/17/2021 17:34 13.8
97 Jacqueline Shumiatcher 2/3/2021 10:15:00 2/3/2021 23:43:00 13.5
98 Turki bin Nasser Al Saud 1/31/2021 23:37 2/1/2021 10:31:00 10.9
99 Godfret Hodgson 1/31/2021 23:37 2/1/2021 10:31:00 10.9
100 Constance Isherwood 1/31/2021 23:37 2/1/2021 10:31:00 10.9
101 Dick Callahan 1/31/2021 23:37 2/1/2021 10:31:00 10.9
102 Barry Pashak 2/9/2021 0:45:00 2/9/2021 11:29:00 10.7
103 Anne Feeney 2/9/2021 0:41:00 2/9/2021 10:59:00 10.3
104 Christopher Plummer 2/8/2021 15:34:00 2/9/2021 1:07:00 9.6
105 Syarifudin Tippe 2/18/2021 16:15 2/19/2021 0:35 8.3
106 Kadir Topbaş 2/18/2021 16:13 2/19/2021 0:29 8.3
107 Jean Obeid 2/10/2021 22:27:00 2/11/2021 4:47:00 6.3
108 Louise Elisabeth Coldenhoff 2/10/2021 22:23:00 2/11/2021 4:25:00 6.0
109 M. Bala Subramanion 2/10/2021 22:11:00 2/11/2021 3:18:00 5.1
110 Charles McGee (painter) 2/9/2021 0:39:00 2/9/2021 5:04:00 4.4
Average time Top 25% 49.6
Average time Bottom 25% 12.5
Average (all) 27.7

Scenario 1: Institute a holding pattern

[edit]

Note: An extremely conservative approach has been used here for this simulation. For the purposes of this simulation, specifically to calculate the revised 'in time', I have taken the time that the next timestamp when an RD post was made by an Admin after 24 hours (even if is 48 hours after). In reality, the scenario will smoothen out closer to 24 hours, since at least one admin will login in on a given day. Unlikely that you will have a day when not a single Admin will log in / post to main page.

# Name Original In Original Out Time Spent Revised In Revised Out Revised Time
1 Bukhari Daud 2/14/2021 5:09:00 2/15/2021 0:07:00 19.0 2/14/2021 5:09:00 2/16/2021 22:13 65.1
2 Rupert Neve 2/15/2021 0:11:00 2/17/2021 3:14 51.0 2/16/2021 22:13 2/18/2021 16:13 42.0
3 Leslie E. Robertson 2/13/2021 3:42:00 2/14/2021 20:53:00 41.2 2/13/2021 3:42:00 2/14/2021 20:53:00 41.2
4 James Ridgeway 2/15/2021 15:38:00 2/17/2021 3:44 36.1 2/16/2021 23:03 2/18/2021 16:13 41.2
5 William Macpherson 2/16/2021 22:13 2/17/2021 17:14 19.0 2/16/2021 23:03 2/18/2021 16:13 41.2
6 Doug Mountjoy 2/16/2021 23:03 2/17/2021 17:21 18.3 2/16/2021 23:03 2/18/2021 16:13 41.2
7 Zachary Wohlman 2/17/2021 0:58 2/17/2021 17:28 16.5 2/17/2021 0:58 2/18/2021 16:13 39.2
8 Pat Russel 2/17/2021 1:10 2/17/2021 17:28 16.3 2/17/2021 1:10 2/18/2021 16:13 39.0
9 Jacqueline Shumiatcher 2/3/2021 10:15:00 2/3/2021 23:43:00 13.5 2/4/2021 5:32:00 2/5/2021 20:16:00 38.7
10 Charan Gill 2/3/2021 11:49:00 2/4/2021 2:51:00 15.0 2/4/2021 5:32:00 2/5/2021 20:16:00 38.7
11 Grant Jackson 2/3/2021 11:49:00 2/4/2021 5:32:00 17.7 2/4/2021 5:32:00 2/5/2021 20:16:00 38.7
12 Maureen Colquhoun 2/3/2021 22:34:00 2/4/2021 15:47:00 17.2 2/4/2021 5:32:00 2/5/2021 20:16:00 38.7
13 Dustin Diamond 2/3/2021 22:38:00 2/4/2021 23:00:00 24.4 2/4/2021 5:32:00 2/5/2021 20:16:00 38.7
14 U-Roy 2/19/2021 15:27 2/22/2021 5:55 62.5 2/20/2021 17:08 2/22/2021 5:55 36.8
15 Katherine Creag 2/13/2021 4:04:00 2/14/2021 21:54:00 41.8 2/14/2021 4:58:00 2/15/2021 15:38:00 34.7
16 Sinyo Harry Sarundajang 2/13/2021 16:59:00 2/14/2021 21:56:00 29.0 2/14/2021 4:58:00 2/15/2021 15:38:00 34.7
17 Isadore Singer 2/13/2021 17:20:00 2/14/2021 21:56:00 28.6 2/14/2021 4:58:00 2/15/2021 15:38:00 34.7
18 [Maria Guarnaschelli 2/14/2021 4:58:00 2/15/2021 0:03:00 19.1 2/14/2021 4:58:00 2/15/2021 15:38:00 34.7
19 S. Prestley Blake 2/15/2021 0:07:00 2/17/2021 1:10 49.0 2/15/2021 15:38:00 2/17/2021 1:10 33.5
20 J. Hillis Miller 2/15/2021 0:03:00 2/17/2021 0:58 48.9 2/15/2021 15:38:00 2/17/2021 0:58 33.3
21 Lewis Wolpert 2/1/2021 10:31:00 2/2/2021 3:06:00 16.6 2/1/2021 23:40:00 2/3/2021 8:40:00 33.0
22 Marc Wilmore 2/1/2021 10:31:00 2/2/2021 8:27:00 21.9 2/1/2021 23:40:00 2/3/2021 8:40:00 33.0
23 Allan Burns 2/1/2021 10:31:00 2/2/2021 10:21:00 23.8 2/1/2021 23:40:00 2/3/2021 8:40:00 33.0
24 BIll Hammond 2/1/2021 17:23:00 2/2/2021 10:24:00 17.0 2/1/2021 23:40:00 2/3/2021 8:40:00 33.0
25 Wilhelm Knabe 2/1/2021 23:40:00 2/2/2021 14:08:00 14.5 2/1/2021 23:40:00 2/3/2021 8:40:00 33.0
26 Tony Momoh 2/1/2021 23:43:00 2/2/2021 16:31:00 16.8 2/1/2021 23:43:00 2/3/2021 8:40:00 33.0
27 Alberto Oliar 2/14/2021 21:42:00 2/15/2021 15:38:00 17.9 2/15/2021 15:38:00 2/16/2021 23:03 31.4
28 Lynn Stalmaster 2/14/2021 21:54:00 2/16/2021 22:13 48.3 2/15/2021 15:38:00 2/16/2021 23:03 31.4
29 Milford Graves 2/14/2021 21:56:00 2/16/2021 23:04 49.1 2/15/2021 15:38:00 2/16/2021 23:03 31.4
30 Ricky Powell 2/3/2021 8:40:00 2/3/2021 22:44:00 14.1 2/3/2021 8:40:00 2/4/2021 15:47:00 31.1
31 Yusriansyah Syarkawi 2/18/2021 16:20 2/19/2021 16:03 23.7 2/20/2021 17:08 2/21/2021 23:44 30.6
32 Robert R. Glauber 2/18/2021 16:23 2/20/2021 9:12 40.8 2/20/2021 17:08 2/21/2021 23:44 30.6
33 Raymond Lévesque 2/19/2021 0:29 2/21/2021 14:26 62.0 2/20/2021 17:08 2/21/2021 23:44 30.6
34 Lew Krausse Jr. 2/19/2021 0:35 2/21/2021 14:28 61.9 2/20/2021 17:08 2/21/2021 23:44 30.6
35 Jarnail Singh 2/19/2021 15:25 2/21/2021 14:28 47.1 2/20/2021 17:08 2/21/2021 23:44 30.6
36 Simeon Nyachae 2/3/2021 22:44:00 2/4/2021 23:02:00 24.3 2/4/2021 15:47:00 2/5/2021 20:16:00 28.5
37 Rennie Davis 2/4/2021 23:02:00 2/7/2021 0:28:00 49.4 2/5/2021 20:16:00 2/7/2021 0:28:00 28.2
38 Libuše Domanínská 2/4/2021 23:00:00 2/7/2021 0:24:00 49.4 2/5/2021 20:16:00 2/7/2021 0:23:00 28.1
39 Bob McCallister 2/3/2021 23:43:00 2/4/2021 23:04:00 23.3 2/5/2021 20:16:00 2/7/2021 0:00:00 27.7
40 Wayne Terwilliger 2/4/2021 2:51:00 2/5/2021 20:16:00 41.4 2/5/2021 20:16:00 2/7/2021 0:00:00 27.7
41 Abu Salman Shahjahanpuri 2/4/2021 5:32:00 2/5/2021 20:18:00 38.8 2/5/2021 20:16:00 2/7/2021 0:00:00 27.7
42 Emil J. Freireich 2/4/2021 15:47:00 2/7/2021 0:00:00 56.2 2/5/2021 20:16:00 2/7/2021 0:00:00 27.7
43 Alberto Corazón 2/12/2021 1:38:00 2/13/2021 4:04:00 26.4 2/13/2021 1:30:00 2/14/2021 4:58:00 27.5
44 Billy Conigliaro 2/12/2021 3:11:00 2/13/2021 16:59:00 37.8 2/13/2021 1:30:00 2/14/2021 4:58:00 27.5
45 Elliot Mazer 2/13/2021 1:30:00 2/13/2021 17:20:00 15.8 2/13/2021 1:30:00 2/14/2021 4:58:00 27.5
46 Ralph Backstrom 2/9/2021 11:29:00 2/11/2021 0:54:00 37.4 2/10/2021 22:11:00 2/12/2021 1:38:00 27.5
47 Shlomo Hillel 2/9/2021 22:26:00 2/11/2021 3:13:00 28.8 2/10/2021 22:11:00 2/12/2021 1:38:00 27.5
48 Dianne Durham 2/9/2021 22:36:00 2/11/2021 3:15:00 28.6 2/10/2021 22:11:00 2/12/2021 1:38:00 27.5
49 M. Bala Subramanion 2/10/2021 22:11:00 2/11/2021 3:18:00 5.1 2/10/2021 22:11:00 2/12/2021 1:38:00 27.5
50 Louise Elisabeth Coldenhoff 2/10/2021 22:23:00 2/11/2021 4:25:00 6.0 2/10/2021 22:23:00 2/12/2021 1:38:00 27.3
51 Jean Obeid 2/10/2021 22:27:00 2/11/2021 4:47:00 6.3 2/10/2021 22:27:00 2/12/2021 1:38:00 27.2
52 Yurnalis Ngayoh 2/13/2021 2:45:00 2/14/2021 5:09:00 26.4 2/13/2021 2:45:00 2/14/2021 5:09:00 26.4
53 Marty Schottenheimer 2/13/2021 2:42:00 2/14/2021 4:58:00 26.3 2/13/2021 2:42:00 2/14/2021 4:58:00 26.3
54 Albert Hale 2/11/2021 4:47:00 2/13/2021 3:42:00 46.9 2/12/2021 1:38:00 2/13/2021 3:42:00 26.1
55 Ángel Mangual 2/17/2021 17:33 2/18/2021 16:20 22.8 2/19/2021 15:25 2/20/2021 17:08 25.7
56 Rush Limbaugh 2/17/2021 17:34 2/18/2021 16:23 22.8 2/19/2021 15:25 2/20/2021 17:08 25.7
57 Kadir Topbaş 2/18/2021 16:13 2/19/2021 0:29 8.3 2/19/2021 15:25 2/20/2021 17:08 25.7
58 Syarifudin Tippe 2/18/2021 16:15 2/19/2021 0:35 8.3 2/19/2021 15:25 2/20/2021 17:08 25.7
59 Johnny Pacheco 2/18/2021 16:16 2/19/2021 15:25 23.2 2/19/2021 15:25 2/20/2021 17:08 25.7
60 Gideon Meir 2/18/2021 16:19 2/19/2021 15:27 23.1 2/19/2021 15:25 2/20/2021 17:08 25.7
61 Moufida Tlatli 2/11/2021 4:25:00 2/13/2021 3:42:00 47.3 2/12/2021 1:38:00 2/13/2021 2:45:00 25.1
62 Anthony Sowell 2/11/2021 3:18:00 2/13/2021 2:42:00 47.4 2/12/2021 1:38:00 2/13/2021 2:42:00 25.1
63 Bansi Kaul 2/7/2021 23:38:00 2/9/2021 0:41:00 25.0 2/7/2021 23:38:00 2/9/2021 0:41:00 25.0
64 Robert Dean (Canadian politician) 2/7/2021 0:34:00 2/7/2021 23:42:00 23.1 2/7/2021 23:38:00 2/9/2021 0:39:00 25.0
65 Hy Cohen 2/7/2021 0:38:00 2/7/2021 23:45:00 23.1 2/7/2021 23:38:00 2/9/2021 0:39:00 25.0
66 D. N. Jha 2/7/2021 0:43:00 2/8/2021 4:57:00 28.2 2/7/2021 23:38:00 2/9/2021 0:39:00 25.0
67 Ruth Dayan 2/7/2021 16:06:00 2/8/2021 15:34:00 23.5 2/7/2021 23:38:00 2/9/2021 0:39:00 25.0
68 Bruce Taylor (New Zealand cricketer) 2/7/2021 16:07:00 2/9/2021 0:39:00 32.5 2/7/2021 23:38:00 2/9/2021 0:39:00 25.0
69 Turki bin Nasser Al Saud 1/31/2021 23:37 2/1/2021 10:31:00 10.9 1/31/2021 23:37 2/1/2021 23:40:00 24.0
70 Godfret Hodgson 1/31/2021 23:37 2/1/2021 10:31:00 10.9 1/31/2021 23:37 2/1/2021 23:40:00 24.0
71 Constance Isherwood 1/31/2021 23:37 2/1/2021 10:31:00 10.9 1/31/2021 23:37 2/1/2021 23:40:00 24.0
72 Dick Callahan 1/31/2021 23:37 2/1/2021 10:31:00 10.9 1/31/2021 23:37 2/1/2021 23:40:00 24.0
73 Michael Murr 1/31/2021 23:37 2/1/2021 17:23:00 17.8 1/31/2021 23:37 2/1/2021 23:40:00 24.0
74 David Egerton 2/11/2021 0:54:00 2/12/2021 1:38:00 24.7 2/12/2021 1:38:00 2/13/2021 1:30:00 23.9
75 Jean-Claude Carrière 2/11/2021 3:13:00 2/12/2021 3:11:00 24.0 2/12/2021 1:38:00 2/13/2021 1:30:00 23.9
76 Vera Wülfing-Leckie 2/11/2021 3:15:00 2/13/2021 1:30:00 46.3 2/12/2021 1:38:00 2/13/2021 1:30:00 23.9
77 Tony Collins (footballer) 2/9/2021 10:59:00 2/10/2021 22:27:00 35.5 2/9/2021 22:36:00 2/10/2021 22:27:00 23.9
78 Đorđe Balašević 2/20/2021 9:12 2/22/2021 23:33 62.3 2/21/2021 23:44 2/22/2021 23:33 23.8
79 Karen Lewis (labor leader) 2/9/2021 5:04:00 2/10/2021 22:23:00 41.3 2/9/2021 22:36:00 2/10/2021 22:23:00 23.8
80 Jim Weatherly 2/4/2021 23:04:00 2/7/2021 0:34:00 49.5 2/7/2021 0:00:00 2/7/2021 23:38:00 23.6
81 Tony Trabert 2/5/2021 20:16:00 2/7/2021 0:38:00 28.4 2/7/2021 0:00:00 2/7/2021 23:38:00 23.6
82 Robert Altman 2/5/2021 20:18:00 2/7/2021 0:43:00 28.4 2/7/2021 0:00:00 2/7/2021 23:38:00 23.6
83 Millie Hughes-Fulford` 2/7/2021 0:00:00 2/7/2021 16:06:00 16.1 2/7/2021 0:00:00 2/7/2021 23:38:00 23.6
84 Barry Pashak 2/9/2021 0:45:00 2/9/2021 11:29:00 10.7 2/9/2021 22:36:00 2/10/2021 22:11:00 23.6
85 George Shultz 2/9/2021 0:51:00 2/9/2021 22:26:00 21.6 2/9/2021 22:36:00 2/10/2021 22:11:00 23.6
86 Pedro Gomez (journalist) 2/9/2021 0:59:00 2/9/2021 22:36:00 21.6 2/9/2021 22:36:00 2/10/2021 22:11:00 23.6
87 Ron Wright (politician) 2/9/2021 1:07:00 2/10/2021 22:11:00 45.1 2/9/2021 22:36:00 2/10/2021 22:11:00 23.6
88 Sonny Fox 2/1/2021 0:13:00 2/1/2021 23:40:00 23.4 2/1/2021 0:13:00 2/1/2021 23:40:00 23.4
89 Lokman Slim 2/7/2021 0:23:00 2/7/2021 16:07:00 15.7 2/7/2021 0:23:00 2/7/2021 23:38:00 23.3
90 George Benneh 2/17/2021 3:14 2/17/2021 17:33 14.3 2/18/2021 16:13 2/19/2021 15:25 23.2
91 Arne Sorenson 2/17/2021 3:44 2/17/2021 17:34 13.8 2/18/2021 16:13 2/19/2021 15:25 23.2
92 Yury Vlasov 2/17/2021 17:14 2/18/2021 16:13 23.0 2/18/2021 16:13 2/19/2021 15:25 23.2
93 James L. Nagle 2/17/2021 17:21 2/18/2021 16:15 22.9 2/18/2021 16:13 2/19/2021 15:25 23.2
94 Jalaluddin Rakhmat 2/17/2021 17:26 2/18/2021 16:16 22.8 2/18/2021 16:13 2/19/2021 15:25 23.2
95 Andréa Guiot 2/17/2021 17:28 2/18/2021 16:19 22.8 2/18/2021 16:13 2/19/2021 15:25 23.2
96 Mathoor Govindan Kutty 2/7/2021 0:28:00 2/7/2021 23:38:00 23.2 2/7/2021 0:28:00 2/7/2021 23:38:00 23.2
97 Paul Crutzen 2/1/2021 1:12:00 2/1/2021 23:43:00 22.5 2/1/2021 1:12:00 2/1/2021 23:43:00 22.5
98 Ezra Moseley 2/7/2021 23:42:00 2/9/2021 0:59:00 25.3 2/9/2021 0:39:00 2/9/2021 22:36:00 21.9
99 Robert C. Jones 2/7/2021 23:45:00 2/9/2021 0:51:00 25.1 2/9/2021 0:39:00 2/9/2021 22:36:00 21.9
100 Lilliane Brady 2/8/2021 4:57:00 2/9/2021 0:59:00 20.0 2/9/2021 0:39:00 2/9/2021 22:36:00 21.9
101 Christopher Plummer 2/8/2021 15:34:00 2/9/2021 1:07:00 9.6 2/9/2021 0:39:00 2/9/2021 22:36:00 21.9
102 Charles McGee (painter) 2/9/2021 0:39:00 2/9/2021 5:04:00 4.4 2/9/2021 0:39:00 2/9/2021 22:36:00 21.9
103 Anne Feeney 2/9/2021 0:41:00 2/9/2021 10:59:00 10.3 2/9/2021 0:41:00 2/9/2021 22:36:00 21.9
104 Jamie Tarses 2/2/2021 3:06:00 2/3/2021 8:40:00 29.6 2/3/2021 8:40:00 2/4/2021 5:32:00 20.9
105 Cicely Tyson 2/2/2021 10:21:00 2/3/2021 10:15:00 23.9 2/3/2021 8:40:00 2/4/2021 5:32:00 20.9
106 Jack Palladino 2/2/2021 10:24:00 2/3/2021 11:49:00 23.5 2/3/2021 8:40:00 2/4/2021 5:32:00 20.9
107 Andrew Brooks 2/2/2021 10:21:00 2/3/2021 11:49:00 25.5 2/3/2021 8:40:00 2/4/2021 5:32:00 20.9
108 Hal Holbrook 2/2/2021 14:08:00 2/3/2021 22:34:00 32.4 2/3/2021 8:40:00 2/4/2021 5:32:00 20.9
109 Captain Tom 2/2/2021 16:31:00 2/3/2021 22:38:00 30.1 2/3/2021 8:40:00 2/4/2021 5:32:00 20.9
110 Prince Markie Dee 2/19/2021 16:03 2/22/2021 19:45 75.7 2/21/2021 23:44 2/22/2021 19:45 20.0
Average time Top 25% 37.4
Average time Bottom 25% 22.5
Average (all) 28.2

Scenario 2: Spill over to maximize row 2 / row 3

[edit]

Work in progress


ITN Articles - January

[edit]
mysql> select * from january_views where referer = 'Main_Page' and target in (select * from january_itn_posts) order by pageviews desc;
+-----------+---------------------------------------------------+-------+-----------+
| referer   | target                                            | type  | pageviews |
+-----------+---------------------------------------------------+-------+-----------+
| Main_Page | 2021_storming_of_the_United_States_Capitol        | other |    362005 |
| Main_Page | COVID-19_pandemic                                 | link  |    160445 |
| Main_Page | Second_impeachment_of_Donald_Trump                | other |    146932 |
| Main_Page | Sriwijaya_Air_Flight_182                          | other |    136632 |
| Main_Page | Kaja_Kallas                                       | link  |    136173 |
| Main_Page | GameStop_short_squeeze                            | link  |    111034 |
| Main_Page | Dutch_childcare_benefits_scandal                  | other |     80215 |
| Main_Page | 2020–2021_Indian_farmers'_protest                 | link  |     79214 |
| Main_Page | 2021_Russian_protests                             | link  |     70602 |
| Main_Page | Hank_Aaron                                        | other |     68949 |
| Main_Page | LauncherOne                                       | other |     51163 |
| Main_Page | 2020_Aden_attacks                                 | other |     49503 |
| Main_Page | Mother_and_Baby_Homes_Commission_of_Investigation | other |     48130 |
| Main_Page | 2020_United_States_Senate_elections               | other |     47700 |
| Main_Page | Tanya_Roberts                                     | other |     43506 |
| Main_Page | Larry_King                                        | other |     42073 |
| Main_Page | 2020_Gjerdrum_landslide                           | other |     31031 |
| Main_Page | Qatar_diplomatic_crisis                           | other |     27923 |
| Main_Page | Michael_Apted                                     | other |     24832 |
| Main_Page | EU–UK_Trade_and_Cooperation_Agreement             | other |     24803 |
| Main_Page | Sophie_(musician)                                 | other |     22494 |
| Main_Page | Benjamin_de_Rothschild                            | other |     22204 |
| Main_Page | 2021_Sulawesi_earthquake                          | other |     21246 |
| Main_Page | 2021_Ugandan_general_election                     | other |     19442 |
| Main_Page | Sheldon_Adelson                                   | other |     18705 |
| Main_Page | Neil_Sheehan                                      | other |     18509 |
| Main_Page | Colin_Bell                                        | other |     17180 |
| Main_Page | Don_Sutton                                        | other |     15738 |
| Main_Page | Katharine_Whitehorn                               | other |     15255 |
| Main_Page | Tigray_War                                        | other |     15007 |
| Main_Page | Corky_Lee                                         | other |     14923 |
| Main_Page | George_Armstrong_(ice_hockey)                     | other |     13891 |
| Main_Page | Dustin_Higgs                                      | other |     13873 |
| Main_Page | 2020_Petrinja_earthquake                          | other |     13863 |
| Main_Page | Kathleen_Heddle                                   | other |     13852 |
| Main_Page | Albert_Roux                                       | other |     13812 |
| Main_Page | Shingoose                                         | other |     13399 |
| Main_Page | La_Vega_raid                                      | other |     13267 |
| Main_Page | Osian_Ellis                                       | other |     13254 |
| Main_Page | Gerry_Marsden                                     | other |     13187 |
| Main_Page | Nilda_Pedrosa                                     | other |     13001 |
| Main_Page | Tommy_Lasorda                                     | other |     12904 |
| Main_Page | Tommy_Docherty                                    | other |     12705 |
| Main_Page | 2020–21_Central_African_general_election          | other |     12645 |
| Main_Page | James_Cross                                       | other |     12540 |
| Main_Page | Luton_Shelton                                     | other |     12489 |
| Main_Page | Robert_Rowland                                    | other |     12085 |
| Main_Page | Kay_Ullrich                                       | other |     12054 |
| Main_Page | Walter_Bernstein                                  | other |     11918 |
| Main_Page | Elena_Santiago                                    | other |     11369 |
| Main_Page | Peter_Thorburn                                    | other |     11058 |
| Main_Page | Nathalie_Delon                                    | other |     10955 |
| Main_Page | Xu_Qinxian                                        | other |     10895 |
| Main_Page | Chris_Cramer                                      | other |     10558 |
| Main_Page | Wilberforce_Kisamba_Mugerwa                       | other |     10420 |
| Main_Page | Deborah_Rhode                                     | other |     10413 |
| Main_Page | Pag-asa_(eagle)                                   | other |     10343 |
| Main_Page | Mira_Furlan                                       | other |     10260 |
| Main_Page | David_Washbrook                                   | other |     10179 |
| Main_Page | Sammy_Nestico                                     | other |     10151 |
| Main_Page | Sibusiso_Moyo                                     | other |     10089 |
| Main_Page | Tom_Acker                                         | other |      9956 |
| Main_Page | Bob_Brett                                         | other |      9734 |
| Main_Page | Mauricio_Herdocia_Sacasa                          | other |      9679 |
| Main_Page | Sayidiman_Suryohadiprojo                          | other |      9653 |
| Main_Page | Elmira_Minita_Gordon                              | other |      9643 |
| Main_Page | Bryan_Monroe                                      | other |      9620 |
| Main_Page | Alex_Apolinário                                   | other |      9596 |
| Main_Page | Grace_Robertson                                   | other |      9548 |
| Main_Page | Floyd_Little                                      | other |      9517 |
| Main_Page | Cicely_Tyson                                      | other |      9453 |
| Main_Page | Gerry_Cottle                                      | other |      9425 |
| Main_Page | Christopher_Maboulou                              | other |      9418 |
| Main_Page | Joël_Robert                                       | other |      9335 |
| Main_Page | Arik_Brauer                                       | other |      9323 |
| Main_Page | Gordon_"Butch"_Stewart                            | other |      9319 |
| Main_Page | Brian_Urquhart                                    | other |      9305 |
| Main_Page | Barbara_Shelley                                   | other |      9265 |
| Main_Page | Philip_Tartaglia                                  | other |      9258 |
| Main_Page | Gord_Renwick                                      | other |      9139 |
| Main_Page | Biserka_Cvejić                                    | other |      9002 |
| Main_Page | Maxine_Cheshire                                   | other |      8871 |
| Main_Page | Beatriz_Barba                                     | other |      8779 |
| Main_Page | Marielle_de_Sarnez                                | other |      8760 |
| Main_Page | Hank_Adams                                        | other |      8360 |
| Main_Page | Juan_Carlos_Copes                                 | other |      8281 |
| Main_Page | Dave_Bolton                                       | other |      8221 |
| Main_Page | Ali_Taher                                         | other |      8074 |
| Main_Page | Agitu_Ideo_Gudeta                                 | other |      7863 |
| Main_Page | Juan_Guzmán_Tapia                                 | other |      7559 |
| Main_Page | Beddu_Amang                                       | other |      7532 |
| Main_Page | Salleh_Abas                                       | other |      7249 |
| Main_Page | F._X._Sudjasmin                                   | other |      7119 |
| Main_Page | Seyoum_Mesfin                                     | other |      6937 |
| Main_Page | Abel_Gabuza                                       | other |      6807 |
| Main_Page | Joseph_Sonnabend                                  | other |      6796 |
| Main_Page | Meherzia_Labidi_Maïza                             | other |      6635 |
| Main_Page | Mulyadi_Tamsir                                    | other |      6628 |
| Main_Page | Ndubuisi_Kanu                                     | other |      6584 |
| Main_Page | Roy_B._B._Janis                                   | other |      6518 |
| Main_Page | Flavio_Alfaro                                     | other |      6477 |
| Main_Page | Sibongile_Khumalo                                 | other |      6460 |
| Main_Page | Aslan_Byutukayev                                  | other |      6396 |
| Main_Page | Jubril_Martins-Kuye                               | other |      6339 |
| Main_Page | Pungky_Purnomo_Wibowo                             | other |      6259 |
| Main_Page | Roy_Torrens                                       | other |      6254 |
| Main_Page | M._R._Schunker                                    | other |      5722 |
| Main_Page | Subiakto_Tjakrawerdaya                            | other |      5582 |
| Main_Page | Shaibal_Gupta                                     | other |      5483 |
| Main_Page | Alex_Asmasoebrata                                 | other |      5176 |
| Main_Page | Paul_Westphal                                     | other |      5151 |
| Main_Page | Muladi                                            | other |      5048 |
| Main_Page | Great_conjunction                                 | other |      4825 |
| Main_Page | Sjarifuddin_Baharsjah                             | other |      4703 |
| Main_Page | Gatot_Sudjito                                     | other |      4658 |
| Main_Page | Lorraine_Monk                                     | other |      4268 |
| Main_Page | Sharon_Begley                                     | other |      3831 |
| Main_Page | Margaret_Weston                                   | other |      3811 |
| Main_Page | Paige_Rense                                       | other |      3198 |
| Main_Page | John_Baptist_Kaggwa                               | other |      3026 |
| Main_Page | V._Shanta                                         | other |      2817 |
| Main_Page | Pierantonio_Costa                                 | other |      2768 |
| Main_Page | James_D._Heiple                                   | other |      2651 |
| Main_Page | Carlos_do_Carmo                                   | other |      2603 |
| Main_Page | Turki_bin_Nasser_Al_Saud                          | link  |       215 |
| Main_Page | Michel_Murr                                       | link  |       208 |
| Main_Page | Dick_Callahan                                     | link  |       189 |
| Main_Page | Constance_Isherwood                               | link  |       178 |
| Main_Page | Godfrey_Hodgson                                   | link  |       163 |
| Main_Page | Ron_Johnson                                       | other |       148 |
| Main_Page | Sonny_Fox                                         | link  |       130 |
| Main_Page | John_Chaney                                       | other |       107 |
| Main_Page | Lewis_Wolpert                                     | other |        29 |
| Main_Page | Marc_Wilmore                                      | other |        10 |
| Main_Page | Allan_Burns                                       | other |        10 |
+-----------+---------------------------------------------------+-------+-----------+
135 rows in set (0.08 sec)

ITN RD Articles - January

[edit]
mysql> select * from january_views where referer = 'Main_Page' and target in (select * from january_itn_posts_rd) order by pageviews desc;
+-----------+-------------------------------+-------+-----------+
| referer   | target                        | type  | pageviews |
+-----------+-------------------------------+-------+-----------+
| Main_Page | Hank_Aaron                    | other |     68949 |
| Main_Page | Tanya_Roberts                 | other |     43506 |
| Main_Page | Larry_King                    | other |     42073 |
| Main_Page | Michael_Apted                 | other |     24832 |
| Main_Page | Sophie_(musician)             | other |     22494 |
| Main_Page | Benjamin_de_Rothschild        | other |     22204 |
| Main_Page | Sheldon_Adelson               | other |     18705 |
| Main_Page | Neil_Sheehan                  | other |     18509 |
| Main_Page | Colin_Bell                    | other |     17180 |
| Main_Page | Don_Sutton                    | other |     15738 |
| Main_Page | Katharine_Whitehorn           | other |     15255 |
| Main_Page | Corky_Lee                     | other |     14923 |
| Main_Page | George_Armstrong_(ice_hockey) | other |     13891 |
| Main_Page | Dustin_Higgs                  | other |     13873 |
| Main_Page | Kathleen_Heddle               | other |     13852 |
| Main_Page | Albert_Roux                   | other |     13812 |
| Main_Page | Shingoose                     | other |     13399 |
| Main_Page | Osian_Ellis                   | other |     13254 |
| Main_Page | Gerry_Marsden                 | other |     13187 |
| Main_Page | Nilda_Pedrosa                 | other |     13001 |
| Main_Page | Tommy_Lasorda                 | other |     12904 |
| Main_Page | Tommy_Docherty                | other |     12705 |
| Main_Page | James_Cross                   | other |     12540 |
| Main_Page | Luton_Shelton                 | other |     12489 |
| Main_Page | Robert_Rowland                | other |     12085 |
| Main_Page | Kay_Ullrich                   | other |     12054 |
| Main_Page | Walter_Bernstein              | other |     11918 |
| Main_Page | Elena_Santiago                | other |     11369 |
| Main_Page | Peter_Thorburn                | other |     11058 |
| Main_Page | Nathalie_Delon                | other |     10955 |
| Main_Page | Xu_Qinxian                    | other |     10895 |
| Main_Page | Chris_Cramer                  | other |     10558 |
| Main_Page | Wilberforce_Kisamba_Mugerwa   | other |     10420 |
| Main_Page | Deborah_Rhode                 | other |     10413 |
| Main_Page | Pag-asa_(eagle)               | other |     10343 |
| Main_Page | Mira_Furlan                   | other |     10260 |
| Main_Page | David_Washbrook               | other |     10179 |
| Main_Page | Sammy_Nestico                 | other |     10151 |
| Main_Page | Sibusiso_Moyo                 | other |     10089 |
| Main_Page | Tom_Acker                     | other |      9956 |
| Main_Page | Bob_Brett                     | other |      9734 |
| Main_Page | Mauricio_Herdocia_Sacasa      | other |      9679 |
| Main_Page | Sayidiman_Suryohadiprojo      | other |      9653 |
| Main_Page | Elmira_Minita_Gordon          | other |      9643 |
| Main_Page | Bryan_Monroe                  | other |      9620 |
| Main_Page | Alex_Apolinário               | other |      9596 |
| Main_Page | Grace_Robertson               | other |      9548 |
| Main_Page | Floyd_Little                  | other |      9517 |
| Main_Page | Cicely_Tyson                  | other |      9453 |
| Main_Page | Gerry_Cottle                  | other |      9425 |
| Main_Page | Christopher_Maboulou          | other |      9418 |
| Main_Page | Joël_Robert                   | other |      9335 |
| Main_Page | Arik_Brauer                   | other |      9323 |
| Main_Page | Gordon_"Butch"_Stewart        | other |      9319 |
| Main_Page | Brian_Urquhart                | other |      9305 |
| Main_Page | Barbara_Shelley               | other |      9265 |
| Main_Page | Philip_Tartaglia              | other |      9258 |
| Main_Page | Gord_Renwick                  | other |      9139 |
| Main_Page | Biserka_Cvejić                | other |      9002 |
| Main_Page | Maxine_Cheshire               | other |      8871 |
| Main_Page | Beatriz_Barba                 | other |      8779 |
| Main_Page | Marielle_de_Sarnez            | other |      8760 |
| Main_Page | Hank_Adams                    | other |      8360 |
| Main_Page | Juan_Carlos_Copes             | other |      8281 |
| Main_Page | Dave_Bolton                   | other |      8221 |
| Main_Page | Ali_Taher                     | other |      8074 |
| Main_Page | Agitu_Ideo_Gudeta             | other |      7863 |
| Main_Page | Juan_Guzmán_Tapia             | other |      7559 |
| Main_Page | Beddu_Amang                   | other |      7532 |
| Main_Page | Salleh_Abas                   | other |      7249 |
| Main_Page | F._X._Sudjasmin               | other |      7119 |
| Main_Page | Seyoum_Mesfin                 | other |      6937 |
| Main_Page | Abel_Gabuza                   | other |      6807 |
| Main_Page | Joseph_Sonnabend              | other |      6796 |
| Main_Page | Meherzia_Labidi_Maïza         | other |      6635 |
| Main_Page | Mulyadi_Tamsir                | other |      6628 |
| Main_Page | Ndubuisi_Kanu                 | other |      6584 |
| Main_Page | Roy_B._B._Janis               | other |      6518 |
| Main_Page | Flavio_Alfaro                 | other |      6477 |
| Main_Page | Sibongile_Khumalo             | other |      6460 |
| Main_Page | Aslan_Byutukayev              | other |      6396 |
| Main_Page | Jubril_Martins-Kuye           | other |      6339 |
| Main_Page | Pungky_Purnomo_Wibowo         | other |      6259 |
| Main_Page | Roy_Torrens                   | other |      6254 |
| Main_Page | M._R._Schunker                | other |      5722 |
| Main_Page | Subiakto_Tjakrawerdaya        | other |      5582 |
| Main_Page | Shaibal_Gupta                 | other |      5483 |
| Main_Page | Alex_Asmasoebrata             | other |      5176 |
| Main_Page | Paul_Westphal                 | other |      5151 |
| Main_Page | Muladi                        | other |      5048 |
| Main_Page | Sjarifuddin_Baharsjah         | other |      4703 |
| Main_Page | Gatot_Sudjito                 | other |      4658 |
| Main_Page | Lorraine_Monk                 | other |      4268 |
| Main_Page | Sharon_Begley                 | other |      3831 |
| Main_Page | Margaret_Weston               | other |      3811 |
| Main_Page | Paige_Rense                   | other |      3198 |
| Main_Page | John_Baptist_Kaggwa           | other |      3026 |
| Main_Page | V._Shanta                     | other |      2817 |
| Main_Page | Pierantonio_Costa             | other |      2768 |
| Main_Page | James_D._Heiple               | other |      2651 |
| Main_Page | Carlos_do_Carmo               | other |      2603 |
| Main_Page | Turki_bin_Nasser_Al_Saud      | link  |       215 |
| Main_Page | Michel_Murr                   | link  |       208 |
| Main_Page | Dick_Callahan                 | link  |       189 |
| Main_Page | Constance_Isherwood           | link  |       178 |
| Main_Page | Godfrey_Hodgson               | link  |       163 |
| Main_Page | Ron_Johnson                   | other |       148 |
| Main_Page | Sonny_Fox                     | link  |       130 |
| Main_Page | John_Chaney                   | other |       107 |
| Main_Page | Lewis_Wolpert                 | other |        29 |
| Main_Page | Marc_Wilmore                  | other |        10 |
| Main_Page | Allan_Burns                   | other |        10 |
+-----------+-------------------------------+-------+-----------+
112 rows in set (0.03 sec)
mysql> select avg(pageviews) from january_views where referer = 'Main_Page' and target in (select * from january_itn_posts_rd) order by pageviews desc;
+----------------+
| avg(pageviews) |
+----------------+
|      9721.8839 |
+----------------+
1 row in set (0.02 sec)

Number of RD deaths from COVID - January

[edit]
select * from jan_covid_deaths where article in (select article from jan_itn_posts);

+-----------------------------+
| article                     |
+-----------------------------+
| Abel Gabuza                 |
| Ali Taher                   |
| Corky Lee                   |
| Gatot Sudjito               |
| Gerry Cottle                |
| James Cross                 |
| Joël Robert                 |
| John Baptist Kaggwa         |
| Juan Carlos Copes           |
| Michel Murr                 |
| Philip Tartaglia            |
| Ron Johnson                 |
| Roy Torrens                 |
| Salleh Abas                 |
| Shingoose                   |
| Sibusiso Moyo               |
| Sonny Fox                   |
| Subiakto Tjakrawerdaya      |
| Wilberforce Kisamba Mugerwa |
+-----------------------------+
19 rows in set (0.00 sec)

December ITN Articles

[edit]
mysql> select * from december_views where target in (select article from itn_list) and referer = 'Main_Page' order by pageviews desc;
+-----------+--------------------------------------------------+-------+-----------+
| referer   | target                                           | type  | pageviews |
+-----------+--------------------------------------------------+-------+-----------+
| Main_Page | Great_conjunction                                | link  |    106300 |
| Main_Page | 2020_Indian_farmers'_protest                     | link  |     78387 |
| Main_Page | Hayabusa2                                        | other |     62045 |
| Main_Page | Valéry_Giscard_d'Estaing                         | other |     60510 |
| Main_Page | Chang'e_5                                        | other |     57153 |
| Main_Page | 2020_World_Rally_Championship                    | other |     31841 |
| Main_Page | Charley_Pride                                    | other |     28819 |
| Main_Page | 2020_Ghanaian_general_election                   | other |     25883 |
| Main_Page | Stella_Tennant                                   | other |     25735 |
| Main_Page | John_le_Carré                                    | other |     23500 |
| Main_Page | Jeremy_Bulloch                                   | other |     22165 |
| Main_Page | Awesome_Again                                    | other |     21405 |
| Main_Page | Paolo_Rossi                                      | other |     20369 |
| Main_Page | Maria_Piątkowska                                 | other |     16874 |
| Main_Page | Doug_Anthony                                     | other |     16625 |
| Main_Page | Fanny_Waterman                                   | other |     14994 |
| Main_Page | Karima_Baloch                                    | other |     14896 |
| Main_Page | John_Barnard_Jenkins                             | other |     14654 |
| Main_Page | Brodie_Lee                                       | other |     14517 |
| Main_Page | George_Blake                                     | other |     14460 |
| Main_Page | Gérard_Houllier                                  | other |     14050 |
| Main_Page | Jerry_Relph                                      | other |     14032 |
| Main_Page | Flavio_Cotti                                     | other |     13852 |
| Main_Page | Soedardjat_Nataatmadja                           | other |     13191 |
| Main_Page | Jack_Steinberger                                 | other |     13166 |
| Main_Page | Òscar_Ribas_Reig                                 | other |     12531 |
| Main_Page | Robin_Jackman                                    | other |     12320 |
| Main_Page | 2020_Petrinja_earthquake                         | link  |     12287 |
| Main_Page | Luke_Letlow                                      | other |     12062 |
| Main_Page | Doug_Scott                                       | other |     12002 |
| Main_Page | Harold_Budd                                      | other |     11976 |
| Main_Page | Barry_Lopez                                      | other |     11956 |
| Main_Page | Walter_E._Williams                               | other |     11838 |
| Main_Page | Huang_Zongying                                   | other |     11727 |
| Main_Page | Phil_Niekro                                      | other |     11635 |
| Main_Page | James_Flynn_(academic)                           | other |     11589 |
| Main_Page | Alison_Lurie                                     | other |     11523 |
| Main_Page | R._N._Shetty                                     | other |     11516 |
| Main_Page | Totilas                                          | other |     11474 |
| Main_Page | Iman_Budhi_Santosa                               | other |     11271 |
| Main_Page | Ann_Reinking                                     | other |     11249 |
| Main_Page | Michael_Jeffery                                  | other |     11178 |
| Main_Page | Jim_McLean                                       | other |     11141 |
| Main_Page | Mohamed_Abarhoun                                 | other |     10761 |
| Main_Page | Betsy_Wade                                       | other |     10602 |
| Main_Page | Donald_Fowler                                    | other |     10549 |
| Main_Page | Paul_Sarbanes                                    | other |     10210 |
| Main_Page | Narinder_Singh_Kapany                            | other |     10192 |
| Main_Page | Maria_Itkina                                     | other |      9668 |
| Main_Page | Roddam_Narasimha                                 | other |      9279 |
| Main_Page | Brian_Kerr,_Baron_Kerr_of_Tonaghmore             | other |      9255 |
| Main_Page | Astad_Deboo                                      | other |      9133 |
| Main_Page | Martin_Lambie-Nairn                              | other |      9042 |
| Main_Page | Romell_Broom                                     | other |      9030 |
| Main_Page | James_Odongo                                     | other |      8915 |
| Main_Page | Gerard_Stokes                                    | other |      8802 |
| Main_Page | Maria_Fyfe                                       | other |      8657 |
| Main_Page | K._C._Jones                                      | other |      8562 |
| Main_Page | Barbara_Windsor                                  | other |      8544 |
| Main_Page | Roger_Moret                                      | other |      8379 |
| Main_Page | Barbara_Rose                                     | other |      8365 |
| Main_Page | Bill_Fitsell                                     | other |      8313 |
| Main_Page | Adele_Rose                                       | other |      7840 |
| Main_Page | George_Ross_Anderson_Jr.                         | other |      7715 |
| Main_Page | Minoru_Makihara                                  | other |      7659 |
| Main_Page | Udyavara_Madhava_Acharya                         | other |      7507 |
| Main_Page | U._A._Khader                                     | other |      7464 |
| Main_Page | Benjamin_Abeles                                  | other |      7422 |
| Main_Page | Ferenc_Tóth_(politician)                         | other |      7176 |
| Main_Page | Dawn_Wells                                       | other |      7114 |
| Main_Page | Fou_Ts'ong                                       | other |      7029 |
| Main_Page | Yuichiro_Hata                                    | other |      6988 |
| Main_Page | Kim_Ki-duk                                       | other |      6685 |
| Main_Page | Elaine_McCoy                                     | other |      6650 |
| Main_Page | Manglesh_Dabral                                  | other |      6550 |
| Main_Page | Paul-Heinz_Dittrich                              | other |      6468 |
| Main_Page | Raymond_Hunter                                   | other |      6465 |
| Main_Page | Hugh_Keays-Byrne                                 | other |      6418 |
| Main_Page | Jutta_Lampe                                      | other |      6411 |
| Main_Page | Joseph_Bachelder_III                             | other |      6329 |
| Main_Page | Pumza_Dyantyi                                    | other |      6282 |
| Main_Page | Tabaré_Vázquez                                   | other |      6152 |
| Main_Page | Muhammad_Mustafa_Mero                            | other |      6137 |
| Main_Page | Dharampal_Gulati                                 | other |      5894 |
| Main_Page | Belinda_Bozzoli                                  | other |      5595 |
| Main_Page | Herman_Asaribab                                  | other |      5585 |
| Main_Page | Lorraine_Monk                                    | link  |      5420 |
| Main_Page | Amelia_Lapeña-Bonifacio                          | other |      5148 |
| Main_Page | Howard_J._Rubenstein                             | other |      4789 |
| Main_Page | Zafarullah_Khan_Jamali                           | other |      4630 |
| Main_Page | Shamsur_Rahman_Faruqi                            | other |      4509 |
| Main_Page | Jack_Lenor_Larsen                                | other |      4426 |
| Main_Page | Sugathakumari                                    | other |      3908 |
| Main_Page | MF_Doom                                          | other |      3407 |
| Main_Page | Brandon_Bernard                                  | other |      2951 |
| Main_Page | Hasu_Yajnik                                      | other |      1291 |
| Main_Page | Joseph_Safra                                     | other |      1262 |
| Main_Page | Garry_Runciman,_3rd_Viscount_Runciman_of_Doxford | other |       836 |
| Main_Page | Kevin_Greene                                     | other |       784 |
| Main_Page | Tommy_Docherty                                   | link  |       766 |
| Main_Page | Aldo_Andretti                                    | other |        23 |
| Main_Page | H._Jack_Geiger                                   | other |        15 |
| Main_Page | John_Fitzpatrick                                 | other |        14 |
| Main_Page | Ronald_Atkins                                    | other |        13 |
+-----------+--------------------------------------------------+-------+-----------+
104 rows in set (0.02 sec)

Request

[edit]
mysql> select sum(pageviews) as sum_pageviews from december_views where target = 'COVID-19_pandemic';
+---------------+
| sum_pageviews |
+---------------+
|       1295443 |
+---------------+
1 row in set (0.02 sec)

mysql> select sum(pageviews) as sum_pageviews from december_views where target = 'COVID-19_pandemic' group by type;
+---------------+
| sum_pageviews |
+---------------+
|        517989 |
|          5265 |
|        772189 |
+---------------+
3 rows in set (0.02 sec)

mysql> select type, sum(pageviews) as sum_pageviews from december_views where target = 'COVID-19_pandemic' group by type;
+----------+---------------+
| type     | sum_pageviews |
+----------+---------------+
| link     |        517989 |
| other    |          5265 |
| external |        772189 |
+----------+---------------+
3 rows in set (0.02 sec)

@LaserLegs:, tweaked your query -- but, is that what you are looking for? Ktin (talk) 02:56, 30 January 2021 (UTC)

I forgot to include type in the result set, nice catch. Yes that's it exactly. Over 50% of the total views for that article come from external sources, just over 10% from the main page. Cheers @Ktin: --LaserLegs (talk) 11:42, 30 January 2021 (UTC)