DDR Europe tournament parser now by default sets all players to Norway. Syntax fixes...

[ccbs] / sql / cc04 / cc8-04.sql

diff --git a/sql/cc04/cc8-04.sql b/sql/cc04/cc8-04.sql
index 6d26165e3ec5987e972b574af16fbe6a1ed07aeb..778f5e7e7d4ac21223093352a5c72d9cf91bcf12 100644 (file)
--- a/sql/cc04/cc8-04.sql
+++ b/sql/cc04/cc8-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 8',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Bowling 1 Lillehammer',
@@ -9,302 +9,302 @@ 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1,
    (SELECT player FROM players WHERE nick='Snute'),
    100);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2,
    (SELECT player FROM players WHERE nick='Haggar'),
    90);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3,
    (SELECT player FROM players WHERE nick='DufF'),
    81);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4,
    (SELECT player FROM players WHERE nick='OJK'),
    73);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5,
    (SELECT player FROM players WHERE nick='RiChY'),
    66);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6,
    (SELECT player FROM players WHERE nick='Gogo'),
    60);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    55);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8,
    (SELECT player FROM players WHERE nick='Pingo'),
    51);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    9,
    (SELECT player FROM players WHERE nick='Nameless'),
    48);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    10,
    (SELECT player FROM players WHERE nick='Haanz'),
    46);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    11,
    (SELECT player FROM players WHERE nick='Bonzo'),
    45);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    12,
    (SELECT player FROM players WHERE nick='Olemann'),
    44);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    13,
    (SELECT player FROM players WHERE nick='T|na'),
    43);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    14,
    (SELECT player FROM players WHERE nick='Daniil'),
    42);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    15,
    (SELECT player FROM players WHERE nick='Ylini'),
    41);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    16,
    (SELECT player FROM players WHERE nick='Stream'),
    40);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    17,
    (SELECT player FROM players WHERE nick='Cuivien'),
    39);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    18,
    (SELECT player FROM players WHERE nick='Ozon'),
    38);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zredna' AS nick WHERE 'Zredna' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zredna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zredna' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    19,
    (SELECT player FROM players WHERE nick='Zredna'),
    37);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    20,
    (SELECT player FROM players WHERE nick='Andeplane'),
    36);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    21,
    (SELECT player FROM players WHERE nick='Pyro'),
    35);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    22,
    (SELECT player FROM players WHERE nick='Smiph'),
    34);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nuust' AS nick WHERE 'Nuust' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nuust' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nuust' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    23,
    (SELECT player FROM players WHERE nick='Nuust'),
    33);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    24,
    (SELECT player FROM players WHERE nick='Alexxz'),
    32);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick WHERE 'Sesse' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sesse' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    25,
    (SELECT player FROM players WHERE nick='Sesse'),
    31);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Master' AS nick WHERE 'Master' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Master' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Master' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    26,
    (SELECT player FROM players WHERE nick='Master'),
    30);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    27,
    (SELECT player FROM players WHERE nick='Draconia'),
    29);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    28,
    (SELECT player FROM players WHERE nick='Felz'),
    28);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    29,
    (SELECT player FROM players WHERE nick='Mync'),
    27);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    30,
    (SELECT player FROM players WHERE nick='Duckling'),
    26);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Guru' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    31,
    (SELECT player FROM players WHERE nick='Guru'),
    25);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Montana' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    32,
    (SELECT player FROM players WHERE nick='Montana'),
    24);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    33,
    (SELECT player FROM players WHERE nick='Ngan'),
    23);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    34,
    (SELECT player FROM players WHERE nick='JonAnders'),
    22);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Evil Ed' AS nick WHERE 'Evil Ed' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Evil Ed' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Evil Ed' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    35,
    (SELECT player FROM players WHERE nick='Evil Ed'),
    21);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    36,
    (SELECT player FROM players WHERE nick='Hyper'),
    20);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Goku' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    37,
    (SELECT player FROM players WHERE nick='Goku'),
    19);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    38,
    (SELECT player FROM players WHERE nick='Zackie'),
    18);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    39,
    (SELECT player FROM players WHERE nick='Cehtna'),
    17);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    40,
    (SELECT player FROM players WHERE nick='Indy'),
    16);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'v|per' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    41,
    (SELECT player FROM players WHERE nick='v|per'),
    15);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Glock' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    42,
    (SELECT player FROM players WHERE nick='Glock'),
    14);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    43,
    (SELECT player FROM players WHERE nick='Athena'),
    13);
-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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    44,
    (SELECT player FROM players WHERE nick='Eruanna'),
    12);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Master'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Master'),
    0,
@@ -312,7 +312,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6619);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Master'),
    1,
@@ -320,7 +320,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6488);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Master'),
    2,
@@ -328,13 +328,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8270);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pyro'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pyro'),
    0,
@@ -342,7 +342,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6738);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pyro'),
    1,
@@ -350,7 +350,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6660);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pyro'),
    2,
@@ -358,13 +358,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8308);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Cehtna'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Cehtna'),
    0,
@@ -372,7 +372,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6734);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Cehtna'),
    1,
@@ -380,7 +380,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Cehtna'),
    2,
@@ -388,13 +388,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7694);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Duckling'),
    0,
@@ -402,7 +402,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6624);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Duckling'),
    1,
@@ -410,7 +410,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6356);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Duckling'),
    2,
@@ -418,13 +418,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8093);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -432,7 +432,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6706);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -440,7 +440,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6719);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
@@ -448,13 +448,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8059);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -462,7 +462,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6929);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -470,7 +470,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6937);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
@@ -478,32 +478,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7756);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Nuust'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Nuust'),
    0,
@@ -511,7 +511,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7237);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Nuust'),
    1,
@@ -519,7 +519,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6727);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Nuust'),
    2,
@@ -527,13 +527,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8453);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Ngan'),
    0,
@@ -541,7 +541,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Ngan'),
    1,
@@ -549,7 +549,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5471);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Ngan'),
    2,
@@ -557,13 +557,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7571);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Hyper'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Hyper'),
    0,
@@ -571,7 +571,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6264);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Hyper'),
    1,
@@ -579,7 +579,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4876);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Hyper'),
    2,
@@ -587,13 +587,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8320);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
@@ -601,7 +601,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7945);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
@@ -609,7 +609,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6385);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
@@ -617,13 +617,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8507);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Daniil'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -631,7 +631,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7963);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Daniil'),
    1,
@@ -639,7 +639,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6734);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Daniil'),
    2,
@@ -647,13 +647,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8396);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -661,7 +661,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8388);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -669,7 +669,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7354);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -677,32 +677,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8694);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Evil Ed'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Evil Ed'),
    0,
@@ -710,7 +710,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4609);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Evil Ed'),
    1,
@@ -718,7 +718,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5827);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Evil Ed'),
    2,
@@ -726,13 +726,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7355);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='v|per'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='v|per'),
    0,
@@ -740,7 +740,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5134);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='v|per'),
    1,
@@ -748,7 +748,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5276);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='v|per'),
    2,
@@ -756,13 +756,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6718);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Cuivien'),
    0,
@@ -770,7 +770,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6247);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Cuivien'),
    1,
@@ -778,7 +778,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6328);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Cuivien'),
    2,
@@ -786,13 +786,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8542);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Smiph'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -800,7 +800,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5687);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -808,7 +808,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6207);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,
@@ -816,13 +816,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8572);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -830,7 +830,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6308);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -838,7 +838,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6567);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
@@ -846,13 +846,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7994);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -860,7 +860,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6623);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -868,7 +868,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7128);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
@@ -876,32 +876,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7554);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Sesse'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Sesse'),
    0,
@@ -909,7 +909,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7636);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Sesse'),
    1,
@@ -917,7 +917,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8428);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Sesse'),
    2,
@@ -925,13 +925,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8406);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zredna'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zredna'),
    0,
@@ -939,7 +939,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8003);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zredna'),
    1,
@@ -947,7 +947,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zredna'),
    2,
@@ -955,13 +955,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8519);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zackie'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zackie'),
    0,
@@ -969,7 +969,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5276);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zackie'),
    1,
@@ -977,7 +977,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6514);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Zackie'),
    2,
@@ -985,13 +985,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7845);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Athena'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Athena'),
    0,
@@ -999,7 +999,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4802);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Athena'),
    1,
@@ -1007,7 +1007,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5373);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Athena'),
    2,
@@ -1015,13 +1015,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7489);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Mync'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Mync'),
    0,
@@ -1029,7 +1029,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7202);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Mync'),
    1,
@@ -1037,7 +1037,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8496);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Mync'),
    2,
@@ -1045,13 +1045,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8554);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Pingo'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Pingo'),
    0,
@@ -1059,7 +1059,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7483);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Pingo'),
    1,
@@ -1067,7 +1067,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8679);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Pingo'),
    2,
@@ -1075,13 +1075,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8809);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Haggar'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -1089,7 +1089,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8321);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -1097,7 +1097,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8881);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
@@ -1105,32 +1105,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8616);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Haanz'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Haanz'),
    0,
@@ -1138,7 +1138,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5470);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Haanz'),
    1,
@@ -1146,7 +1146,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6054);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Haanz'),
    2,
@@ -1154,13 +1154,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8663);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Guru'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Guru'),
    0,
@@ -1168,7 +1168,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5347);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Guru'),
    1,
@@ -1176,7 +1176,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5650);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Guru'),
    2,
@@ -1184,13 +1184,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8047);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Goku'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Goku'),
    0,
@@ -1198,7 +1198,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4947);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Goku'),
    1,
@@ -1206,7 +1206,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5990);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Goku'),
    2,
@@ -1214,13 +1214,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7891);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    0,
@@ -1228,7 +1228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4600);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    1,
@@ -1236,7 +1236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4726);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    2,
@@ -1244,13 +1244,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7537);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    0,
@@ -1258,7 +1258,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5210);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    1,
@@ -1266,7 +1266,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    2,
@@ -1274,13 +1274,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8180);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),
    0,
@@ -1288,7 +1288,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6101);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),
    1,
@@ -1296,7 +1296,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6778);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Bonzo'),
    2,
@@ -1304,13 +1304,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8466);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='RiChY'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1318,7 +1318,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5487);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -1326,7 +1326,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6818);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
@@ -1334,32 +1334,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8107);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('Candy☆'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Glock'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Glock'),
    0,
@@ -1367,7 +1367,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6054);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Glock'),
    1,
@@ -1375,7 +1375,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5164);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Glock'),
    2,
@@ -1383,13 +1383,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6318);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='JonAnders'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='JonAnders'),
    0,
@@ -1397,7 +1397,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6545);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='JonAnders'),
    1,
@@ -1405,7 +1405,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5614);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='JonAnders'),
    2,
@@ -1413,13 +1413,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7394);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andeplane'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andeplane'),
    0,
@@ -1427,7 +1427,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7156);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andeplane'),
    1,
@@ -1435,7 +1435,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7261);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Andeplane'),
    2,
@@ -1443,13 +1443,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8533);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Alexxz'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Alexxz'),
    0,
@@ -1457,7 +1457,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6690);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Alexxz'),
    1,
@@ -1465,7 +1465,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7365);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Alexxz'),
    2,
@@ -1473,13 +1473,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8441);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -1487,7 +1487,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7458);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -1495,7 +1495,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7554);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Gogo'),
    2,
@@ -1503,13 +1503,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8774);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -1517,7 +1517,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7729);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -1525,7 +1525,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7620);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Nameless'),
    2,
@@ -1533,32 +1533,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8501);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Indy'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Indy'),
    0,
@@ -1566,7 +1566,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5526);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Indy'),
    1,
@@ -1574,7 +1574,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5459);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Indy'),
    2,
@@ -1582,13 +1582,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7379);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Montana'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Montana'),
    0,
@@ -1596,7 +1596,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7483);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Montana'),
    1,
@@ -1604,7 +1604,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5227);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Montana'),
    2,
@@ -1612,13 +1612,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7768);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Felz'),
    0,
@@ -1626,7 +1626,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7800);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Felz'),
    1,
@@ -1634,7 +1634,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6311);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Felz'),
    2,
@@ -1642,13 +1642,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7844);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Ozon'),
    0,
@@ -1656,7 +1656,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8006);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Ozon'),
    1,
@@ -1664,7 +1664,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6209);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Ozon'),
    2,
@@ -1672,13 +1672,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8510);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1686,7 +1686,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7910);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1694,7 +1694,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6828);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -1702,13 +1702,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8627);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -1716,7 +1716,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8463);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -1724,7 +1724,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7025);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 7,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
@@ -1733,36 +1733,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8691);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -1770,7 +1770,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -1778,7 +1778,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8241);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
@@ -1786,13 +1786,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8621);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Andeplane'),
    0,
@@ -1800,7 +1800,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8508);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Andeplane'),
    1,
@@ -1808,7 +1808,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7030);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Andeplane'),
    2,
@@ -1816,13 +1816,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8358);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Haanz'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Haanz'),
    0,
@@ -1830,7 +1830,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8551);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Haanz'),
    1,
@@ -1838,7 +1838,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7999);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Haanz'),
    2,
@@ -1846,13 +1846,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8787);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1860,7 +1860,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8803);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1868,7 +1868,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7817);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -1876,13 +1876,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8543);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -1890,7 +1890,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8780);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -1898,7 +1898,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8316);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Gogo'),
    2,
@@ -1906,13 +1906,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8748);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -1920,7 +1920,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8852);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -1928,7 +1928,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8327);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Nameless'),
    2,
@@ -1936,13 +1936,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8728);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -1950,7 +1950,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8694);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -1958,7 +1958,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8286);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
@@ -1966,32 +1966,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8660);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -1999,7 +1999,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6347);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -2007,7 +2007,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7766);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
@@ -2015,13 +2015,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8344);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Zredna'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Zredna'),
    0,
@@ -2029,7 +2029,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6316);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Zredna'),
    1,
@@ -2037,7 +2037,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7166);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Zredna'),
    2,
@@ -2045,13 +2045,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8524);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2059,7 +2059,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6795);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2067,7 +2067,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8776);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
@@ -2075,13 +2075,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8850);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Cuivien'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Cuivien'),
    0,
@@ -2089,7 +2089,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5902);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Cuivien'),
    1,
@@ -2097,7 +2097,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7552);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Cuivien'),
    2,
@@ -2105,13 +2105,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8584);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Pingo'),
    0,
@@ -2119,7 +2119,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6269);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Pingo'),
    1,
@@ -2127,7 +2127,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8408);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Pingo'),
    2,
@@ -2135,13 +2135,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8717);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Bonzo'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Bonzo'),
    0,
@@ -2149,7 +2149,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6430);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Bonzo'),
    1,
@@ -2157,7 +2157,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8157);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Bonzo'),
    2,
@@ -2165,13 +2165,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2179,7 +2179,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6782);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2187,7 +2187,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -2195,32 +2195,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8500);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
@@ -2228,7 +2228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6347);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
@@ -2236,7 +2236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8358);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
@@ -2244,13 +2244,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8516);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ozon'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ozon'),
    0,
@@ -2258,7 +2258,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6261);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ozon'),
    1,
@@ -2266,7 +2266,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8225);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Ozon'),
    2,
@@ -2274,13 +2274,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8294);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2288,7 +2288,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6218);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -2296,7 +2296,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8663);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
@@ -2304,13 +2304,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8760);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -2318,7 +2318,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6085);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Daniil'),
    1,
@@ -2326,7 +2326,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8491);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Daniil'),
    2,
@@ -2334,13 +2334,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2348,7 +2348,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6508);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2356,7 +2356,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8698);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
@@ -2364,13 +2364,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8630);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Pyro'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Pyro'),
    0,
@@ -2378,7 +2378,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5161);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Pyro'),
    1,
@@ -2386,7 +2386,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8179);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Pyro'),
    2,
@@ -2394,13 +2394,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8147);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2408,7 +2408,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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2416,7 +2416,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8732);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
@@ -2425,31 +2425,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8332);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2457,7 +2457,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6085);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -2465,13 +2465,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8615);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),
    0,
@@ -2479,7 +2479,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5663);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Pingo'),
    1,
@@ -2487,13 +2487,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8664);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2501,7 +2501,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6167);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -2509,13 +2509,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8697);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2523,7 +2523,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6571);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2531,13 +2531,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8537);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2545,7 +2545,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6545);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2553,13 +2553,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8520);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -2567,7 +2567,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5880);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -2575,13 +2575,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8851);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2589,7 +2589,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6434);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2597,13 +2597,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8770);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    8
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2611,7 +2611,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6697);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2619,13 +2619,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8887);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    9
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -2633,7 +2633,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5690);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -2642,31 +2642,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8608);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2674,7 +2674,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6599);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -2682,13 +2682,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8377);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    0,
@@ -2696,7 +2696,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7122);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Gogo'),
    1,
@@ -2704,13 +2704,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8309);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2718,7 +2718,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7322);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -2726,13 +2726,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8639);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2740,7 +2740,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7369);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2748,13 +2748,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8574);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2762,7 +2762,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7541);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2770,13 +2770,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8823);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2784,7 +2784,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7100);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2792,13 +2792,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8450);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2806,7 +2806,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7766);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2815,31 +2815,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8673);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2847,7 +2847,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8648);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2855,13 +2855,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8629);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2869,7 +2869,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8829);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2877,13 +2877,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8556);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2891,7 +2891,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8463);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -2899,13 +2899,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8313);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2913,7 +2913,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8498);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2921,13 +2921,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8793);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2935,7 +2935,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8909);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2944,33 +2944,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8934);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2978,7 +2978,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8669);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2986,13 +2986,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8951);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -3000,7 +3000,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8729);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -3008,13 +3008,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    9424);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -3022,7 +3022,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8588);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -3030,13 +3030,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    9179);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -3044,7 +3044,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8654);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -3053,31 +3053,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    9826);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -3085,7 +3085,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7559);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -3093,13 +3093,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8751);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -3107,7 +3107,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7562);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -3115,13 +3115,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8834);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -3129,7 +3129,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7506);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -3138,31 +3138,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8918);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -3170,7 +3170,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5582);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -3178,13 +3178,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8826);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -3192,7 +3192,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5915);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,