diff options
| -rw-r--r-- | import/01a_integrity_fixes.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/import/01a_integrity_fixes.sql b/import/01a_integrity_fixes.sql index 559a576..1a57c1e 100644 --- a/import/01a_integrity_fixes.sql +++ b/import/01a_integrity_fixes.sql @@ -1,3 +1,6 @@ UPDATE qualifying SET q1 = NULL WHERE q1 = ''; UPDATE qualifying SET q2 = NULL WHERE q2 = ''; UPDATE qualifying SET q3 = NULL WHERE q3 = ''; + +DELETE FROM constructorStandings WHERE raceId NOT IN (SELECT raceId FROM races); +DELETE FROM driverStandings WHERE raceId NOT IN (SELECT raceId FROM races); |