summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2018-12-04 19:32:39 +0100
committeremkael <emkael@tlen.pl>2018-12-04 19:32:39 +0100
commit552c59c78a7ca1d3a495826de873671d5420b164 (patch)
tree6df85bc0495562f7c9763c3ac9428075a85b4261
parent7864fa81d0a9834937a3f862ee390279d95f9ba7 (diff)
2018 Abu Dhabi GP
-rw-r--r--rate.log54
-rw-r--r--sql/championship.sql20
-rw-r--r--sql/results.sql82
3 files changed, 156 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index e267c89..6419f9d 100644
--- a/rate.log
+++ b/rate.log
@@ -75105,3 +75105,57 @@ Podium rating: 7747.83 7800.03
Average rating: 2181.1625
Average rating change: 54.4852631579
+2018 Abu Dhabi Grand Prix - qualifying (2018-11-24)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2672.44 2674.3
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2484.27 2488.03
+#5 (<Sebastian Vettel (#1135)>) 3[3] 2422.96 2426.56
+#7 (<Kimi Räikkönen (#1141)>) 4[4] 2565.46 2564.32
+#3 (<Daniel Ricciardo (#1157)>) 5[5] 2396.13 2397.2
+#33 (<Max Verstappen (#1172)>) 6[6] 2562.13 2557.86
+#8 (<Romain Grosjean (#1144)>) 7[7] 2120.1 2127.21
+#16 (<Charles Leclerc (#1184)>) 8[8] 2127.68 2132.86
+#31 (<Esteban Ocon (#1179)>) 9[9] 2015.06 2023.66
+#27 (<Nico Hülkenberg (#1148)>) 10[10] 2102.84 2105.9
+#55 (<Carlos Sainz (#1170)>) 11[11] 2091.54 2093.5
+#9 (<Marcus Ericsson (#1167)>) 12[12] 1923.33 1933.19
+#20 (<Kevin Magnussen (#1165)>) 13[13] 2123.57 2120.13
+#11 (<Sergio Pérez (#1155)>) 14[14] 2121.61 2116.65
+#14 (<Fernando Alonso (#1127)>) 15[15] 1898.12 1902.05
+#28 (<Brendon Hartley (#1183)>) 16[16] 2022.73 2018.19
+#10 (<Pierre Gasly (#1182)>) 17[17] 2035.73 2029.0
+#2 (<Stoffel Vandoorne (#1178)>) 18[18] 2017.61 2010.1
+#35 (<Sergey Sirotkin (#1185)>) 19[19] 2014.56 2005.58
+#18 (<Lance Stroll (#1181)>) 20[20] 1905.38 1896.95
+
+Podium rating: 7579.67 7588.89
+Average rating: 2181.1625
+Average rating change: 4.9995
+
+2018 Abu Dhabi Grand Prix (2018-11-25)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2674.3 2687.55
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2426.56 2456.03
+#33 (<Max Verstappen (#1172)>) 3[2] 2557.86 2563.17
+#3 (<Daniel Ricciardo (#1157)>) 4[3] 2397.2 2400.84
+#77 (<Valtteri Bottas (#1161)>) 5[3] 2488.03 2473.47
+#55 (<Carlos Sainz (#1170)>) 6[4] 2093.5 2151.21
+#16 (<Charles Leclerc (#1184)>) 7[4] 2132.86 2176.99
+#11 (<Sergio Pérez (#1155)>) 8[5] 2116.65 2142.32
+#8 (<Romain Grosjean (#1144)>) 9[6] 2127.21 2077.26
+#20 (<Kevin Magnussen (#1165)>) 10[6] 2120.13 2072.61
+#14 (<Fernando Alonso (#1127)>) 11[6] 1902.05 1939.23
+#28 (<Brendon Hartley (#1183)>) 12[6] 2018.19 2006.24
+#18 (<Lance Stroll (#1181)>) 13[6] 1896.95 1936.0
+#2 (<Stoffel Vandoorne (#1178)>) 14[6] 2010.1 2000.92
+#35 (<Sergey Sirotkin (#1185)>) 15[6] 2005.58 1997.94
+#10 (<Pierre Gasly (#1182)>) R[0] 2029.0 2029.0
+#31 (<Esteban Ocon (#1179)>) R[0] 2023.66 2023.66
+#9 (<Marcus Ericsson (#1167)>) R[0] 1933.19 1933.19
+#7 (<Kimi Räikkönen (#1141)>) R[0] 2564.32 2564.32
+#27 (<Nico Hülkenberg (#1148)>) R[7] 2105.9 1991.29
+
+Podium rating: 7658.72 7706.75
+Average rating: 2181.162
+Average rating change: 31.92625
+
diff --git a/sql/championship.sql b/sql/championship.sql
index b3ae669..da3e6b0 100644
--- a/sql/championship.sql
+++ b/sql/championship.sql
@@ -1336,6 +1336,26 @@ INSERT INTO `championship` VALUES(1324, 2017, 16, 1178, 13);
INSERT INTO `championship` VALUES(1325, 2017, 17, 1175, 8);
INSERT INTO `championship` VALUES(1326, 2017, 18, 1177, 5);
INSERT INTO `championship` VALUES(1327, 2017, 19, 1166, 5);
+INSERT INTO `championship` VALUES(1328, 2018, 1, 1140, 408);
+INSERT INTO `championship` VALUES(1329, 2018, 2, 1135, 320);
+INSERT INTO `championship` VALUES(1330, 2018, 3, 1141, 251);
+INSERT INTO `championship` VALUES(1331, 2018, 4, 1172, 249);
+INSERT INTO `championship` VALUES(1332, 2018, 5, 1161, 247);
+INSERT INTO `championship` VALUES(1333, 2018, 6, 1157, 170);
+INSERT INTO `championship` VALUES(1334, 2018, 7, 1148, 69);
+INSERT INTO `championship` VALUES(1335, 2018, 8, 1155, 62);
+INSERT INTO `championship` VALUES(1336, 2018, 9, 1165, 56);
+INSERT INTO `championship` VALUES(1337, 2018, 10, 1170, 53);
+INSERT INTO `championship` VALUES(1338, 2018, 11, 1127, 50);
+INSERT INTO `championship` VALUES(1339, 2018, 12, 1179, 49);
+INSERT INTO `championship` VALUES(1340, 2018, 13, 1184, 39);
+INSERT INTO `championship` VALUES(1341, 2018, 14, 1144, 37);
+INSERT INTO `championship` VALUES(1342, 2018, 15, 1182, 29);
+INSERT INTO `championship` VALUES(1343, 2018, 16, 1178, 12);
+INSERT INTO `championship` VALUES(1344, 2018, 17, 1167, 9);
+INSERT INTO `championship` VALUES(1345, 2018, 18, 1181, 6);
+INSERT INTO `championship` VALUES(1346, 2018, 19, 1183, 4);
+INSERT INTO `championship` VALUES(1347, 2018, 20, 1185, 1);
ALTER TABLE `championship`
ADD PRIMARY KEY (`id`), ADD KEY `_driver` (`_driver`);
diff --git a/sql/results.sql b/sql/results.sql
index 58930fd..8ab3b51 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2641,6 +2641,8 @@ INSERT INTO `races` VALUES(2635, '2018 Mexican Grand Prix - qualifying', '2018-1
INSERT INTO `races` VALUES(2636, '2018 Mexican Grand Prix', '2018-10-27', 0, 4);
INSERT INTO `races` VALUES(2637, '2018 Brazilian Grand Prix - qualifying', '2018-11-10', 0, 3);
INSERT INTO `races` VALUES(2638, '2018 Brazilian Grand Prix', '2018-11-11', 0, 4);
+INSERT INTO `races` VALUES(2639, '2018 Abu Dhabi Grand Prix - qualifying', '2018-11-24', 0, 3);
+INSERT INTO `races` VALUES(2640, '2018 Abu Dhabi Grand Prix', '2018-11-25', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60511,6 +60513,46 @@ INSERT INTO `entries` VALUES(56640, '17', 14, 6, 2638);
INSERT INTO `entries` VALUES(56641, '18', 18, 6, 2638);
INSERT INTO `entries` VALUES(56642, 'R', 27, 0, 2638);
INSERT INTO `entries` VALUES(56643, 'R', 9, 7, 2638);
+INSERT INTO `entries` VALUES(56644, '1', 44, 1, 2639);
+INSERT INTO `entries` VALUES(56645, '2', 77, 2, 2639);
+INSERT INTO `entries` VALUES(56646, '3', 5, 3, 2639);
+INSERT INTO `entries` VALUES(56647, '4', 7, 4, 2639);
+INSERT INTO `entries` VALUES(56648, '5', 3, 5, 2639);
+INSERT INTO `entries` VALUES(56649, '6', 33, 6, 2639);
+INSERT INTO `entries` VALUES(56650, '7', 8, 7, 2639);
+INSERT INTO `entries` VALUES(56651, '8', 16, 8, 2639);
+INSERT INTO `entries` VALUES(56652, '9', 31, 9, 2639);
+INSERT INTO `entries` VALUES(56653, '10', 27, 10, 2639);
+INSERT INTO `entries` VALUES(56654, '11', 55, 11, 2639);
+INSERT INTO `entries` VALUES(56655, '12', 9, 12, 2639);
+INSERT INTO `entries` VALUES(56656, '13', 20, 13, 2639);
+INSERT INTO `entries` VALUES(56657, '14', 11, 14, 2639);
+INSERT INTO `entries` VALUES(56658, '15', 14, 15, 2639);
+INSERT INTO `entries` VALUES(56659, '16', 28, 16, 2639);
+INSERT INTO `entries` VALUES(56660, '17', 10, 17, 2639);
+INSERT INTO `entries` VALUES(56661, '18', 2, 18, 2639);
+INSERT INTO `entries` VALUES(56662, '19', 35, 19, 2639);
+INSERT INTO `entries` VALUES(56663, '20', 18, 20, 2639);
+INSERT INTO `entries` VALUES(56664, '1', 44, 1, 2640);
+INSERT INTO `entries` VALUES(56665, '2', 5, 2, 2640);
+INSERT INTO `entries` VALUES(56666, '3', 33, 2, 2640);
+INSERT INTO `entries` VALUES(56667, '4', 3, 3, 2640);
+INSERT INTO `entries` VALUES(56668, '5', 77, 3, 2640);
+INSERT INTO `entries` VALUES(56669, '6', 55, 4, 2640);
+INSERT INTO `entries` VALUES(56670, '7', 16, 4, 2640);
+INSERT INTO `entries` VALUES(56671, '8', 11, 5, 2640);
+INSERT INTO `entries` VALUES(56672, '9', 8, 6, 2640);
+INSERT INTO `entries` VALUES(56673, '10', 20, 6, 2640);
+INSERT INTO `entries` VALUES(56674, '11', 14, 6, 2640);
+INSERT INTO `entries` VALUES(56675, '12', 28, 6, 2640);
+INSERT INTO `entries` VALUES(56676, '13', 18, 6, 2640);
+INSERT INTO `entries` VALUES(56677, '14', 2, 6, 2640);
+INSERT INTO `entries` VALUES(56678, '15', 35, 6, 2640);
+INSERT INTO `entries` VALUES(56679, 'R', 10, 0, 2640);
+INSERT INTO `entries` VALUES(56680, 'R', 31, 0, 2640);
+INSERT INTO `entries` VALUES(56681, 'R', 9, 0, 2640);
+INSERT INTO `entries` VALUES(56682, 'R', 7, 0, 2640);
+INSERT INTO `entries` VALUES(56683, 'R', 27, 7, 2640);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -117295,3 +117337,43 @@ INSERT INTO `driver_entries` VALUES(1127, 56640, 56780);
INSERT INTO `driver_entries` VALUES(1181, 56641, 56781);
INSERT INTO `driver_entries` VALUES(1148, 56642, 56782);
INSERT INTO `driver_entries` VALUES(1167, 56643, 56783);
+INSERT INTO `driver_entries` VALUES(1140, 56644, 56784);
+INSERT INTO `driver_entries` VALUES(1161, 56645, 56785);
+INSERT INTO `driver_entries` VALUES(1135, 56646, 56786);
+INSERT INTO `driver_entries` VALUES(1141, 56647, 56787);
+INSERT INTO `driver_entries` VALUES(1157, 56648, 56788);
+INSERT INTO `driver_entries` VALUES(1172, 56649, 56789);
+INSERT INTO `driver_entries` VALUES(1144, 56650, 56790);
+INSERT INTO `driver_entries` VALUES(1184, 56651, 56791);
+INSERT INTO `driver_entries` VALUES(1179, 56652, 56792);
+INSERT INTO `driver_entries` VALUES(1148, 56653, 56793);
+INSERT INTO `driver_entries` VALUES(1170, 56654, 56794);
+INSERT INTO `driver_entries` VALUES(1167, 56655, 56795);
+INSERT INTO `driver_entries` VALUES(1165, 56656, 56796);
+INSERT INTO `driver_entries` VALUES(1155, 56657, 56797);
+INSERT INTO `driver_entries` VALUES(1127, 56658, 56798);
+INSERT INTO `driver_entries` VALUES(1183, 56659, 56799);
+INSERT INTO `driver_entries` VALUES(1182, 56660, 56800);
+INSERT INTO `driver_entries` VALUES(1178, 56661, 56801);
+INSERT INTO `driver_entries` VALUES(1185, 56662, 56802);
+INSERT INTO `driver_entries` VALUES(1181, 56663, 56803);
+INSERT INTO `driver_entries` VALUES(1140, 56664, 56804);
+INSERT INTO `driver_entries` VALUES(1135, 56665, 56805);
+INSERT INTO `driver_entries` VALUES(1172, 56666, 56806);
+INSERT INTO `driver_entries` VALUES(1157, 56667, 56807);
+INSERT INTO `driver_entries` VALUES(1161, 56668, 56808);
+INSERT INTO `driver_entries` VALUES(1170, 56669, 56809);
+INSERT INTO `driver_entries` VALUES(1184, 56670, 56810);
+INSERT INTO `driver_entries` VALUES(1155, 56671, 56811);
+INSERT INTO `driver_entries` VALUES(1144, 56672, 56812);
+INSERT INTO `driver_entries` VALUES(1165, 56673, 56813);
+INSERT INTO `driver_entries` VALUES(1127, 56674, 56814);
+INSERT INTO `driver_entries` VALUES(1183, 56675, 56815);
+INSERT INTO `driver_entries` VALUES(1181, 56676, 56816);
+INSERT INTO `driver_entries` VALUES(1178, 56677, 56817);
+INSERT INTO `driver_entries` VALUES(1185, 56678, 56818);
+INSERT INTO `driver_entries` VALUES(1182, 56679, 56819);
+INSERT INTO `driver_entries` VALUES(1179, 56680, 56820);
+INSERT INTO `driver_entries` VALUES(1167, 56681, 56821);
+INSERT INTO `driver_entries` VALUES(1141, 56682, 56822);
+INSERT INTO `driver_entries` VALUES(1148, 56683, 56823);