1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
-- 1961 US GP, Gendebien/Gregory shared drive
INSERT INTO results(raceId, driverId, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId) (SELECT raceId, 418, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId FROM results WHERE raceId = 745 AND number = 21);
-- 1964 US GP, Spence/Clark shared drive
INSERT INTO results(raceId, driverId, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId) (SELECT raceId, 373, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId FROM results WHERE raceId = 717 AND number = 2);
-- 1971 Italian GP, Andrea de Adamich
UPDATE results SET positionOrder = positionOrder+1 WHERE positionOrder > 16 AND raceId = 633;
INSERT INTO results(raceId, driverId, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId) VALUES(633, 333, 199, 17, 18, NULL, 'R', 17, 0, 26, NULL, NULL, NULL, NULL, NULL, 7);
-- 1978 US and Canadian GP, Arnoux's number
UPDATE results SET number = 18 WHERE number = 31 AND raceId IN (541, 542);
-- 1984 British GP, Corrado Fabi -> Teo Fabi
UPDATE results SET driverId = 170 WHERE driverId = 190 AND raceId = 445;
-- 2017 US GP, Ferrari numbers
UPDATE results SET `number` = 5 WHERE resultId = 23703;
UPDATE results SET `number` = 7 WHERE resultId = 23704;
-- Q1
-- 2008 Bahrain GP, Vettel, Sutil
UPDATE qualifying SET q1 = '1:33.562' WHERE qualifyId = 63;
UPDATE qualifying SET q1 = '1:33.845' WHERE qualifyId = 64;
-- 1998 Brazilian GP, Magnussen
UPDATE qualifying SET q1 = '1:19.644' WHERE qualifyId = 1693;
-- 1997 Brazilian GP, Panis
UPDATE qualifying SET q1 = '1:16.756' WHERE qualifyId = 1835;
-- 2012 British GP, Karthikeyan
UPDATE qualifying SET q1 = '1:53.040' WHERE qualifyId = 5178;
-- 2014 German GP, Bianchi
UPDATE qualifying SET q1 = '1:19.676' WHERE qualifyId = 6099;
-- Q2
-- 2011 Monaco GP, Di Resta
UPDATE qualifying SET q2 = '1:16.118' WHERE qualifyId = 4669;
-- 2013 Singapore GP, Raikkonen
UPDATE qualifying SET q2 = '1:44.658' WHERE qualifyId = 5718;
|
