summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2018-07-24 02:22:35 +0200
committeremkael <emkael@tlen.pl>2018-07-24 02:22:35 +0200
commite7d49367e4401c1558e545d23023f94190c6a4db (patch)
treef4f91b36d590c49e722197d3aaadf02c9a18125c
parent3de628512916ad56f7f89cb4ab6e4d9ef498007d (diff)
2018 German GP
-rw-r--r--rate.log54
-rw-r--r--sql/results.sql82
2 files changed, 136 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index e4f3f23..79e40ab 100644
--- a/rate.log
+++ b/rate.log
@@ -74566,3 +74566,57 @@ Average rating change: 3.095
Podium rating: 7630.7 7680.37
Average rating: 2181.1645
Average rating change: 43.7547058824
+
+2018 German Grand Prix - qualifying (2018-07-21)
+
+#5 (<Sebastian Vettel (#1135)>) 1[1] 2563.61 2567.08
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2457.6 2461.95
+#7 (<Kimi Räikkönen (#1141)>) 3[3] 2515.9 2517.22
+#33 (<Max Verstappen (#1172)>) 4[4] 2433.57 2435.35
+#20 (<Kevin Magnussen (#1165)>) 5[5] 2178.45 2187.05
+#8 (<Romain Grosjean (#1144)>) 6[6] 2017.79 2031.83
+#27 (<Nico Hülkenberg (#1148)>) 7[7] 2193.07 2197.88
+#55 (<Carlos Sainz (#1170)>) 8[8] 2037.09 2047.05
+#16 (<Charles Leclerc (#1184)>) 9[9] 2125.23 2129.66
+#11 (<Sergio Pérez (#1155)>) 10[10] 2149.69 2151.47
+#14 (<Fernando Alonso (#1127)>) 11[11] 2181.12 2180.01
+#35 (<Sergey Sirotkin (#1185)>) 12[12] 1935.7 1944.92
+#9 (<Marcus Ericsson (#1167)>) 13[13] 1945.83 1952.12
+#44 (<Lewis Hamilton (#1140)>) 14[14] 2600.86 2581.2
+#3 (<Daniel Ricciardo (#1157)>) 15[15] 2421.13 2404.05
+#31 (<Esteban Ocon (#1179)>) 16[16] 2113.95 2106.07
+#10 (<Pierre Gasly (#1182)>) 17[17] 2022.57 2017.19
+#28 (<Brendon Hartley (#1183)>) 18[18] 1893.95 1890.8
+#18 (<Lance Stroll (#1181)>) 19[19] 1908.99 1902.73
+#2 (<Stoffel Vandoorne (#1178)>) 20[20] 1927.2 1917.65
+
+Podium rating: 7537.11 7546.25
+Average rating: 2181.165
+Average rating change: 7.006
+
+2018 German Grand Prix (2018-07-22)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2581.2 2607.52
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2461.95 2487.22
+#7 (<Kimi Räikkönen (#1141)>) 3[2] 2517.22 2531.22
+#33 (<Max Verstappen (#1172)>) 4[3] 2435.35 2434.36
+#27 (<Nico Hülkenberg (#1148)>) 5[3] 2197.88 2258.59
+#8 (<Romain Grosjean (#1144)>) 6[4] 2031.83 2056.59
+#11 (<Sergio Pérez (#1155)>) 7[4] 2151.47 2135.1
+#31 (<Esteban Ocon (#1179)>) 8[4] 2106.07 2105.05
+#9 (<Marcus Ericsson (#1167)>) 9[4] 1952.12 2031.34
+#28 (<Brendon Hartley (#1183)>) 10[4] 1890.8 1993.13
+#20 (<Kevin Magnussen (#1165)>) 11[4] 2187.05 2159.16
+#55 (<Carlos Sainz (#1170)>) 12[4] 2047.05 2066.53
+#2 (<Stoffel Vandoorne (#1178)>) 13[4] 1917.65 2010.34
+#10 (<Pierre Gasly (#1182)>) 14[5] 2017.19 1954.99
+#16 (<Charles Leclerc (#1184)>) 15[5] 2129.66 2028.59
+#14 (<Fernando Alonso (#1127)>) 16[0] 2180.01 2180.01
+#18 (<Lance Stroll (#1181)>) R[0] 1902.73 1902.73
+#35 (<Sergey Sirotkin (#1185)>) R[0] 1944.92 1944.92
+#3 (<Daniel Ricciardo (#1157)>) R[0] 2404.05 2404.05
+#5 (<Sebastian Vettel (#1135)>) R[6] 2567.08 2331.83
+
+Podium rating: 7560.37 7625.96
+Average rating: 2181.164
+Average rating change: 55.598125
diff --git a/sql/results.sql b/sql/results.sql
index d9c8224..944b003 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2621,6 +2621,8 @@ INSERT INTO `races` VALUES(2615, '2018 Austrian Grand Prix - qualifying', '2018-
INSERT INTO `races` VALUES(2616, '2018 Austrian Grand Prix', '2018-07-01', 0, 4);
INSERT INTO `races` VALUES(2617, '2018 British Grand Prix - qualifying', '2018-07-07', 0, 3);
INSERT INTO `races` VALUES(2618, '2018 British Grand Prix', '2018-07-08', 0, 4);
+INSERT INTO `races` VALUES(2619, '2018 German Grand Prix - qualifying', '2018-07-21', 0, 3);
+INSERT INTO `races` VALUES(2620, '2018 German Grand Prix', '2018-07-22', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60091,6 +60093,46 @@ INSERT INTO `entries` VALUES(56240, 'R', 55, 6, 2618);
INSERT INTO `entries` VALUES(56241, 'R', 9, 6, 2618);
INSERT INTO `entries` VALUES(56242, 'R', 16, 0, 2618);
INSERT INTO `entries` VALUES(56243, 'R', 28, 0, 2618);
+INSERT INTO `entries` VALUES(56244, '1', 5, 1, 2619);
+INSERT INTO `entries` VALUES(56245, '2', 77, 2, 2619);
+INSERT INTO `entries` VALUES(56246, '3', 7, 3, 2619);
+INSERT INTO `entries` VALUES(56247, '4', 33, 4, 2619);
+INSERT INTO `entries` VALUES(56248, '5', 20, 5, 2619);
+INSERT INTO `entries` VALUES(56249, '6', 8, 6, 2619);
+INSERT INTO `entries` VALUES(56250, '7', 27, 7, 2619);
+INSERT INTO `entries` VALUES(56251, '8', 55, 8, 2619);
+INSERT INTO `entries` VALUES(56252, '9', 16, 9, 2619);
+INSERT INTO `entries` VALUES(56253, '10', 11, 10, 2619);
+INSERT INTO `entries` VALUES(56254, '11', 14, 11, 2619);
+INSERT INTO `entries` VALUES(56255, '12', 35, 12, 2619);
+INSERT INTO `entries` VALUES(56256, '13', 9, 13, 2619);
+INSERT INTO `entries` VALUES(56257, '14', 44, 14, 2619);
+INSERT INTO `entries` VALUES(56258, '15', 3, 15, 2619);
+INSERT INTO `entries` VALUES(56259, '16', 31, 16, 2619);
+INSERT INTO `entries` VALUES(56260, '17', 10, 17, 2619);
+INSERT INTO `entries` VALUES(56261, '18', 28, 18, 2619);
+INSERT INTO `entries` VALUES(56262, '19', 18, 19, 2619);
+INSERT INTO `entries` VALUES(56263, '20', 2, 20, 2619);
+INSERT INTO `entries` VALUES(56264, '1', 44, 1, 2620);
+INSERT INTO `entries` VALUES(56265, '2', 77, 2, 2620);
+INSERT INTO `entries` VALUES(56266, '3', 7, 2, 2620);
+INSERT INTO `entries` VALUES(56267, '4', 33, 3, 2620);
+INSERT INTO `entries` VALUES(56268, '5', 27, 3, 2620);
+INSERT INTO `entries` VALUES(56269, '6', 8, 4, 2620);
+INSERT INTO `entries` VALUES(56270, '7', 11, 4, 2620);
+INSERT INTO `entries` VALUES(56271, '8', 31, 4, 2620);
+INSERT INTO `entries` VALUES(56272, '9', 9, 4, 2620);
+INSERT INTO `entries` VALUES(56273, '10', 28, 4, 2620);
+INSERT INTO `entries` VALUES(56274, '11', 20, 4, 2620);
+INSERT INTO `entries` VALUES(56275, '12', 55, 4, 2620);
+INSERT INTO `entries` VALUES(56276, '13', 2, 4, 2620);
+INSERT INTO `entries` VALUES(56277, '14', 10, 5, 2620);
+INSERT INTO `entries` VALUES(56278, '15', 16, 5, 2620);
+INSERT INTO `entries` VALUES(56279, '16', 14, 0, 2620);
+INSERT INTO `entries` VALUES(56280, 'R', 18, 0, 2620);
+INSERT INTO `entries` VALUES(56281, 'R', 5, 6, 2620);
+INSERT INTO `entries` VALUES(56282, 'R', 35, 0, 2620);
+INSERT INTO `entries` VALUES(56283, 'R', 3, 0, 2620);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -116475,3 +116517,43 @@ INSERT INTO `driver_entries` VALUES(1170, 56240, 56380);
INSERT INTO `driver_entries` VALUES(1167, 56241, 56381);
INSERT INTO `driver_entries` VALUES(1184, 56242, 56382);
INSERT INTO `driver_entries` VALUES(1183, 56243, 56383);
+INSERT INTO `driver_entries` VALUES(1135, 56244, 56384);
+INSERT INTO `driver_entries` VALUES(1161, 56245, 56385);
+INSERT INTO `driver_entries` VALUES(1141, 56246, 56386);
+INSERT INTO `driver_entries` VALUES(1172, 56247, 56387);
+INSERT INTO `driver_entries` VALUES(1165, 56248, 56388);
+INSERT INTO `driver_entries` VALUES(1144, 56249, 56389);
+INSERT INTO `driver_entries` VALUES(1148, 56250, 56390);
+INSERT INTO `driver_entries` VALUES(1170, 56251, 56391);
+INSERT INTO `driver_entries` VALUES(1184, 56252, 56392);
+INSERT INTO `driver_entries` VALUES(1155, 56253, 56393);
+INSERT INTO `driver_entries` VALUES(1127, 56254, 56394);
+INSERT INTO `driver_entries` VALUES(1185, 56255, 56395);
+INSERT INTO `driver_entries` VALUES(1167, 56256, 56396);
+INSERT INTO `driver_entries` VALUES(1140, 56257, 56397);
+INSERT INTO `driver_entries` VALUES(1157, 56258, 56398);
+INSERT INTO `driver_entries` VALUES(1179, 56259, 56399);
+INSERT INTO `driver_entries` VALUES(1182, 56260, 56400);
+INSERT INTO `driver_entries` VALUES(1183, 56261, 56401);
+INSERT INTO `driver_entries` VALUES(1181, 56262, 56402);
+INSERT INTO `driver_entries` VALUES(1178, 56263, 56403);
+INSERT INTO `driver_entries` VALUES(1140, 56264, 56404);
+INSERT INTO `driver_entries` VALUES(1161, 56265, 56405);
+INSERT INTO `driver_entries` VALUES(1141, 56266, 56406);
+INSERT INTO `driver_entries` VALUES(1172, 56267, 56407);
+INSERT INTO `driver_entries` VALUES(1148, 56268, 56408);
+INSERT INTO `driver_entries` VALUES(1144, 56269, 56409);
+INSERT INTO `driver_entries` VALUES(1155, 56270, 56410);
+INSERT INTO `driver_entries` VALUES(1179, 56271, 56411);
+INSERT INTO `driver_entries` VALUES(1167, 56272, 56412);
+INSERT INTO `driver_entries` VALUES(1183, 56273, 56413);
+INSERT INTO `driver_entries` VALUES(1165, 56274, 56414);
+INSERT INTO `driver_entries` VALUES(1170, 56275, 56415);
+INSERT INTO `driver_entries` VALUES(1178, 56276, 56416);
+INSERT INTO `driver_entries` VALUES(1182, 56277, 56417);
+INSERT INTO `driver_entries` VALUES(1184, 56278, 56418);
+INSERT INTO `driver_entries` VALUES(1127, 56279, 56419);
+INSERT INTO `driver_entries` VALUES(1181, 56280, 56420);
+INSERT INTO `driver_entries` VALUES(1135, 56281, 56421);
+INSERT INTO `driver_entries` VALUES(1185, 56282, 56422);
+INSERT INTO `driver_entries` VALUES(1157, 56283, 56423);