From 4770ade9adb58120bf1d9f9d3276626367b9689b Mon Sep 17 00:00:00 2001 From: emkael Date: Wed, 1 Nov 2017 19:51:17 +0100 Subject: * 2017 Mexican GP --- rate.log | 53 ++++++++++++++++++++++++++++++++++++++ sql/results.sql | 80 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 133 insertions(+) diff --git a/rate.log b/rate.log index dd7891a..92ab4e9 100644 --- a/rate.log +++ b/rate.log @@ -73864,3 +73864,56 @@ Podium rating: 7337.63 7449.96 Average rating: 2181.883 Average rating change: 41.9223529412 +2017 Mexican Grand Prix - qualifying (2017-10-28) + +#5 () 1[1] 2419.39 2425.9 +#33 () 2[2] 2366.16 2372.59 +#44 () 3[3] 2659.92 2658.42 +#77 () 4[4] 2479.59 2479.78 +#7 () 5[5] 2370.65 2372.14 +#31 () 6[6] 2230.45 2235.02 +#3 () 7[7] 2478.4 2473.82 +#27 () 8[8] 2112.32 2118.26 +#55 () 9[9] 2146.11 2149.11 +#11 () 10[10] 2176.0 2176.23 +#19 () 11[11] 2066.97 2069.9 +#18 () 12[12] 2071.82 2072.96 +#28 () 13[13] 2006.26 2008.3 +#14 () 14[14] 2067.07 2065.19 +#2 () 15[15] 2061.39 2058.13 +#9 () 16[16] 1896.38 1896.61 +#94 () 17[17] 1853.55 1852.96 +#20 () 18[18] 2071.6 2061.54 +#8 () 19[19] 2101.6 2088.76 + +Podium rating: 7445.47 7456.91 +Average rating: 2191.34894737 +Average rating change: 3.65315789474 + +2017 Mexican Grand Prix (2017-10-29) + +#33 () 1[1] 2372.59 2434.82 +#77 () 2[2] 2479.78 2495.09 +#7 () 3[2] 2372.14 2410.48 +#5 () 4[3] 2425.9 2428.09 +#31 () 5[4] 2235.02 2205.63 +#18 () 6[4] 2072.96 2092.73 +#11 () 7[4] 2176.23 2164.3 +#20 () 8[4] 2061.54 2084.77 +#44 () 9[4] 2658.42 2543.39 +#14 () 10[4] 2065.19 2087.32 +#19 () 11[4] 2069.9 2090.6 +#2 () 12[4] 2058.13 2082.38 +#10 () 13[4] 2039.41 2069.24 +#94 () 14[5] 1852.96 1828.37 +#8 () 15[5] 2088.76 2011.71 +#55 () R[0] 2149.11 2149.11 +#9 () R[0] 1896.61 1896.61 +#28 () R[0] 2008.3 2008.3 +#27 () R[0] 2118.26 2118.26 +#3 () R[0] 2473.82 2473.82 + +Podium rating: 7224.51 7340.39 +Average rating: 2183.7515 +Average rating change: 34.398 + diff --git a/sql/results.sql b/sql/results.sql index cb667db..3fcfff2 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2595,6 +2595,8 @@ INSERT INTO `races` VALUES(2589, '2017 Japanese Grand Prix - qualifying', '2017- INSERT INTO `races` VALUES(2590, '2017 Japanese Grand Prix', '2017-10-08', 0, 4); INSERT INTO `races` VALUES(2591, '2017 United States Grand Prix - qualifying', '2017-10-21', 0, 3); INSERT INTO `races` VALUES(2592, '2017 United States Grand Prix', '2017-10-22', 0, 4); +INSERT INTO `races` VALUES(2593, '2017 Mexican Grand Prix - qualifying', '2017-10-28', 0, 3); +INSERT INTO `races` VALUES(2594, '2017 Mexican Grand Prix', '2017-10-29', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -59544,6 +59546,45 @@ INSERT INTO `entries` VALUES(55721, 'R', 14, 0, 2592); INSERT INTO `entries` VALUES(55722, 'R', 3, 0, 2592); INSERT INTO `entries` VALUES(55723, 'R', 94, 6, 2592); INSERT INTO `entries` VALUES(55724, 'R', 27, 0, 2592); +INSERT INTO `entries` VALUES(55725, '1', 5, 1, 2593); +INSERT INTO `entries` VALUES(55726, '2', 33, 2, 2593); +INSERT INTO `entries` VALUES(55727, '3', 44, 3, 2593); +INSERT INTO `entries` VALUES(55728, '4', 77, 4, 2593); +INSERT INTO `entries` VALUES(55729, '5', 7, 5, 2593); +INSERT INTO `entries` VALUES(55730, '6', 31, 6, 2593); +INSERT INTO `entries` VALUES(55731, '7', 3, 7, 2593); +INSERT INTO `entries` VALUES(55732, '8', 27, 8, 2593); +INSERT INTO `entries` VALUES(55733, '9', 55, 9, 2593); +INSERT INTO `entries` VALUES(55734, '10', 11, 10, 2593); +INSERT INTO `entries` VALUES(55735, '11', 19, 11, 2593); +INSERT INTO `entries` VALUES(55736, '12', 18, 12, 2593); +INSERT INTO `entries` VALUES(55737, '13', 28, 13, 2593); +INSERT INTO `entries` VALUES(55738, '14', 14, 14, 2593); +INSERT INTO `entries` VALUES(55739, '15', 2, 15, 2593); +INSERT INTO `entries` VALUES(55740, '16', 9, 16, 2593); +INSERT INTO `entries` VALUES(55741, '17', 94, 17, 2593); +INSERT INTO `entries` VALUES(55742, '18', 20, 18, 2593); +INSERT INTO `entries` VALUES(55743, '19', 8, 19, 2593); +INSERT INTO `entries` VALUES(55744, '1', 33, 1, 2594); +INSERT INTO `entries` VALUES(55745, '2', 77, 2, 2594); +INSERT INTO `entries` VALUES(55746, '3', 7, 2, 2594); +INSERT INTO `entries` VALUES(55747, '4', 5, 3, 2594); +INSERT INTO `entries` VALUES(55748, '5', 31, 4, 2594); +INSERT INTO `entries` VALUES(55749, '6', 18, 4, 2594); +INSERT INTO `entries` VALUES(55750, '7', 11, 4, 2594); +INSERT INTO `entries` VALUES(55751, '8', 20, 4, 2594); +INSERT INTO `entries` VALUES(55752, '9', 44, 4, 2594); +INSERT INTO `entries` VALUES(55753, '10', 14, 4, 2594); +INSERT INTO `entries` VALUES(55754, '11', 19, 4, 2594); +INSERT INTO `entries` VALUES(55755, '12', 2, 4, 2594); +INSERT INTO `entries` VALUES(55756, '13', 10, 4, 2594); +INSERT INTO `entries` VALUES(55757, '14', 94, 5, 2594); +INSERT INTO `entries` VALUES(55758, '15', 8, 5, 2594); +INSERT INTO `entries` VALUES(55759, 'R', 55, 0, 2594); +INSERT INTO `entries` VALUES(55760, 'R', 9, 0, 2594); +INSERT INTO `entries` VALUES(55761, 'R', 28, 0, 2594); +INSERT INTO `entries` VALUES(55762, 'R', 27, 0, 2594); +INSERT INTO `entries` VALUES(55763, 'R', 3, 0, 2594); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -115409,3 +115450,42 @@ INSERT INTO `driver_entries` VALUES(1127, 55721, 55861); INSERT INTO `driver_entries` VALUES(1157, 55722, 55862); INSERT INTO `driver_entries` VALUES(1177, 55723, 55863); INSERT INTO `driver_entries` VALUES(1148, 55724, 55864); +INSERT INTO `driver_entries` VALUES(1135, 55725, 55865); +INSERT INTO `driver_entries` VALUES(1172, 55726, 55866); +INSERT INTO `driver_entries` VALUES(1140, 55727, 55867); +INSERT INTO `driver_entries` VALUES(1161, 55728, 55868); +INSERT INTO `driver_entries` VALUES(1141, 55729, 55869); +INSERT INTO `driver_entries` VALUES(1179, 55730, 55870); +INSERT INTO `driver_entries` VALUES(1157, 55731, 55871); +INSERT INTO `driver_entries` VALUES(1148, 55732, 55872); +INSERT INTO `driver_entries` VALUES(1170, 55733, 55873); +INSERT INTO `driver_entries` VALUES(1155, 55734, 55874); +INSERT INTO `driver_entries` VALUES(1142, 55735, 55875); +INSERT INTO `driver_entries` VALUES(1181, 55736, 55876); +INSERT INTO `driver_entries` VALUES(1183, 55737, 55877); +INSERT INTO `driver_entries` VALUES(1127, 55738, 55878); +INSERT INTO `driver_entries` VALUES(1178, 55739, 55879); +INSERT INTO `driver_entries` VALUES(1167, 55740, 55880); +INSERT INTO `driver_entries` VALUES(1177, 55741, 55881); +INSERT INTO `driver_entries` VALUES(1165, 55742, 55882); +INSERT INTO `driver_entries` VALUES(1144, 55743, 55883); +INSERT INTO `driver_entries` VALUES(1172, 55744, 55884); +INSERT INTO `driver_entries` VALUES(1161, 55745, 55885); +INSERT INTO `driver_entries` VALUES(1141, 55746, 55886); +INSERT INTO `driver_entries` VALUES(1135, 55747, 55887); +INSERT INTO `driver_entries` VALUES(1179, 55748, 55888); +INSERT INTO `driver_entries` VALUES(1181, 55749, 55889); +INSERT INTO `driver_entries` VALUES(1155, 55750, 55890); +INSERT INTO `driver_entries` VALUES(1165, 55751, 55891); +INSERT INTO `driver_entries` VALUES(1140, 55752, 55892); +INSERT INTO `driver_entries` VALUES(1127, 55753, 55893); +INSERT INTO `driver_entries` VALUES(1142, 55754, 55894); +INSERT INTO `driver_entries` VALUES(1178, 55755, 55895); +INSERT INTO `driver_entries` VALUES(1182, 55756, 55896); +INSERT INTO `driver_entries` VALUES(1177, 55757, 55897); +INSERT INTO `driver_entries` VALUES(1144, 55758, 55898); +INSERT INTO `driver_entries` VALUES(1170, 55759, 55899); +INSERT INTO `driver_entries` VALUES(1167, 55760, 55900); +INSERT INTO `driver_entries` VALUES(1183, 55761, 55901); +INSERT INTO `driver_entries` VALUES(1148, 55762, 55902); +INSERT INTO `driver_entries` VALUES(1157, 55763, 55903); -- cgit v1.2.3