From 71db85b0517b92cf620315658905cb2d98bd8bba Mon Sep 17 00:00:00 2001 From: emkael Date: Sun, 17 Jun 2018 23:16:09 +0200 Subject: 2018 Canadian GP --- rate.log | 54 +++++++++++++++++++++++++++++++++++++ sql/results.sql | 82 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 136 insertions(+) diff --git a/rate.log b/rate.log index bae3440..2ee726a 100644 --- a/rate.log +++ b/rate.log @@ -74349,3 +74349,57 @@ Podium rating: 7398.57 7511.91 Average rating: 2181.17 Average rating change: 57.7468421053 +2018 Canadian Grand Prix - qualifying (2018-06-09) + +#5 () 1[1] 2509.49 2513.78 +#77 () 2[2] 2512.69 2515.31 +#33 () 3[3] 2187.88 2199.33 +#44 () 4[4] 2599.81 2597.5 +#7 () 5[5] 2517.17 2514.89 +#3 () 6[6] 2402.61 2401.61 +#27 () 7[7] 2104.42 2113.28 +#31 () 8[8] 2097.08 2104.69 +#55 () 9[9] 2221.49 2221.91 +#11 () 10[10] 2165.47 2166.71 +#20 () 11[11] 2162.22 2162.0 +#28 () 12[12] 1926.48 1936.87 +#16 () 13[13] 1953.43 1960.03 +#14 () 14[14] 2220.75 2211.6 +#2 () 15[15] 2021.57 2019.98 +#10 () 16[16] 2099.31 2092.42 +#18 () 17[17] 1972.42 1968.38 +#35 () 18[18] 1939.86 1935.17 +#9 () 19[19] 2091.29 2078.38 +#8 () 20[20] 1917.97 1909.57 + +Podium rating: 7210.06 7228.42 +Average rating: 2181.1705 +Average rating change: 5.348 + +2018 Canadian Grand Prix (2018-06-10) + +#5 () 1[1] 2513.78 2554.37 +#77 () 2[2] 2515.31 2531.58 +#33 () 3[2] 2199.33 2308.51 +#3 () 4[3] 2401.61 2412.91 +#44 () 5[3] 2597.5 2566.04 +#7 () 6[4] 2514.89 2475.25 +#27 () 7[5] 2113.28 2122.85 +#55 () 8[5] 2221.91 2186.32 +#31 () 9[5] 2104.69 2118.09 +#16 () 10[5] 1960.03 2061.37 +#10 () 11[5] 2092.42 2111.34 +#8 () 12[5] 1909.57 2035.68 +#20 () 13[5] 2162.0 2150.44 +#11 () 14[5] 2166.71 2153.18 +#9 () 15[6] 2078.38 2003.65 +#2 () 16[6] 2019.98 1971.81 +#35 () 17[6] 1935.17 1917.11 +#14 () R[0] 2211.6 2211.6 +#28 () R[7] 1936.87 1857.97 +#18 () R[7] 1968.38 1873.33 + +Podium rating: 7228.42 7394.46 +Average rating: 2181.1705 +Average rating change: 47.0194736842 + diff --git a/sql/results.sql b/sql/results.sql index c6603c3..fe8cb7e 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2613,6 +2613,8 @@ INSERT INTO `races` VALUES(2607, '2018 Spanish Grand Prix - qualifying', '2018-0 INSERT INTO `races` VALUES(2608, '2018 Spanish Grand Prix', '2018-05-13', 0, 4); INSERT INTO `races` VALUES(2609, '2018 Monaco Grand Prix - qualifying', '2018-05-26', 0, 3); INSERT INTO `races` VALUES(2610, '2018 Monaco Grand Prix', '2018-05-27', 0, 4); +INSERT INTO `races` VALUES(2611, '2018 Canadian Grand Prix - qualifying', '2018-06-09', 0, 3); +INSERT INTO `races` VALUES(2612, '2018 Canadian Grand Prix', '2018-06-10', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -59923,6 +59925,46 @@ INSERT INTO `entries` VALUES(56080, '17', 18, 6, 2610); INSERT INTO `entries` VALUES(56081, 'R', 16, 7, 2610); INSERT INTO `entries` VALUES(56082, 'R', 28, 7, 2610); INSERT INTO `entries` VALUES(56083, 'R', 14, 0, 2610); +INSERT INTO `entries` VALUES(56084, '1', 5, 1, 2611); +INSERT INTO `entries` VALUES(56085, '2', 77, 2, 2611); +INSERT INTO `entries` VALUES(56086, '3', 33, 3, 2611); +INSERT INTO `entries` VALUES(56087, '4', 44, 4, 2611); +INSERT INTO `entries` VALUES(56088, '5', 7, 5, 2611); +INSERT INTO `entries` VALUES(56089, '6', 3, 6, 2611); +INSERT INTO `entries` VALUES(56090, '7', 27, 7, 2611); +INSERT INTO `entries` VALUES(56091, '8', 31, 8, 2611); +INSERT INTO `entries` VALUES(56092, '9', 55, 9, 2611); +INSERT INTO `entries` VALUES(56093, '10', 11, 10, 2611); +INSERT INTO `entries` VALUES(56094, '11', 20, 11, 2611); +INSERT INTO `entries` VALUES(56095, '12', 28, 12, 2611); +INSERT INTO `entries` VALUES(56096, '13', 16, 13, 2611); +INSERT INTO `entries` VALUES(56097, '14', 14, 14, 2611); +INSERT INTO `entries` VALUES(56098, '15', 2, 15, 2611); +INSERT INTO `entries` VALUES(56099, '16', 10, 16, 2611); +INSERT INTO `entries` VALUES(56100, '17', 18, 17, 2611); +INSERT INTO `entries` VALUES(56101, '18', 35, 18, 2611); +INSERT INTO `entries` VALUES(56102, '19', 9, 19, 2611); +INSERT INTO `entries` VALUES(56103, '20', 8, 20, 2611); +INSERT INTO `entries` VALUES(56104, '1', 5, 1, 2612); +INSERT INTO `entries` VALUES(56105, '2', 77, 2, 2612); +INSERT INTO `entries` VALUES(56106, '3', 33, 2, 2612); +INSERT INTO `entries` VALUES(56107, '4', 3, 3, 2612); +INSERT INTO `entries` VALUES(56108, '5', 44, 3, 2612); +INSERT INTO `entries` VALUES(56109, '6', 7, 4, 2612); +INSERT INTO `entries` VALUES(56110, '7', 27, 5, 2612); +INSERT INTO `entries` VALUES(56111, '8', 55, 5, 2612); +INSERT INTO `entries` VALUES(56112, '9', 31, 5, 2612); +INSERT INTO `entries` VALUES(56113, '10', 16, 5, 2612); +INSERT INTO `entries` VALUES(56114, '11', 10, 5, 2612); +INSERT INTO `entries` VALUES(56115, '12', 8, 5, 2612); +INSERT INTO `entries` VALUES(56116, '13', 20, 5, 2612); +INSERT INTO `entries` VALUES(56117, '14', 11, 5, 2612); +INSERT INTO `entries` VALUES(56118, '15', 9, 6, 2612); +INSERT INTO `entries` VALUES(56119, '16', 2, 6, 2612); +INSERT INTO `entries` VALUES(56120, '17', 35, 6, 2612); +INSERT INTO `entries` VALUES(56121, 'R', 14, 0, 2612); +INSERT INTO `entries` VALUES(56122, 'R', 28, 7, 2612); +INSERT INTO `entries` VALUES(56123, 'R', 18, 7, 2612); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -116147,3 +116189,43 @@ INSERT INTO `driver_entries` VALUES(1181, 56080, 56220); INSERT INTO `driver_entries` VALUES(1184, 56081, 56221); INSERT INTO `driver_entries` VALUES(1183, 56082, 56222); INSERT INTO `driver_entries` VALUES(1127, 56083, 56223); +INSERT INTO `driver_entries` VALUES(1135, 56084, 56224); +INSERT INTO `driver_entries` VALUES(1161, 56085, 56225); +INSERT INTO `driver_entries` VALUES(1172, 56086, 56226); +INSERT INTO `driver_entries` VALUES(1140, 56087, 56227); +INSERT INTO `driver_entries` VALUES(1141, 56088, 56228); +INSERT INTO `driver_entries` VALUES(1157, 56089, 56229); +INSERT INTO `driver_entries` VALUES(1148, 56090, 56230); +INSERT INTO `driver_entries` VALUES(1179, 56091, 56231); +INSERT INTO `driver_entries` VALUES(1170, 56092, 56232); +INSERT INTO `driver_entries` VALUES(1155, 56093, 56233); +INSERT INTO `driver_entries` VALUES(1165, 56094, 56234); +INSERT INTO `driver_entries` VALUES(1183, 56095, 56235); +INSERT INTO `driver_entries` VALUES(1184, 56096, 56236); +INSERT INTO `driver_entries` VALUES(1127, 56097, 56237); +INSERT INTO `driver_entries` VALUES(1178, 56098, 56238); +INSERT INTO `driver_entries` VALUES(1182, 56099, 56239); +INSERT INTO `driver_entries` VALUES(1181, 56100, 56240); +INSERT INTO `driver_entries` VALUES(1185, 56101, 56241); +INSERT INTO `driver_entries` VALUES(1167, 56102, 56242); +INSERT INTO `driver_entries` VALUES(1144, 56103, 56243); +INSERT INTO `driver_entries` VALUES(1135, 56104, 56244); +INSERT INTO `driver_entries` VALUES(1161, 56105, 56245); +INSERT INTO `driver_entries` VALUES(1172, 56106, 56246); +INSERT INTO `driver_entries` VALUES(1157, 56107, 56247); +INSERT INTO `driver_entries` VALUES(1140, 56108, 56248); +INSERT INTO `driver_entries` VALUES(1141, 56109, 56249); +INSERT INTO `driver_entries` VALUES(1148, 56110, 56250); +INSERT INTO `driver_entries` VALUES(1170, 56111, 56251); +INSERT INTO `driver_entries` VALUES(1179, 56112, 56252); +INSERT INTO `driver_entries` VALUES(1184, 56113, 56253); +INSERT INTO `driver_entries` VALUES(1182, 56114, 56254); +INSERT INTO `driver_entries` VALUES(1144, 56115, 56255); +INSERT INTO `driver_entries` VALUES(1165, 56116, 56256); +INSERT INTO `driver_entries` VALUES(1155, 56117, 56257); +INSERT INTO `driver_entries` VALUES(1167, 56118, 56258); +INSERT INTO `driver_entries` VALUES(1178, 56119, 56259); +INSERT INTO `driver_entries` VALUES(1185, 56120, 56260); +INSERT INTO `driver_entries` VALUES(1127, 56121, 56261); +INSERT INTO `driver_entries` VALUES(1183, 56122, 56262); +INSERT INTO `driver_entries` VALUES(1181, 56123, 56263); -- cgit v1.2.3