From 55e179240486db891a6517c248fdec3fa7e2f33e Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 11 Sep 2018 00:53:18 +0200 Subject: 2018 Belgian GP 2018 Italian GP --- rate.log | 108 +++++++++++++++++++++++++++++++++++++ sql/results.sql | 164 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 272 insertions(+) diff --git a/rate.log b/rate.log index fe60691..2e2c152 100644 --- a/rate.log +++ b/rate.log @@ -74674,3 +74674,111 @@ Podium rating: 7477.73 7555.28 Average rating: 2181.164 Average rating change: 35.7135294118 +2018 Belgian Grand Prix - qualifying (2018-08-25) + +#44 () 1[1] 2628.24 2630.23 +#5 () 2[2] 2388.24 2394.02 +#31 () 3[3] 2093.46 2108.77 +#11 () 4[4] 2109.97 2122.94 +#8 () 5[5] 2073.67 2086.67 +#7 () 6[6] 2538.8 2534.41 +#33 () 7[7] 2430.05 2426.66 +#3 () 8[8] 2397.07 2392.99 +#20 () 9[9] 2134.55 2138.43 +#77 () 10[10] 2473.34 2464.04 +#10 () 11[11] 2149.01 2149.06 +#28 () 12[12] 2042.02 2045.24 +#16 () 13[13] 2022.44 2024.92 +#9 () 14[14] 1959.06 1962.96 +#27 () 15[15] 2192.03 2183.06 +#55 () 16[16] 2085.25 2079.33 +#14 () 17[17] 2145.07 2134.89 +#35 () 18[18] 1885.45 1883.33 +#18 () 19[19] 1868.92 1865.09 +#2 () 20[20] 2006.63 1996.2 + +Podium rating: 7109.94 7133.02 +Average rating: 2181.1635 +Average rating change: 6.2595 + +2018 Belgian Grand Prix (2018-08-26) + +#5 () 1[1] 2394.02 2446.34 +#44 () 2[2] 2630.23 2618.22 +#33 () 3[2] 2426.66 2447.53 +#77 () 4[3] 2464.04 2445.19 +#11 () 5[3] 2122.94 2211.96 +#31 () 6[4] 2108.77 2156.06 +#8 () 7[4] 2086.67 2143.85 +#20 () 8[4] 2138.43 2172.7 +#10 () 9[4] 2149.06 2178.76 +#9 () 10[5] 1962.96 1989.52 +#55 () 11[5] 2079.33 2043.82 +#35 () 12[5] 1883.33 1947.94 +#18 () 13[5] 1865.09 1937.14 +#28 () 14[5] 2045.24 2025.1 +#2 () 15[5] 1996.2 2004.53 +#3 () R[0] 2392.99 2392.99 +#7 () R[0] 2534.41 2534.41 +#16 () R[6] 2024.92 1925.87 +#14 () R[6] 2134.89 1986.69 +#27 () R[6] 2183.06 2014.62 + +Podium rating: 7450.91 7512.09 +Average rating: 2181.162 +Average rating change: 55.8 + +2018 Italian Grand Prix - qualifying (2018-09-01) + +#7 () 1[1] 2534.41 2538.24 +#5 () 2[2] 2446.34 2450.72 +#44 () 3[3] 2618.22 2617.24 +#77 () 4[4] 2445.19 2446.4 +#33 () 5[5] 2447.53 2447.08 +#8 () 6[6] 2143.85 2152.49 +#55 () 7[7] 2043.82 2055.5 +#31 () 8[8] 2156.06 2160.96 +#10 () 9[9] 2178.76 2181.08 +#18 () 10[10] 1937.14 1951.52 +#20 () 11[11] 2172.7 2171.28 +#35 () 12[12] 1947.94 1956.95 +#14 () 13[13] 1986.69 1991.15 +#27 () 14[14] 2014.62 2014.08 +#3 () 15[15] 2392.99 2375.67 +#11 () 16[16] 2211.96 2199.31 +#16 () 17[17] 1925.87 1924.03 +#28 () 18[18] 2025.1 2016.86 +#9 () 19[19] 1989.52 1979.42 +#2 () 20[20] 2004.53 1993.26 + +Podium rating: 7598.97 7606.2 +Average rating: 2181.162 +Average rating change: 6.481 + +2018 Italian Grand Prix (2018-09-02) + +#44 () 1[1] 2617.24 2636.91 +#7 () 2[2] 2538.24 2547.31 +#77 () 3[2] 2446.4 2474.84 +#5 () 4[3] 2450.72 2446.17 +#33 () 5[3] 2447.08 2443.36 +#8 () 6[4] 2152.49 2189.79 +#31 () 7[4] 2160.96 2195.04 +#11 () 8[4] 2199.31 2219.25 +#55 () 9[4] 2055.5 2131.56 +#18 () 10[5] 1951.52 1952.49 +#35 () 11[5] 1956.95 1955.48 +#16 () 12[5] 1924.03 1936.87 +#2 () 13[5] 1993.26 1974.81 +#27 () 14[5] 2014.08 1991.0 +#10 () 15[5] 2181.08 2091.64 +#9 () 16[5] 1979.42 1967.57 +#20 () 17[5] 2171.28 2085.47 +#3 () R[0] 2375.67 2375.67 +#14 () R[0] 1991.15 1991.15 +#28 () R[0] 2016.86 2016.86 + +Podium rating: 7601.88 7659.06 +Average rating: 2181.162 +Average rating change: 28.0435294118 + diff --git a/sql/results.sql b/sql/results.sql index 0e07d09..1b88098 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2625,6 +2625,10 @@ INSERT INTO `races` VALUES(2619, '2018 German Grand Prix - qualifying', '2018-07 INSERT INTO `races` VALUES(2620, '2018 German Grand Prix', '2018-07-22', 0, 4); INSERT INTO `races` VALUES(2621, '2018 Hungarian Grand Prix - qualifying', '2018-07-28', 0, 3); INSERT INTO `races` VALUES(2622, '2018 Hungarian Grand Prix', '2018-07-29', 0, 4); +INSERT INTO `races` VALUES(2623, '2018 Belgian Grand Prix - qualifying', '2018-08-25', 0, 3); +INSERT INTO `races` VALUES(2624, '2018 Belgian Grand Prix', '2018-08-26', 0, 4); +INSERT INTO `races` VALUES(2625, '2018 Italian Grand Prix - qualifying', '2018-09-01', 0, 3); +INSERT INTO `races` VALUES(2626, '2018 Italian Grand Prix', '2018-09-02', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -60175,6 +60179,86 @@ INSERT INTO `entries` VALUES(56320, '17', 18, 6, 2622); INSERT INTO `entries` VALUES(56321, 'R', 2, 0, 2622); INSERT INTO `entries` VALUES(56322, 'R', 33, 0, 2622); INSERT INTO `entries` VALUES(56323, 'R', 16, 0, 2622); +INSERT INTO `entries` VALUES(56324, '1', 44, 1, 2623); +INSERT INTO `entries` VALUES(56325, '2', 5, 2, 2623); +INSERT INTO `entries` VALUES(56326, '3', 31, 3, 2623); +INSERT INTO `entries` VALUES(56327, '4', 11, 4, 2623); +INSERT INTO `entries` VALUES(56328, '5', 8, 5, 2623); +INSERT INTO `entries` VALUES(56329, '6', 7, 6, 2623); +INSERT INTO `entries` VALUES(56330, '7', 33, 7, 2623); +INSERT INTO `entries` VALUES(56331, '8', 3, 8, 2623); +INSERT INTO `entries` VALUES(56332, '9', 20, 9, 2623); +INSERT INTO `entries` VALUES(56333, '10', 77, 10, 2623); +INSERT INTO `entries` VALUES(56334, '11', 10, 11, 2623); +INSERT INTO `entries` VALUES(56335, '12', 28, 12, 2623); +INSERT INTO `entries` VALUES(56336, '13', 16, 13, 2623); +INSERT INTO `entries` VALUES(56337, '14', 9, 14, 2623); +INSERT INTO `entries` VALUES(56338, '15', 27, 15, 2623); +INSERT INTO `entries` VALUES(56339, '16', 55, 16, 2623); +INSERT INTO `entries` VALUES(56340, '17', 14, 17, 2623); +INSERT INTO `entries` VALUES(56341, '18', 35, 18, 2623); +INSERT INTO `entries` VALUES(56342, '19', 18, 19, 2623); +INSERT INTO `entries` VALUES(56343, '20', 2, 20, 2623); +INSERT INTO `entries` VALUES(56344, '1', 5, 1, 2624); +INSERT INTO `entries` VALUES(56345, '2', 44, 2, 2624); +INSERT INTO `entries` VALUES(56346, '3', 33, 2, 2624); +INSERT INTO `entries` VALUES(56347, '4', 77, 3, 2624); +INSERT INTO `entries` VALUES(56348, '5', 11, 3, 2624); +INSERT INTO `entries` VALUES(56349, '6', 31, 4, 2624); +INSERT INTO `entries` VALUES(56350, '7', 8, 4, 2624); +INSERT INTO `entries` VALUES(56351, '8', 20, 4, 2624); +INSERT INTO `entries` VALUES(56352, '9', 10, 4, 2624); +INSERT INTO `entries` VALUES(56353, '10', 9, 5, 2624); +INSERT INTO `entries` VALUES(56354, '11', 55, 5, 2624); +INSERT INTO `entries` VALUES(56355, '12', 35, 5, 2624); +INSERT INTO `entries` VALUES(56356, '13', 18, 5, 2624); +INSERT INTO `entries` VALUES(56357, '14', 28, 5, 2624); +INSERT INTO `entries` VALUES(56358, '15', 2, 5, 2624); +INSERT INTO `entries` VALUES(56359, 'R', 3, 0, 2624); +INSERT INTO `entries` VALUES(56360, 'R', 7, 0, 2624); +INSERT INTO `entries` VALUES(56361, 'R', 16, 6, 2624); +INSERT INTO `entries` VALUES(56362, 'R', 14, 6, 2624); +INSERT INTO `entries` VALUES(56363, 'R', 27, 6, 2624); +INSERT INTO `entries` VALUES(56364, '1', 7, 1, 2625); +INSERT INTO `entries` VALUES(56365, '2', 5, 2, 2625); +INSERT INTO `entries` VALUES(56366, '3', 44, 3, 2625); +INSERT INTO `entries` VALUES(56367, '4', 77, 4, 2625); +INSERT INTO `entries` VALUES(56368, '5', 33, 5, 2625); +INSERT INTO `entries` VALUES(56369, '6', 8, 6, 2625); +INSERT INTO `entries` VALUES(56370, '7', 55, 7, 2625); +INSERT INTO `entries` VALUES(56371, '8', 31, 8, 2625); +INSERT INTO `entries` VALUES(56372, '9', 10, 9, 2625); +INSERT INTO `entries` VALUES(56373, '10', 18, 10, 2625); +INSERT INTO `entries` VALUES(56374, '11', 20, 11, 2625); +INSERT INTO `entries` VALUES(56375, '12', 35, 12, 2625); +INSERT INTO `entries` VALUES(56376, '13', 14, 13, 2625); +INSERT INTO `entries` VALUES(56377, '14', 27, 14, 2625); +INSERT INTO `entries` VALUES(56378, '15', 3, 15, 2625); +INSERT INTO `entries` VALUES(56379, '16', 11, 16, 2625); +INSERT INTO `entries` VALUES(56380, '17', 16, 17, 2625); +INSERT INTO `entries` VALUES(56381, '18', 28, 18, 2625); +INSERT INTO `entries` VALUES(56382, '19', 9, 19, 2625); +INSERT INTO `entries` VALUES(56383, '20', 2, 20, 2625); +INSERT INTO `entries` VALUES(56384, '1', 44, 1, 2626); +INSERT INTO `entries` VALUES(56385, '2', 7, 2, 2626); +INSERT INTO `entries` VALUES(56386, '3', 77, 2, 2626); +INSERT INTO `entries` VALUES(56387, '4', 5, 3, 2626); +INSERT INTO `entries` VALUES(56388, '5', 33, 3, 2626); +INSERT INTO `entries` VALUES(56389, '6', 8, 4, 2626); +INSERT INTO `entries` VALUES(56390, '7', 31, 4, 2626); +INSERT INTO `entries` VALUES(56391, '8', 11, 4, 2626); +INSERT INTO `entries` VALUES(56392, '9', 55, 4, 2626); +INSERT INTO `entries` VALUES(56393, '10', 18, 5, 2626); +INSERT INTO `entries` VALUES(56394, '11', 35, 5, 2626); +INSERT INTO `entries` VALUES(56395, '12', 16, 5, 2626); +INSERT INTO `entries` VALUES(56396, '13', 2, 5, 2626); +INSERT INTO `entries` VALUES(56397, '14', 27, 5, 2626); +INSERT INTO `entries` VALUES(56398, '15', 10, 5, 2626); +INSERT INTO `entries` VALUES(56399, '16', 9, 5, 2626); +INSERT INTO `entries` VALUES(56400, '17', 20, 5, 2626); +INSERT INTO `entries` VALUES(56401, 'R', 3, 0, 2626); +INSERT INTO `entries` VALUES(56402, 'R', 14, 0, 2626); +INSERT INTO `entries` VALUES(56403, 'R', 28, 0, 2626); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -116639,3 +116723,83 @@ INSERT INTO `driver_entries` VALUES(1181, 56320, 56460); INSERT INTO `driver_entries` VALUES(1178, 56321, 56461); INSERT INTO `driver_entries` VALUES(1172, 56322, 56462); INSERT INTO `driver_entries` VALUES(1184, 56323, 56463); +INSERT INTO `driver_entries` VALUES(1140, 56324, 56464); +INSERT INTO `driver_entries` VALUES(1135, 56325, 56465); +INSERT INTO `driver_entries` VALUES(1179, 56326, 56466); +INSERT INTO `driver_entries` VALUES(1155, 56327, 56467); +INSERT INTO `driver_entries` VALUES(1144, 56328, 56468); +INSERT INTO `driver_entries` VALUES(1141, 56329, 56469); +INSERT INTO `driver_entries` VALUES(1172, 56330, 56470); +INSERT INTO `driver_entries` VALUES(1157, 56331, 56471); +INSERT INTO `driver_entries` VALUES(1165, 56332, 56472); +INSERT INTO `driver_entries` VALUES(1161, 56333, 56473); +INSERT INTO `driver_entries` VALUES(1182, 56334, 56474); +INSERT INTO `driver_entries` VALUES(1183, 56335, 56475); +INSERT INTO `driver_entries` VALUES(1184, 56336, 56476); +INSERT INTO `driver_entries` VALUES(1167, 56337, 56477); +INSERT INTO `driver_entries` VALUES(1148, 56338, 56478); +INSERT INTO `driver_entries` VALUES(1170, 56339, 56479); +INSERT INTO `driver_entries` VALUES(1127, 56340, 56480); +INSERT INTO `driver_entries` VALUES(1185, 56341, 56481); +INSERT INTO `driver_entries` VALUES(1181, 56342, 56482); +INSERT INTO `driver_entries` VALUES(1178, 56343, 56483); +INSERT INTO `driver_entries` VALUES(1135, 56344, 56484); +INSERT INTO `driver_entries` VALUES(1140, 56345, 56485); +INSERT INTO `driver_entries` VALUES(1172, 56346, 56486); +INSERT INTO `driver_entries` VALUES(1161, 56347, 56487); +INSERT INTO `driver_entries` VALUES(1155, 56348, 56488); +INSERT INTO `driver_entries` VALUES(1179, 56349, 56489); +INSERT INTO `driver_entries` VALUES(1144, 56350, 56490); +INSERT INTO `driver_entries` VALUES(1165, 56351, 56491); +INSERT INTO `driver_entries` VALUES(1182, 56352, 56492); +INSERT INTO `driver_entries` VALUES(1167, 56353, 56493); +INSERT INTO `driver_entries` VALUES(1170, 56354, 56494); +INSERT INTO `driver_entries` VALUES(1185, 56355, 56495); +INSERT INTO `driver_entries` VALUES(1181, 56356, 56496); +INSERT INTO `driver_entries` VALUES(1183, 56357, 56497); +INSERT INTO `driver_entries` VALUES(1178, 56358, 56498); +INSERT INTO `driver_entries` VALUES(1157, 56359, 56499); +INSERT INTO `driver_entries` VALUES(1141, 56360, 56500); +INSERT INTO `driver_entries` VALUES(1184, 56361, 56501); +INSERT INTO `driver_entries` VALUES(1127, 56362, 56502); +INSERT INTO `driver_entries` VALUES(1148, 56363, 56503); +INSERT INTO `driver_entries` VALUES(1141, 56364, 56504); +INSERT INTO `driver_entries` VALUES(1135, 56365, 56505); +INSERT INTO `driver_entries` VALUES(1140, 56366, 56506); +INSERT INTO `driver_entries` VALUES(1161, 56367, 56507); +INSERT INTO `driver_entries` VALUES(1172, 56368, 56508); +INSERT INTO `driver_entries` VALUES(1144, 56369, 56509); +INSERT INTO `driver_entries` VALUES(1170, 56370, 56510); +INSERT INTO `driver_entries` VALUES(1179, 56371, 56511); +INSERT INTO `driver_entries` VALUES(1182, 56372, 56512); +INSERT INTO `driver_entries` VALUES(1181, 56373, 56513); +INSERT INTO `driver_entries` VALUES(1165, 56374, 56514); +INSERT INTO `driver_entries` VALUES(1185, 56375, 56515); +INSERT INTO `driver_entries` VALUES(1127, 56376, 56516); +INSERT INTO `driver_entries` VALUES(1148, 56377, 56517); +INSERT INTO `driver_entries` VALUES(1157, 56378, 56518); +INSERT INTO `driver_entries` VALUES(1155, 56379, 56519); +INSERT INTO `driver_entries` VALUES(1184, 56380, 56520); +INSERT INTO `driver_entries` VALUES(1183, 56381, 56521); +INSERT INTO `driver_entries` VALUES(1167, 56382, 56522); +INSERT INTO `driver_entries` VALUES(1178, 56383, 56523); +INSERT INTO `driver_entries` VALUES(1140, 56384, 56524); +INSERT INTO `driver_entries` VALUES(1141, 56385, 56525); +INSERT INTO `driver_entries` VALUES(1161, 56386, 56526); +INSERT INTO `driver_entries` VALUES(1135, 56387, 56527); +INSERT INTO `driver_entries` VALUES(1172, 56388, 56528); +INSERT INTO `driver_entries` VALUES(1144, 56389, 56529); +INSERT INTO `driver_entries` VALUES(1179, 56390, 56530); +INSERT INTO `driver_entries` VALUES(1155, 56391, 56531); +INSERT INTO `driver_entries` VALUES(1170, 56392, 56532); +INSERT INTO `driver_entries` VALUES(1181, 56393, 56533); +INSERT INTO `driver_entries` VALUES(1185, 56394, 56534); +INSERT INTO `driver_entries` VALUES(1184, 56395, 56535); +INSERT INTO `driver_entries` VALUES(1178, 56396, 56536); +INSERT INTO `driver_entries` VALUES(1148, 56397, 56537); +INSERT INTO `driver_entries` VALUES(1182, 56398, 56538); +INSERT INTO `driver_entries` VALUES(1167, 56399, 56539); +INSERT INTO `driver_entries` VALUES(1165, 56400, 56540); +INSERT INTO `driver_entries` VALUES(1157, 56401, 56541); +INSERT INTO `driver_entries` VALUES(1127, 56402, 56542); +INSERT INTO `driver_entries` VALUES(1183, 56403, 56543); -- cgit v1.2.3