X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc5-04.sql;h=fb5d88ba6afde35d30de8599e21fa52001a73445;hp=0d29e4475cd36ff51e7519b5fe333e32768f953e;hb=69e91c419df45838d7c85633b10d0998f0f92f7a;hpb=9f7b3c1a46383496e6a30e0aad8d4252e1a94fda

diff --git a/sql/cc04/cc5-04.sql b/sql/cc04/cc5-04.sql
index 0d29e44..fb5d88b 100644
--- a/sql/cc04/cc5-04.sql
+++ b/sql/cc04/cc5-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 5 - NM',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'OsloLan',
@@ -9,266 +9,266 @@ 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1,
    (SELECT player FROM players WHERE nick='Snute'),
    200);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2,
    (SELECT player FROM players WHERE nick='DufF'),
    180);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3,
    (SELECT player FROM players WHERE nick='Haggar'),
    162);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4,
    (SELECT player FROM players WHERE nick='OJK'),
    146);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5,
    (SELECT player FROM players WHERE nick='RiChY'),
    132);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6,
    (SELECT player FROM players WHERE nick='Nameless'),
    120);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7,
    (SELECT player FROM players WHERE nick='Gogo'),
    110);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8,
    (SELECT player FROM players WHERE nick='T|na'),
    102);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9,
    (SELECT player FROM players WHERE nick='Pingo'),
    96);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10,
    (SELECT player FROM players WHERE nick='Daniil'),
    92);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    11,
    (SELECT player FROM players WHERE nick='Duckling'),
    90);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    12,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    13,
    (SELECT player FROM players WHERE nick='Bonzo'),
    86);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    14,
    (SELECT player FROM players WHERE nick='Stream'),
    84);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    15,
    (SELECT player FROM players WHERE nick='Olemann'),
    82);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    16,
    (SELECT player FROM players WHERE nick='Ozon'),
    80);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    17,
    (SELECT player FROM players WHERE nick='Mync'),
    78);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    18,
    (SELECT player FROM players WHERE nick='Ylini'),
    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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    19,
    (SELECT player FROM players WHERE nick='Smiph'),
    0);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    20,
    (SELECT player FROM players WHERE nick='Cuivien'),
    72);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    21,
    (SELECT player FROM players WHERE nick='Haanz'),
    70);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Felz' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    22,
    (SELECT player FROM players WHERE nick='Felz'),
    68);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    23,
    (SELECT player FROM players WHERE nick='Cehtna'),
    66);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    24,
    (SELECT player FROM players WHERE nick='Andeplane'),
    64);
-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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    25,
    (SELECT player FROM players WHERE nick='Alexxz'),
    62);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    26,
    (SELECT player FROM players WHERE nick='Asphodel'),
    60);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    27,
    (SELECT player FROM players WHERE nick='Havok'),
    58);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    28,
    (SELECT player FROM players WHERE nick='Zeila'),
    56);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    29,
    (SELECT player FROM players WHERE nick='Ngan'),
    54);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    30,
    (SELECT player FROM players WHERE nick='Andre'),
    52);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    31,
    (SELECT player FROM players WHERE nick='Lindaninja'),
    50);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    32,
    (SELECT player FROM players WHERE nick='Eruanna'),
    48);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    33,
    (SELECT player FROM players WHERE nick='Ingviild'),
    46);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    34,
    (SELECT player FROM players WHERE nick='Marilla'),
    44);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    35,
    (SELECT player FROM players WHERE nick='Mickva'),
    42);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    36,
    (SELECT player FROM players WHERE nick='Chimera'),
    40);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    37,
    (SELECT player FROM players WHERE nick='Maxion'),
    38);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Athena' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    38,
    (SELECT player FROM players WHERE nick='Athena'),
    36);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Eruanna'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Eruanna'),
    0,
@@ -276,7 +276,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4721);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Eruanna'),
    1,
@@ -284,7 +284,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Eruanna'),
    2,
@@ -292,13 +292,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6966);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Andeplane'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Andeplane'),
    0,
@@ -306,7 +306,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5019);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Andeplane'),
    1,
@@ -314,7 +314,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6152);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Andeplane'),
    2,
@@ -322,13 +322,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7108);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Zeila'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Zeila'),
    0,
@@ -336,7 +336,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5066);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Zeila'),
    1,
@@ -344,7 +344,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5352);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Zeila'),
    2,
@@ -352,13 +352,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7198);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -366,7 +366,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6156);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -374,7 +374,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7590);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
@@ -382,13 +382,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8352);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    0,
@@ -396,7 +396,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5813);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    1,
@@ -404,7 +404,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6831);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    2,
@@ -412,13 +412,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7766);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -426,7 +426,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6444);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -434,7 +434,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7576);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
@@ -442,32 +442,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7626);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Chimera'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Chimera'),
    0,
@@ -475,7 +475,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5567);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Chimera'),
    1,
@@ -483,7 +483,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4361);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Chimera'),
    2,
@@ -491,13 +491,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5565);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Alexxz'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Alexxz'),
    0,
@@ -505,7 +505,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5491);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Alexxz'),
    1,
@@ -513,7 +513,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6262);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Alexxz'),
    2,
@@ -521,13 +521,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7712);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -535,7 +535,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6086);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -543,7 +543,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6603);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,
@@ -551,13 +551,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8273);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    0,
@@ -565,7 +565,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    1,
@@ -573,7 +573,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7596);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    2,
@@ -581,13 +581,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7879);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Pingo'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Pingo'),
    0,
@@ -595,7 +595,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6255);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Pingo'),
    1,
@@ -603,7 +603,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7084);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Pingo'),
    2,
@@ -611,13 +611,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8287);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -625,7 +625,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6772);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -633,7 +633,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8406);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -641,32 +641,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7950);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mickva'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mickva'),
    0,
@@ -674,7 +674,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4465);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mickva'),
    1,
@@ -682,7 +682,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4028);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mickva'),
    2,
@@ -690,13 +690,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5991);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    0,
@@ -704,7 +704,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4920);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    1,
@@ -712,7 +712,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4843);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    2,
@@ -720,13 +720,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7321);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Felz'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Felz'),
    0,
@@ -734,7 +734,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5808);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Felz'),
    1,
@@ -742,7 +742,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5815);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Felz'),
    2,
@@ -750,13 +750,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7912);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mync'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mync'),
    0,
@@ -764,7 +764,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5263);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mync'),
    1,
@@ -772,7 +772,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5942);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Mync'),
    2,
@@ -780,13 +780,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8607);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -794,7 +794,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6737);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -802,7 +802,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6570);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    2,
@@ -810,13 +810,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7713);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -824,7 +824,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7205);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -832,7 +832,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6463);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
@@ -840,32 +840,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7926);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ingviild'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ingviild'),
    0,
@@ -873,7 +873,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5859);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ingviild'),
    1,
@@ -881,7 +881,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4881);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ingviild'),
    2,
@@ -889,13 +889,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6608);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ngan'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ngan'),
    0,
@@ -903,7 +903,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6613);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ngan'),
    1,
@@ -911,7 +911,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5443);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Ngan'),
    2,
@@ -919,13 +919,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5594);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Cuivien'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Cuivien'),
    0,
@@ -933,7 +933,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7812);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Cuivien'),
    1,
@@ -941,7 +941,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6291);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Cuivien'),
    2,
@@ -949,13 +949,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8215);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -963,7 +963,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8313);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Daniil'),
    1,
@@ -971,7 +971,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6442);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Daniil'),
    2,
@@ -979,13 +979,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Olemann'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
@@ -993,7 +993,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8573);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
@@ -1001,7 +1001,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
@@ -1009,13 +1009,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8156);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1023,7 +1023,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7958);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -1031,7 +1031,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6351);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
@@ -1039,32 +1039,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8482);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Maxion'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Maxion'),
    0,
@@ -1072,7 +1072,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5747);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Maxion'),
    1,
@@ -1080,7 +1080,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6617);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Maxion'),
    2,
@@ -1088,13 +1088,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5844);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Lindaninja'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Lindaninja'),
    0,
@@ -1102,7 +1102,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6165);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Lindaninja'),
    1,
@@ -1110,7 +1110,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6631);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Lindaninja'),
    2,
@@ -1118,13 +1118,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7569);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Asphodel'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Asphodel'),
    0,
@@ -1132,7 +1132,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7341);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Asphodel'),
    1,
@@ -1140,7 +1140,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6061);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Asphodel'),
    2,
@@ -1148,13 +1148,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7656);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Cehtna'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Cehtna'),
    0,
@@ -1162,7 +1162,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7809);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Cehtna'),
    1,
@@ -1170,7 +1170,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7520);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Cehtna'),
    2,
@@ -1178,13 +1178,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7030);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1192,7 +1192,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8235);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1200,7 +1200,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7930);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -1208,13 +1208,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7759);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Ylini'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -1222,7 +1222,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8154);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -1230,7 +1230,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7758);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
@@ -1238,13 +1238,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7463);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1252,7 +1252,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8580);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1260,7 +1260,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8478);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
@@ -1268,32 +1268,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8195);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Athena'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Athena'),
    0,
@@ -1301,7 +1301,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4975);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Athena'),
    1,
@@ -1309,7 +1309,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5292);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Athena'),
    2,
@@ -1317,13 +1317,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6141);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andre'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andre'),
    0,
@@ -1331,7 +1331,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5503);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andre'),
    1,
@@ -1339,7 +1339,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5618);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andre'),
    2,
@@ -1347,13 +1347,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6345);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Marilla'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Marilla'),
    0,
@@ -1361,7 +1361,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5338);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Marilla'),
    1,
@@ -1369,7 +1369,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5008);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Marilla'),
    2,
@@ -1377,13 +1377,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6534);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
    0,
@@ -1391,7 +1391,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6040);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
    1,
@@ -1399,7 +1399,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6589);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Ozon'),
    2,
@@ -1407,13 +1407,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8005);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Haanz'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Haanz'),
    0,
@@ -1421,7 +1421,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4809);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Haanz'),
    1,
@@ -1429,7 +1429,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6176);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Haanz'),
    2,
@@ -1437,13 +1437,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7953);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -1451,7 +1451,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6040);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -1459,7 +1459,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8064);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    2,
@@ -1467,13 +1467,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7648);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -1481,7 +1481,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6274);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -1489,7 +1489,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7686);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
@@ -1498,36 +1498,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    7587);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    0,
@@ -1535,7 +1535,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8122);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    1,
@@ -1543,7 +1543,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7553);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Bonzo'),
    2,
@@ -1551,13 +1551,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8550);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mync'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mync'),
    0,
@@ -1565,7 +1565,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7831);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mync'),
    1,
@@ -1573,7 +1573,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7442);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mync'),
    2,
@@ -1581,13 +1581,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8239);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -1595,7 +1595,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8742);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -1603,7 +1603,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8478);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
@@ -1611,13 +1611,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8785);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -1625,7 +1625,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8218);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
    1,
@@ -1633,7 +1633,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7626);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
    2,
@@ -1641,13 +1641,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8773);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -1655,7 +1655,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8734);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -1663,7 +1663,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8640);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
@@ -1671,13 +1671,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8773);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1685,7 +1685,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8692);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1693,7 +1693,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7952);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
@@ -1701,32 +1701,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8653);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ozon'),
    0,
@@ -1734,7 +1734,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6062);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ozon'),
    1,
@@ -1742,7 +1742,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6369);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ozon'),
    2,
@@ -1750,13 +1750,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8251);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1764,7 +1764,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6416);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -1772,7 +1772,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6971);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
@@ -1780,13 +1780,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8504);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -1794,7 +1794,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6535);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -1802,7 +1802,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6863);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
@@ -1810,13 +1810,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8476);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1824,7 +1824,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6705);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1832,7 +1832,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6938);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -1840,13 +1840,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8378);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -1854,7 +1854,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6565);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -1862,7 +1862,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7037);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Nameless'),
    2,
@@ -1870,13 +1870,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8454);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
@@ -1884,7 +1884,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6181);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
@@ -1892,7 +1892,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6748);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
@@ -1900,32 +1900,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -1933,7 +1933,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5689);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -1941,7 +1941,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8037);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
@@ -1949,13 +1949,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8235);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    0,
@@ -1963,7 +1963,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6172);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    1,
@@ -1971,7 +1971,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8011);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Pingo'),
    2,
@@ -1979,13 +1979,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8558);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -1993,7 +1993,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -2001,7 +2001,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8240);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Gogo'),
    2,
@@ -2009,13 +2009,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8820);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Duckling'),
    0,
@@ -2023,7 +2023,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5960);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Duckling'),
    1,
@@ -2031,7 +2031,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8158);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Duckling'),
    2,
@@ -2039,13 +2039,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8486);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -2053,7 +2053,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6287);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -2061,7 +2061,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7795);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
@@ -2069,13 +2069,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8495);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2083,7 +2083,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6870);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2091,7 +2091,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8658);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -2100,31 +2100,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8677);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2132,7 +2132,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8665);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -2140,13 +2140,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8561);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),
    0,
@@ -2154,7 +2154,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8071);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),
    1,
@@ -2162,13 +2162,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8262);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2176,7 +2176,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8651);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2184,13 +2184,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8731);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -2198,7 +2198,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7787);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -2206,13 +2206,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8652);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2220,7 +2220,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8492);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2228,13 +2228,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -2242,7 +2242,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8267);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -2250,13 +2250,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8734);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -2264,7 +2264,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8565);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -2272,13 +2272,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8643);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    8
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2286,7 +2286,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8580);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2294,13 +2294,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    9
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2308,7 +2308,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8805);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2317,31 +2317,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8819);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -2349,7 +2349,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6387);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -2357,13 +2357,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7925);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2371,7 +2371,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2379,13 +2379,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8820);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -2393,7 +2393,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6593);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -2401,13 +2401,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8561);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2415,7 +2415,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6498);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -2423,13 +2423,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8723);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2437,7 +2437,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2445,13 +2445,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8606);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2459,7 +2459,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6536);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2467,13 +2467,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8855);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2481,7 +2481,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6884);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2490,31 +2490,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8757);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2522,7 +2522,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7858);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -2530,13 +2530,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8472);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2544,7 +2544,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8682);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2552,13 +2552,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8800);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2566,7 +2566,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8257);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2574,13 +2574,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8754);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2588,7 +2588,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2596,13 +2596,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8766);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2610,7 +2610,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8403);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2619,31 +2619,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8604);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2651,7 +2651,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8198);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2659,13 +2659,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    9195);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2673,7 +2673,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7744);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2681,13 +2681,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8691);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2695,7 +2695,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8365);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2703,13 +2703,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8600);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2717,7 +2717,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8455);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2726,31 +2726,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8875);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2758,7 +2758,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8550);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2766,13 +2766,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8972);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2780,7 +2780,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8763);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2788,13 +2788,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8905);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2802,7 +2802,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8516);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2811,31 +2811,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8070);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' 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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2843,7 +2843,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6621);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2851,13 +2851,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8891);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2865,7 +2865,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6634);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2874,31 +2874,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    9672);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=9;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=9;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -2906,7 +2906,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5271);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -2914,13 +2914,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7905);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2928,7 +2928,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5683);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -2936,13 +2936,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 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -2950,7 +2950,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5509);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -2959,31 +2959,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8471);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=10;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=10;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -2991,7 +2991,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8343);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -2999,13 +2999,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8674);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -3013,7 +3013,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8013);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,