diff options
-rw-r--r-- | rate.log | 54 | ||||
-rw-r--r-- | sql/championship.sql | 20 | ||||
-rw-r--r-- | sql/results.sql | 82 |
3 files changed, 156 insertions, 0 deletions
@@ -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); |