From 5ad0561758d295150ae621ba3187d8a99cc8f8bf Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 4 Nov 2014 11:42:21 +0100 Subject: * grid/qualy consistency check SQL --- doc/sql.txt | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/doc/sql.txt b/doc/sql.txt index 32e7fa3..4d54f70 100644 --- a/doc/sql.txt +++ b/doc/sql.txt @@ -63,3 +63,7 @@ SELECT YEAR(rank_date), FROM rankings GROUP BY YEAR(rank_date) ORDER BY YEAR(rank_date) ASC; + + - qualifying/grid sanity check + +SELECT drivers.number, drivers.forename, drivers.surname, races.year, races.name, qualifying.number, qualifying.position, qualifying.q1, qualifying.q2, qualifying.q3, results.grid, results.number FROM qualifying INNER JOIN results ON (qualifying.driverID = results.driverId) AND (qualifying.raceId = results.raceId) JOIN drivers ON drivers.driverId = results.driverId JOIN races ON results.raceId = races.raceId WHERE qualifying.position <> results.grid ORDER BY races.date ASC -- cgit v1.2.3 From 49f8e142e55e1cba6b7826ed9facdcf4dd5d32d3 Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 4 Nov 2014 16:30:33 +0100 Subject: * qualifying-grid consistency check dump --- dumps/qualifying.csv | Bin 0 -> 132807 bytes 1 file changed, 0 insertions(+), 0 deletions(-) create mode 100644 dumps/qualifying.csv diff --git a/dumps/qualifying.csv b/dumps/qualifying.csv new file mode 100644 index 0000000..67235de Binary files /dev/null and b/dumps/qualifying.csv differ -- cgit v1.2.3 From 6afa9f129823f7279ed8809f7bcb4c3b5d345859 Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 4 Nov 2014 16:31:30 +0100 Subject: * file rename --- dumps/qualifying.csv | Bin 132807 -> 0 bytes dumps/qualifying.ods | Bin 0 -> 132807 bytes 2 files changed, 0 insertions(+), 0 deletions(-) delete mode 100644 dumps/qualifying.csv create mode 100644 dumps/qualifying.ods diff --git a/dumps/qualifying.csv b/dumps/qualifying.csv deleted file mode 100644 index 67235de..0000000 Binary files a/dumps/qualifying.csv and /dev/null differ diff --git a/dumps/qualifying.ods b/dumps/qualifying.ods new file mode 100644 index 0000000..67235de Binary files /dev/null and b/dumps/qualifying.ods differ -- cgit v1.2.3