X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc4-04.sql;h=0927f65aa5c9df3f951e1ab4e67e372a2bcf5802;hp=2dbdbe8a99b92da83c34616ba69e2a0b4e668567;hb=69e91c419df45838d7c85633b10d0998f0f92f7a;hpb=9f7b3c1a46383496e6a30e0aad8d4252e1a94fda diff --git a/sql/cc04/cc4-04.sql b/sql/cc04/cc4-04.sql index 2dbdbe8..0927f65 100644 --- a/sql/cc04/cc4-04.sql +++ b/sql/cc04/cc4-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 4', (SELECT country FROM countries WHERE countryname='Norway'), 'Askim', @@ -9,236 +9,236 @@ 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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, '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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, (SELECT player FROM players WHERE nick='RiChY'), 81); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, (SELECT player FROM players WHERE nick='Haggar'), 73); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, (SELECT player FROM players WHERE nick='Nameless'), 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, (SELECT player FROM players WHERE nick='Snofox'), 55); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, (SELECT player FROM players WHERE nick='Tom'), 51); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 9, (SELECT player FROM players WHERE nick='Pingo'), 48); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 10, (SELECT player FROM players WHERE nick='Oliyzia'), 46); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 11, (SELECT player FROM players WHERE nick='Gogo'), 45); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 12, (SELECT player FROM players WHERE nick='Duckling'), 44); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 13, (SELECT player FROM players WHERE nick='T|na'), 0); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 14, (SELECT player FROM players WHERE nick='Daniil'), 42); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 15, (SELECT player FROM players WHERE nick='Ylini'), 41); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 16, (SELECT player FROM players WHERE nick='Mulefisk'), 40); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 17, (SELECT player FROM players WHERE nick='Olemann'), 0); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 18, (SELECT player FROM players WHERE nick='Tassen'), 38); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 19, (SELECT player FROM players WHERE nick='Bonzo'), 37); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mync' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 20, (SELECT player FROM players WHERE nick='Mync'), 36); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ozon' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 21, (SELECT player FROM players WHERE nick='Ozon'), 35); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 22, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 34); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 23, (SELECT player FROM players WHERE nick='Ted Kristian'), 33); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 24, (SELECT player FROM players WHERE nick='Dabi'), 32); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 25, (SELECT player FROM players WHERE nick='Draconia'), 31); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Alexxz' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 26, (SELECT player FROM players WHERE nick='Alexxz'), 30); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 27, (SELECT player FROM players WHERE nick='Stream'), 0); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 28, (SELECT player FROM players WHERE nick='Smiph'), 0); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 29, (SELECT player FROM players WHERE nick='Jim Andre'), 27); -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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 30, (SELECT player FROM players WHERE nick='Glukko'), 26); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hyper' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 31, (SELECT player FROM players WHERE nick='Hyper'), 25); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mario' AS nick WHERE 'Mario' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mario' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mario' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 32, (SELECT player FROM players WHERE nick='Mario'), 24); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeek' AS nick WHERE 'Zeek' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeek' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zeek' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 33, (SELECT player FROM players WHERE nick='Zeek'), 23); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 0, @@ -246,7 +246,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5755); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 1, @@ -254,7 +254,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7439); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='PÃ¥l Andre'), 2, @@ -262,13 +262,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7946); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Tassen'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Tassen'), 0, @@ -276,7 +276,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5862); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Tassen'), 1, @@ -284,7 +284,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7465); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Tassen'), 2, @@ -292,13 +292,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8018); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -306,7 +306,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6303); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -314,7 +314,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8631); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), 2, @@ -322,13 +322,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8233); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Draconia'), 0, @@ -336,7 +336,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5607); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Draconia'), 1, @@ -344,7 +344,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5191); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Draconia'), 2, @@ -352,13 +352,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -366,7 +366,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6749); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -374,7 +374,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8741); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -382,32 +382,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8874); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Mync'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Mync'), 0, @@ -415,7 +415,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5430); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Mync'), 1, @@ -423,7 +423,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5492); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Mync'), 2, @@ -431,13 +431,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8444); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Glukko'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Glukko'), 0, @@ -445,7 +445,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 2894); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Glukko'), 1, @@ -453,7 +453,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3223); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Glukko'), 2, @@ -461,13 +461,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5806); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Mulefisk'), 0, @@ -475,7 +475,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6127); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Mulefisk'), 1, @@ -483,7 +483,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6043); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Mulefisk'), 2, @@ -491,13 +491,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8149); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -505,7 +505,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6012); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -513,7 +513,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5709); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -521,13 +521,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8211); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -535,7 +535,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6811); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -543,7 +543,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6585); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -551,32 +551,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8457); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Pingo'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Pingo'), 0, @@ -584,7 +584,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7866); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Pingo'), 1, @@ -592,7 +592,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7709); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Pingo'), 2, @@ -600,13 +600,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7000); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Jim Andre'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Jim Andre'), 0, @@ -614,7 +614,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4750); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Jim Andre'), 1, @@ -622,7 +622,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6116); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Jim Andre'), 2, @@ -630,13 +630,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 732); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Dabi'), 0, @@ -644,7 +644,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4556); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Dabi'), 1, @@ -652,7 +652,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4005); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Dabi'), 2, @@ -660,13 +660,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4005); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -674,7 +674,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7080); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -682,7 +682,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7509); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -690,13 +690,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7509); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -704,7 +704,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8480); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -712,7 +712,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8664); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -720,32 +720,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8664); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mario'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mario'), 0, @@ -753,7 +753,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5758); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mario'), 1, @@ -761,7 +761,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6465); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mario'), 2, @@ -769,13 +769,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Gogo'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Gogo'), 0, @@ -783,7 +783,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6758); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Gogo'), 1, @@ -791,7 +791,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7512); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Gogo'), 2, @@ -799,13 +799,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8708); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Ted Kristian'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Ted Kristian'), 0, @@ -813,7 +813,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5911); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Ted Kristian'), 1, @@ -821,7 +821,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6985); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Ted Kristian'), 2, @@ -829,13 +829,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7493); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Duckling'), 0, @@ -843,7 +843,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7250); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Duckling'), 1, @@ -851,7 +851,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6600); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Duckling'), 2, @@ -859,13 +859,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7872); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Smiph'), 0, @@ -873,7 +873,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6036); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Smiph'), 1, @@ -881,7 +881,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6297); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Smiph'), 2, @@ -889,13 +889,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4416); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -903,7 +903,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8446); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -911,7 +911,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7602); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -919,32 +919,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7739); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), 0, @@ -952,7 +952,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4861); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), 1, @@ -960,7 +960,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4170); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), 2, @@ -968,13 +968,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7512); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Zeek'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Zeek'), 0, @@ -982,7 +982,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3749); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Zeek'), 1, @@ -990,7 +990,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3734); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Zeek'), 2, @@ -998,13 +998,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5129); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 0, @@ -1012,7 +1012,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6065); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 1, @@ -1020,7 +1020,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6185); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 2, @@ -1028,13 +1028,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8490); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tom'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tom'), 0, @@ -1042,7 +1042,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7240); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tom'), 1, @@ -1050,7 +1050,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7260); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Tom'), 2, @@ -1058,13 +1058,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7512); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Snofox'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -1072,7 +1072,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6529); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -1080,7 +1080,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6174); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Snofox'), 2, @@ -1088,13 +1088,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8424); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1102,7 +1102,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6633); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1110,7 +1110,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5652); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -1118,32 +1118,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8612); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), 0, @@ -1151,7 +1151,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5641); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), 1, @@ -1159,7 +1159,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5089); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), 2, @@ -1167,13 +1167,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8048); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hyper'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hyper'), 0, @@ -1181,7 +1181,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4410); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hyper'), 1, @@ -1189,7 +1189,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 2831); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Hyper'), 2, @@ -1197,13 +1197,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7408); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -1211,7 +1211,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6327); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -1219,7 +1219,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5632); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 2, @@ -1227,13 +1227,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8276); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Daniil'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Daniil'), 0, @@ -1241,7 +1241,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6294); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Daniil'), 1, @@ -1249,7 +1249,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5286); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Daniil'), 2, @@ -1257,13 +1257,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8341); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -1271,7 +1271,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6371); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -1279,7 +1279,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5369); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 2, @@ -1287,13 +1287,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8253); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1301,7 +1301,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6135); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1309,7 +1309,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5013); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -1318,36 +1318,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7102); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Olemann'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -1355,7 +1355,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6635); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -1363,7 +1363,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5971); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -1371,13 +1371,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8042); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1385,7 +1385,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7402); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1393,7 +1393,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6375); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -1401,13 +1401,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8274); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -1415,7 +1415,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7331); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -1423,7 +1423,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6382); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 2, @@ -1431,13 +1431,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -1445,7 +1445,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7448); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -1453,7 +1453,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6233); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), 2, @@ -1461,13 +1461,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8801); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 0, @@ -1475,7 +1475,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7500); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 1, @@ -1483,7 +1483,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6317); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 2, @@ -1491,13 +1491,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8646); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1505,7 +1505,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7792); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1513,7 +1513,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6639); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -1521,32 +1521,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8630); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 0, @@ -1554,7 +1554,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7990); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 1, @@ -1562,7 +1562,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6324); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), 2, @@ -1570,13 +1570,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8347); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 0, @@ -1584,7 +1584,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7982); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 1, @@ -1592,7 +1592,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6286); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 2, @@ -1600,13 +1600,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8179); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Mulefisk'), 0, @@ -1614,7 +1614,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8108); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Mulefisk'), 1, @@ -1622,7 +1622,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6173); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Mulefisk'), 2, @@ -1630,13 +1630,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8113); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -1644,7 +1644,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8499); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -1652,7 +1652,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6638); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Haggar'), 2, @@ -1660,13 +1660,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8381); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -1674,7 +1674,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8517); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -1682,7 +1682,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6692); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), 2, @@ -1690,13 +1690,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8208); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='OJK'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1704,7 +1704,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8348); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1712,7 +1712,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6600); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -1720,32 +1720,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8253); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Tassen'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Tassen'), 0, @@ -1753,7 +1753,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Tassen'), 1, @@ -1761,7 +1761,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Tassen'), 2, @@ -1769,13 +1769,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -1783,7 +1783,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7704); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -1791,7 +1791,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8111); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -1799,13 +1799,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8154); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), 0, @@ -1813,7 +1813,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8440); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), 1, @@ -1821,7 +1821,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8160); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), 2, @@ -1829,13 +1829,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8450); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), 0, @@ -1843,7 +1843,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), 1, @@ -1851,7 +1851,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8385); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), 2, @@ -1859,13 +1859,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8602); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -1873,7 +1873,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8488); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -1881,7 +1881,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8481); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -1889,13 +1889,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8638); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1903,7 +1903,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8747); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1911,7 +1911,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8570); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -1920,31 +1920,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8621); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1952,7 +1952,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7448); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1960,13 +1960,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8790); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), 0, @@ -1974,7 +1974,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6765); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), 1, @@ -1982,13 +1982,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7998); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Tom'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Tom'), 0, @@ -1996,7 +1996,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6668); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Tom'), 1, @@ -2004,13 +2004,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8185); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -2018,7 +2018,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6994); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -2026,13 +2026,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8791); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2040,7 +2040,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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2048,13 +2048,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8596); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -2062,7 +2062,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7175); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -2070,13 +2070,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8451); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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', 6946); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2092,13 +2092,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8654); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2106,7 +2106,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7356); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2114,13 +2114,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8639); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 9 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2128,7 +2128,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7433); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2137,31 +2137,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8573); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2169,7 +2169,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6555); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2177,13 +2177,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8735); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -2191,7 +2191,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6004); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -2199,13 +2199,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7993); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2213,7 +2213,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6451); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2221,13 +2221,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8809); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -2235,7 +2235,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6422); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -2243,13 +2243,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8568); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2257,7 +2257,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6579); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2265,13 +2265,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8769); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2279,7 +2279,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6713); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2287,13 +2287,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8737); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -2301,7 +2301,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6544); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -2310,31 +2310,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8332); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Nameless'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -2342,7 +2342,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7215); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -2350,13 +2350,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8271); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2364,7 +2364,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8438); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2372,13 +2372,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8314); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2386,7 +2386,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8547); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2394,13 +2394,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8379); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2408,7 +2408,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8695); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2416,13 +2416,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8812); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2430,7 +2430,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8342); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2439,31 +2439,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8724); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='RiChY'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2471,7 +2471,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8120); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2479,13 +2479,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8701); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2493,7 +2493,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8234); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2501,13 +2501,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8563); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2515,7 +2515,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8376); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2523,13 +2523,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8901); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2537,7 +2537,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8784); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2546,31 +2546,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8795); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='RiChY'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2578,7 +2578,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6581); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2586,13 +2586,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8498); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2600,7 +2600,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6778); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2608,13 +2608,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 9057); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2622,7 +2622,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6776); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2631,31 +2631,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8944); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=8; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2663,7 +2663,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6883); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2671,13 +2671,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 9510); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 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 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2685,7 +2685,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6436); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='DufF'), 1,