From 629352f0146f1e096bfe61cb604bbf848145f844 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Wed, 30 Mar 2005 14:53:18 +0000 Subject: [PATCH] Add scripts and example SQL for parsing the EM2 series from 2002. --- parse/parse-ddreurope-tournament.pl | 3 +- sql/basic-data.sql | 1 + sql/em2-series/em2s01.sql | 956 +++++++++++++++++++ sql/em2-series/em2s02.sql | 90 ++ sql/em2-series/em2s03.sql | 72 ++ sql/em2-series/em2s04.sql | 1316 +++++++++++++++++++++++++++ sql/em2-series/em2s05.sql | 652 +++++++++++++ sql/em2-series/em2s06.sql | 72 ++ sql/em2-series/em2s07.sql | 78 ++ sql/em2-series/em2s08.sql | 54 ++ sql/em2-series/em2s09.sql | 48 + sql/em2-series/em2s10.sql | 60 ++ sql/em2-series/em2s11.sql | 78 ++ sql/em2-series/update-em2s.sh | 23 + 14 files changed, 3502 insertions(+), 1 deletion(-) create mode 100644 sql/em2-series/em2s01.sql create mode 100644 sql/em2-series/em2s02.sql create mode 100644 sql/em2-series/em2s03.sql create mode 100644 sql/em2-series/em2s04.sql create mode 100644 sql/em2-series/em2s05.sql create mode 100644 sql/em2-series/em2s06.sql create mode 100644 sql/em2-series/em2s07.sql create mode 100644 sql/em2-series/em2s08.sql create mode 100644 sql/em2-series/em2s09.sql create mode 100644 sql/em2-series/em2s10.sql create mode 100644 sql/em2-series/em2s11.sql create mode 100755 sql/em2-series/update-em2s.sh diff --git a/parse/parse-ddreurope-tournament.pl b/parse/parse-ddreurope-tournament.pl index 7fce29e..e3d6ba5 100644 --- a/parse/parse-ddreurope-tournament.pl +++ b/parse/parse-ddreurope-tournament.pl @@ -24,6 +24,7 @@ while (<>) { /x) { my ($country, $location, $date, $mix, $system) = ($1, $2, $3, $4, $5); $mix =~ s/Euromix/EuroMix/; + $system = '10K Machine score' if ($system =~ /^\s*$/); print "INSERT INTO tournaments \n"; print " (season, tournamentname, country, location, \"date\", machine, scoringsystem) VALUES (\n"; @@ -51,7 +52,7 @@ while (<>) { } # Player's results (score) - if (//x) { + if (//x) { my $i = 0; # random songs diff --git a/sql/basic-data.sql b/sql/basic-data.sql index 532d2eb..032b7eb 100644 --- a/sql/basic-data.sql +++ b/sql/basic-data.sql @@ -4,6 +4,7 @@ INSERT INTO machines (machinename) VALUES ('DDR Extreme'); INSERT INTO scoringsystems (scoringsystemname) VALUES ('10K Machine score'); INSERT INTO countries (countryname, countrycode) VALUES ('Europe', 'EUR'); -- special exception INSERT INTO seasons (seasonname) VALUES ('European Cup'); +INSERT INTO seasons (seasonname) VALUES ('Euromix 2-serie 2002'); INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2003'); INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2004'); INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2005'); diff --git a/sql/em2-series/em2s01.sql b/sql/em2-series/em2s01.sql new file mode 100644 index 0000000..3797eb4 --- /dev/null +++ b/sql/em2-series/em2s01.sql @@ -0,0 +1,956 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 01', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-10-06', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Daniil'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lars Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lars Christian' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Lars Christian'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Havok'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Th0rny'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Eilin'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Slusk'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Snute'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oxehunden' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oxehunden' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + (SELECT player FROM players WHERE nick='Oxehunden'), + 7); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + (SELECT player FROM players WHERE nick='Lejordet'), + 6); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Oxehunden'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Oxehunden'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5718); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5399); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 5843); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Snute'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 4850); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 3952); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 6082); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Havok'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), + 't', + 6534); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 5590); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5676); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 10 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5029); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5154); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 5482); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5057); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 6504); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 5946); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Oxehunden'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Oxehunden'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 0); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 4944); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 't', + 4074); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Havok'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 't', + 3193); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=3; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=3; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Havok'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6893); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6273); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 5373); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 4789); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 0); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 4197); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 4718); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5432); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=4; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=4; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 't', + 4920); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6120); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 't', + 4372); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 4993); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 5929); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 5577); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Havok'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 5528); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=5; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=5; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), + 't', + 4424); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5295); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Havok'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 5113); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 4967); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5947); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 't', + 5494); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=6; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=6; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 4618); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Havok'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 6345); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), + 't', + 5194); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 5447); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 5159); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=7; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=7; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 5817); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 0); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 5639); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Havok'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5035); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=8; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=8; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Havok'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 't', + 4334); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 't', + 4793); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 6059); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=9; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 6664); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 7011); +commit; diff --git a/sql/em2-series/em2s02.sql b/sql/em2-series/em2s02.sql new file mode 100644 index 0000000..3861008 --- /dev/null +++ b/sql/em2-series/em2s02.sql @@ -0,0 +1,90 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 02', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-10-13', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Daniil'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lars Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lars Christian' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Lars Christian'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Tom'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Draconia'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Slusk'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Snute'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Th0rny'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Magnar'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + (SELECT player FROM players WHERE nick='Eilin'), + 7); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Trond' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Trond' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + (SELECT player FROM players WHERE nick='Trond'), + 6); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, + (SELECT player FROM players WHERE nick='kjmcw'), + 5); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 12, + (SELECT player FROM players WHERE nick='Lejordet'), + 4); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniel B' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniel B' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 02' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 13, + (SELECT player FROM players WHERE nick='Daniel B'), + 3); +commit; diff --git a/sql/em2-series/em2s03.sql b/sql/em2-series/em2s03.sql new file mode 100644 index 0000000..929aad3 --- /dev/null +++ b/sql/em2-series/em2s03.sql @@ -0,0 +1,72 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 03', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-10-20', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Havok'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Daniil'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Snute'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='kjmcw'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Th0rny'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Magnar'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lars Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lars Christian' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Lars Christian'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Lejordet'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + (SELECT player FROM players WHERE nick='Slusk'), + 7); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oxehunden' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oxehunden' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 03' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + (SELECT player FROM players WHERE nick='Oxehunden'), + 6); +commit; diff --git a/sql/em2-series/em2s04.sql b/sql/em2-series/em2s04.sql new file mode 100644 index 0000000..53dbf34 --- /dev/null +++ b/sql/em2-series/em2s04.sql @@ -0,0 +1,1316 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 04', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-11-10', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Havok'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lars Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lars Christian' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Lars Christian'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Daniil'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Draconia'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ole' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Ole'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='kjmcw'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Snute'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Th0rny'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + (SELECT player FROM players WHERE nick='Lejordet'), + 7); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + (SELECT player FROM players WHERE nick='Eilin'), + 6); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, + (SELECT player FROM players WHERE nick='Slusk'), + 5); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Fiskelim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Fiskelim' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 12, + (SELECT player FROM players WHERE nick='Fiskelim'), + 4); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5459); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Fiskelim'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Fiskelim'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 3602); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5641); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 't', + 5600); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5213); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 't', + 6282); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Havok'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 't', + 5680); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), + 't', + 5289); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 4246); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 10 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 't', + 5086); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Ole'), + 11 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 't', + 5952); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 12 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 't', + 4739); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 5328); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 5769); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 6117); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 5099); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5565); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 6103); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5725); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Snute'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5996); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Havok'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5650); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Ole'), + 10 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5909); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 11 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5789); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=3; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=3; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 5538); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 5566); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Havok'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 6027); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5567); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5495); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 6390); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Ole'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6159); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 5635); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 6060); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 10 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5688); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=4; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=4; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 5747); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 5909); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 6355); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 6531); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 6616); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Havok'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 6437); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7002); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Ole'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 't', + 6191); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6140); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=5; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=5; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6935); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7196); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Ole'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7168); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6875); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Havok'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7183); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7014); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7236); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6659); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=6; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=6; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7304); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6190); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 5975); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Ole'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 6741); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Havok'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6094); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 6189); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6236); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=7; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=7; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Havok'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7202); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6512); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 4964); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 6032); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Ole'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7019); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 5492); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=8; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=8; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 't', + 5908); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 5941); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6075); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Ole'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Ole'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), + 't', + 5720); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Havok'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 6345); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=9; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=9; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 5545); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6535); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 5748); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Havok'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 6075); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=10; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=10; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 6659); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, 0, + (SELECT player FROM players WHERE nick='Havok'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7118); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 6386); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=11; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=11; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, 0, + (SELECT player FROM players WHERE nick='Lars Christian'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 't', + 6380); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, 0, + (SELECT player FROM players WHERE nick='Havok'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), + 't', + 6481); +commit; diff --git a/sql/em2-series/em2s05.sql b/sql/em2-series/em2s05.sql new file mode 100644 index 0000000..b35ef67 --- /dev/null +++ b/sql/em2-series/em2s05.sql @@ -0,0 +1,652 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 05', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-11-03', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Daniil'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Th0rny'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Snute'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='kjmcw'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Slusk'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Eilin'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'wa-ho' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'wa-ho' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='wa-ho'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Lejordet'), + 8); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 't', + 6878); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 6258); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 6467); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6284); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6256); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5421); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='wa-ho'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='wa-ho'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 5978); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lejordet'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 5326); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), + 't', + 6270); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5773); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5591); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 6276); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 5937); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='wa-ho'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='wa-ho'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 5337); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 5982); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=3; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=3; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 6276); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 't', + 5588); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6434); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Eilin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 't', + 5183); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 't', + 6249); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 5613); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=4; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=4; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6701); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7192); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6606); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='Slusk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6370); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6596); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0); +UPDATE rounds SET randomsongs=0 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=5; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=5; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 4707); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 6555); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 5718); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6329); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=6; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 6031); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 6900); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 6240); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND + round=7; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 7676); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, 0, + (SELECT player FROM players WHERE nick='Th0rny'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 7216); +commit; diff --git a/sql/em2-series/em2s06.sql b/sql/em2-series/em2s06.sql new file mode 100644 index 0000000..468cd88 --- /dev/null +++ b/sql/em2-series/em2s06.sql @@ -0,0 +1,72 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 06', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-11-10', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Th0rny'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='kjmcw'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Slusk'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Snute'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Daniil'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Lejordet'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Draconia'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Eilin'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Trond' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Trond' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + (SELECT player FROM players WHERE nick='Trond'), + 7); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Fiskelim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Fiskelim' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 06' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + (SELECT player FROM players WHERE nick='Fiskelim'), + 6); +commit; diff --git a/sql/em2-series/em2s07.sql b/sql/em2-series/em2s07.sql new file mode 100644 index 0000000..4a94bc7 --- /dev/null +++ b/sql/em2-series/em2s07.sql @@ -0,0 +1,78 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 07', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-11-17', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Th0rny'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lars Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lars Christian' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Lars Christian'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Havok'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='kjmcw'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Draconia'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Snute'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Psychofreud' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Psychofreud' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Psychofreud'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Daniil'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + (SELECT player FROM players WHERE nick='Slusk'), + 7); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + (SELECT player FROM players WHERE nick='Eilin'), + 6); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 07' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, + (SELECT player FROM players WHERE nick='Lejordet'), + 5); +commit; diff --git a/sql/em2-series/em2s08.sql b/sql/em2-series/em2s08.sql new file mode 100644 index 0000000..1cb8d02 --- /dev/null +++ b/sql/em2-series/em2s08.sql @@ -0,0 +1,54 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 08', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-11-24', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 08' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Th0rny'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 08' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Snute'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 08' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Slusk'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 08' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Draconia'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 08' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 08' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Daniil'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 08' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Lejordet'), + 9); +commit; diff --git a/sql/em2-series/em2s09.sql b/sql/em2-series/em2s09.sql new file mode 100644 index 0000000..8e596a5 --- /dev/null +++ b/sql/em2-series/em2s09.sql @@ -0,0 +1,48 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 09', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-12-01', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 09' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Th0rny'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 09' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='kjmcw'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 09' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Snute'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 09' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Daniil'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 09' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Slusk'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 09' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Lejordet'), + 11); +commit; diff --git a/sql/em2-series/em2s10.sql b/sql/em2-series/em2s10.sql new file mode 100644 index 0000000..f1b7869 --- /dev/null +++ b/sql/em2-series/em2s10.sql @@ -0,0 +1,60 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 10', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-12-08', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Th0rny'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Snute'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='Draconia'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Slusk'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Daniil'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='kjmcw'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Fiskelim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Fiskelim' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Fiskelim'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 10' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Lejordet'), + 8); +commit; diff --git a/sql/em2-series/em2s11.sql b/sql/em2-series/em2s11.sql new file mode 100644 index 0000000..3742649 --- /dev/null +++ b/sql/em2-series/em2s11.sql @@ -0,0 +1,78 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 'Euromix2 serie 11', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Akers Mic', + '2002-12-15', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 1, + (SELECT player FROM players WHERE nick='Th0rny'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 2, + (SELECT player FROM players WHERE nick='Snute'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 3, + (SELECT player FROM players WHERE nick='kjmcw'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 4, + (SELECT player FROM players WHERE nick='Daniil'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 5, + (SELECT player FROM players WHERE nick='Havok'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 6, + (SELECT player FROM players WHERE nick='Draconia'), + 11); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 7, + (SELECT player FROM players WHERE nick='Slusk'), + 9); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oxehunden' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oxehunden' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 8, + (SELECT player FROM players WHERE nick='Oxehunden'), + 8); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 9, + (SELECT player FROM players WHERE nick='Lejordet'), + 7); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 10, + (SELECT player FROM players WHERE nick='Eilin'), + 6); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Trond' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Trond' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 11' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )), + 11, + (SELECT player FROM players WHERE nick='Trond'), + 5); +commit; diff --git a/sql/em2-series/update-em2s.sh b/sql/em2-series/update-em2s.sh new file mode 100755 index 0000000..d391126 --- /dev/null +++ b/sql/em2-series/update-em2s.sh @@ -0,0 +1,23 @@ +#! /bin/sh + +SEASON="Euromix 2-serie 2002" + +( + while read ccno id; do + wget -O- "http://www.ddreurope.com/results.php?since=0&act=2&t_id=$id" | + iconv -f latin1 -t utf8 | + perl ../../parse/parse-ddreurope-tournament.pl "$SEASON" > em2s$ccno.sql + done +) <<"EOF" +01 6 +02 7 +03 8 +04 9 +05 10 +06 11 +07 12 +08 13 +09 14 +10 15 +11 16 +EOF -- 2.39.2