X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fcc04%2Fcc3-04.sql;fp=sql%2Fcc04%2Fcc3-04.sql;h=9d8a78aacbe784be086f9b9e9bc3bcde56343349;hb=69e91c419df45838d7c85633b10d0998f0f92f7a;hp=33a23c624cdbcf6c549f79c269b4f33c0267cdba;hpb=9f7b3c1a46383496e6a30e0aad8d4252e1a94fda;p=ccbs diff --git a/sql/cc04/cc3-04.sql b/sql/cc04/cc3-04.sql index 33a23c6..9d8a78a 100644 --- a/sql/cc04/cc3-04.sql +++ b/sql/cc04/cc3-04.sql @@ -1,7 +1,7 @@ begin; INSERT INTO tournaments (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( - (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'), + (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 'Challenge Cup 3', (SELECT country FROM countries WHERE countryname='Norway'), 'Askim', @@ -9,230 +9,230 @@ INSERT INTO tournaments (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, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, (SELECT player FROM players WHERE nick='Snute'), 100); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, (SELECT player FROM players WHERE nick='DufF'), 90); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hugo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, (SELECT player FROM players WHERE nick='Hugo'), 81); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, (SELECT player FROM players WHERE nick='Oliyzia'), 73); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, (SELECT player FROM players WHERE nick='RiChY'), 66); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, (SELECT player FROM players WHERE nick='OJK'), 0); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, (SELECT player FROM players WHERE nick='Haggar'), 0); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, (SELECT player FROM players WHERE nick='T|na'), 51); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 9, (SELECT player FROM players WHERE nick='Stream'), 48); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 10, (SELECT player FROM players WHERE nick='Nameless'), 0); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 11, (SELECT player FROM players WHERE nick='Ylini'), 45); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 12, (SELECT player FROM players WHERE nick='Mulefisk'), 44); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); +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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 13, (SELECT player FROM players WHERE nick='Th0rny'), 43); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 14, (SELECT player FROM players WHERE nick='Duckling'), 42); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 15, (SELECT player FROM players WHERE nick='Olemann'), 41); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 16, (SELECT player FROM players WHERE nick='Smiph'), 40); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dabi' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 17, (SELECT player FROM players WHERE nick='Dabi'), 39); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zyc' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 18, (SELECT player FROM players WHERE nick='Zyc'), 38); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 19, (SELECT player FROM players WHERE nick='Draconia'), 37); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 20, (SELECT player FROM players WHERE nick='Advena'), 36); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 21, (SELECT player FROM players WHERE nick='Bonzo'), 0); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 22, (SELECT player FROM players WHERE nick='Ted Kristian'), 34); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 23, (SELECT player FROM players WHERE nick='Jim Andre'), 33); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Glukko' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 24, (SELECT player FROM players WHERE nick='Glukko'), 32); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tassen' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 25, (SELECT player FROM players WHERE nick='Tassen'), 31); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 26, (SELECT player FROM players WHERE nick='Matsi'), 30); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick WHERE 'Gollum' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gollum' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 27, (SELECT player FROM players WHERE nick='Gollum'), 29); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'PÃ¥l Andre' AS nick WHERE 'PÃ¥l Andre' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'PÃ¥l Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'PÃ¥l Andre' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 28, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 28); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Andre' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 29, (SELECT player FROM players WHERE nick='Andre'), 27); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eruanna' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 30, (SELECT player FROM players WHERE nick='Eruanna'), 26); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Auran' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 31, (SELECT player FROM players WHERE nick='Auran'), 25); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 32, (SELECT player FROM players WHERE nick='Ole-Christian'), 24); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ted Kristian'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ted Kristian'), 0, @@ -240,7 +240,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4475); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ted Kristian'), 1, @@ -248,7 +248,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5340); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ted Kristian'), 2, @@ -256,13 +256,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7032); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 0, @@ -270,7 +270,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4760); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 1, @@ -278,7 +278,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5946); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 2, @@ -286,13 +286,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5875); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 0, @@ -300,7 +300,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5734); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 1, @@ -308,7 +308,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7095); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 2, @@ -316,13 +316,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8047); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -330,7 +330,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6356); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -338,7 +338,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7560); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), 2, @@ -346,13 +346,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7720); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -360,7 +360,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6480); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -368,7 +368,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7646); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -376,32 +376,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7702); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Jim Andre'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Jim Andre'), 0, @@ -409,7 +409,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5809); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Jim Andre'), 1, @@ -417,7 +417,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5338); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Jim Andre'), 2, @@ -425,13 +425,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6198); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Andre'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Andre'), 0, @@ -439,7 +439,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4264); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Andre'), 1, @@ -447,7 +447,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3773); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Andre'), 2, @@ -455,13 +455,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5277); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 0, @@ -469,7 +469,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5388); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 1, @@ -477,7 +477,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5249); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 2, @@ -485,13 +485,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7228); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -499,7 +499,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6226); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -507,7 +507,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6708); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 2, @@ -515,13 +515,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6445); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='OJK'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -529,7 +529,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7353); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -537,7 +537,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7214); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -545,32 +545,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6791); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Glukko'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Glukko'), 0, @@ -578,7 +578,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4346); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Glukko'), 1, @@ -586,7 +586,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3531); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Glukko'), 2, @@ -594,13 +594,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5270); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Ole-Christian'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Ole-Christian'), 0, @@ -608,7 +608,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Ole-Christian'), 1, @@ -616,13 +616,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 0); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Zyc'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Zyc'), 0, @@ -630,7 +630,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4898); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Zyc'), 1, @@ -638,7 +638,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3333); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Zyc'), 2, @@ -646,13 +646,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5149); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -660,7 +660,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5189); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -668,7 +668,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4391); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -676,13 +676,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7298); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='DufF'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -690,7 +690,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5822); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -698,7 +698,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8510); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -706,32 +706,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8504); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Th0rny'), 0, @@ -739,7 +739,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5789); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Th0rny'), 1, @@ -747,7 +747,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6214); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Th0rny'), 2, @@ -755,13 +755,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8348); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Nameless'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -769,7 +769,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5618); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -777,7 +777,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6326); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Nameless'), 2, @@ -785,13 +785,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8278); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Matsi'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Matsi'), 0, @@ -799,7 +799,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4525); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Matsi'), 1, @@ -807,7 +807,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6008); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Matsi'), 2, @@ -815,13 +815,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7040); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), 0, @@ -829,7 +829,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5716); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), 1, @@ -837,7 +837,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6169); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), 2, @@ -845,13 +845,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7682); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -859,7 +859,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6023); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -867,7 +867,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6628); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -875,32 +875,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8179); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 0, @@ -908,7 +908,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5410); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 1, @@ -916,7 +916,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4383); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 2, @@ -924,13 +924,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6040); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Advena'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Advena'), 0, @@ -938,7 +938,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6729); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Advena'), 1, @@ -946,7 +946,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7069); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Advena'), 2, @@ -954,13 +954,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7624); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tassen'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tassen'), 0, @@ -968,7 +968,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6911); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tassen'), 1, @@ -976,7 +976,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6693); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tassen'), 2, @@ -984,13 +984,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7298); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), 0, @@ -998,7 +998,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8252); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), 1, @@ -1006,7 +1006,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7357); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), 2, @@ -1014,13 +1014,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7321); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Olemann'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -1028,7 +1028,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7471); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -1036,7 +1036,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7919); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -1044,13 +1044,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8043); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='T|na'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1058,7 +1058,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8546); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1066,7 +1066,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7881); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -1074,32 +1074,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7740); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), 0, @@ -1107,7 +1107,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4564); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), 1, @@ -1115,7 +1115,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6212); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), 2, @@ -1123,13 +1123,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7211); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gollum'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gollum'), 0, @@ -1137,7 +1137,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3139); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gollum'), 1, @@ -1145,7 +1145,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5655); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gollum'), 2, @@ -1153,13 +1153,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6369); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hugo'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hugo'), 0, @@ -1167,7 +1167,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6888); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hugo'), 1, @@ -1175,7 +1175,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8521); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hugo'), 2, @@ -1183,13 +1183,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7439); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Auran'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Auran'), 0, @@ -1197,7 +1197,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3300); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Auran'), 1, @@ -1205,7 +1205,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3813); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Auran'), 2, @@ -1213,13 +1213,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4377); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Smiph'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Smiph'), 0, @@ -1227,7 +1227,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5696); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Smiph'), 1, @@ -1235,7 +1235,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7569); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Smiph'), 2, @@ -1243,13 +1243,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7703); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Stream'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1257,7 +1257,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5989); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1265,7 +1265,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7689); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -1274,36 +1274,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8064); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 0, @@ -1311,7 +1311,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5825); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 1, @@ -1319,7 +1319,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4790); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 2, @@ -1327,13 +1327,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7961); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 0, @@ -1341,7 +1341,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6533); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 1, @@ -1349,7 +1349,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5504); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Mulefisk'), 2, @@ -1357,13 +1357,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7989); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -1371,7 +1371,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7101); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -1379,7 +1379,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5725); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 2, @@ -1387,13 +1387,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8713); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Th0rny'), 0, @@ -1401,7 +1401,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6377); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Th0rny'), 1, @@ -1409,7 +1409,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4994); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Th0rny'), 2, @@ -1417,13 +1417,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8140); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='OJK'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1431,7 +1431,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7140); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1439,7 +1439,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5515); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -1447,13 +1447,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8310); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1461,7 +1461,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6447); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1469,7 +1469,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5518); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -1477,32 +1477,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8271); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Dabi'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Dabi'), 0, @@ -1510,7 +1510,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4394); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Dabi'), 1, @@ -1518,7 +1518,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4295); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Dabi'), 2, @@ -1526,13 +1526,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6188); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 0, @@ -1540,7 +1540,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5898); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 1, @@ -1548,7 +1548,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5857); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 2, @@ -1556,13 +1556,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8053); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -1570,7 +1570,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5873); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -1578,7 +1578,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5881); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -1586,13 +1586,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8283); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Stream'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1600,7 +1600,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5820); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1608,7 +1608,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6437); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -1616,13 +1616,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8232); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1630,7 +1630,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6509); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1638,7 +1638,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6858); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -1646,13 +1646,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8420); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Hugo'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Hugo'), 0, @@ -1660,7 +1660,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6424); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Hugo'), 1, @@ -1668,7 +1668,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6499); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Hugo'), 2, @@ -1676,32 +1676,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8601); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Zyc'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Zyc'), 0, @@ -1709,7 +1709,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3711); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Zyc'), 1, @@ -1717,7 +1717,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3767); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Zyc'), 2, @@ -1725,13 +1725,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -1739,7 +1739,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8621); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -1747,7 +1747,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5773); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), 2, @@ -1755,13 +1755,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6811); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -1769,7 +1769,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8853); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -1777,7 +1777,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5898); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 2, @@ -1785,13 +1785,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8750); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -1799,7 +1799,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6836); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -1807,7 +1807,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5513); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -1815,13 +1815,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7941); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -1829,7 +1829,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8490); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -1837,7 +1837,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6341); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -1845,13 +1845,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8630); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='DufF'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1859,7 +1859,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8781); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1867,7 +1867,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6211); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -1876,31 +1876,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8384); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=3; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=3; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1908,7 +1908,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6565); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1916,13 +1916,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7765); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1930,7 +1930,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6520); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1938,13 +1938,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8489); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1952,7 +1952,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7553); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1960,13 +1960,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8621); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1974,7 +1974,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7015); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1982,13 +1982,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8627); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Hugo'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Hugo'), 0, @@ -1996,7 +1996,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7258); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Hugo'), 1, @@ -2004,13 +2004,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8228); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2018,7 +2018,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7143); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2026,13 +2026,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8453); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2040,7 +2040,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7605); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2048,13 +2048,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8374); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -2062,7 +2062,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7185); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -2070,13 +2070,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8475); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 9 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2084,7 +2084,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6892); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2093,31 +2093,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8468); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=4; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=4; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2125,7 +2125,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7528); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2133,13 +2133,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8273); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Hugo'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Hugo'), 0, @@ -2147,7 +2147,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7376); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Hugo'), 1, @@ -2155,13 +2155,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8693); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2169,7 +2169,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7371); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2177,13 +2177,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8723); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -2191,7 +2191,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7282); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -2199,13 +2199,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8778); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -2213,7 +2213,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7352); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -2221,13 +2221,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8808); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2235,7 +2235,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7606); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2243,13 +2243,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8748); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2257,7 +2257,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7572); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2266,31 +2266,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8555); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=5; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=5; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Hugo'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Hugo'), 0, @@ -2298,7 +2298,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7573); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Hugo'), 1, @@ -2306,13 +2306,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8539); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2320,7 +2320,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7586); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2328,13 +2328,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8349); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2342,7 +2342,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7742); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2350,13 +2350,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8914); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -2364,7 +2364,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7692); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -2372,13 +2372,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8612); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2386,7 +2386,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7830); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2395,31 +2395,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8782); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=6; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=6; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Hugo'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Hugo'), 0, @@ -2427,7 +2427,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6376); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Hugo'), 1, @@ -2435,13 +2435,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8635); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -2449,7 +2449,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6094); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -2457,13 +2457,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8264); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2471,7 +2471,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6623); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2479,13 +2479,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8828); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2493,7 +2493,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6455); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2502,31 +2502,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8728); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=7; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=7; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Hugo'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Hugo'), 0, @@ -2534,7 +2534,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8273); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Hugo'), 1, @@ -2542,13 +2542,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8169); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2556,7 +2556,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8420); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2564,13 +2564,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8678); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2578,7 +2578,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8604); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2587,33 +2587,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8794); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=8; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='DufF'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2621,7 +2621,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5640); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2629,13 +2629,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8906); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 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='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2643,7 +2643,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5750); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 1,