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

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

diff --git a/sql/cc04/cc1-04.sql b/sql/cc04/cc1-04.sql
index 6b8c80cea8f9f448bff959a1cd8aae6b78e1159e..5d8cae30a1ab72e6e7b989ecf3a147a64ed0f2aa 100644 (file)
--- a/sql/cc04/cc1-04.sql
+++ b/sql/cc04/cc1-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 1 - 2004',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Oslo Bowling',
@@ -9,141 +9,242 @@ 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, ( 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 1 - 2004'),
-   1, 'Snute', 100);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   100);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( 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 1 - 2004'),
-   2, 'DufF', 90);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 1 - 2004'),
-   3, 'OJK', 81);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   81);
+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 1 - 2004'),
-   4, 'Oliyzia', 73);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   5, 'Tom', 66);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   5,
+   (SELECT player FROM players WHERE nick='Tom'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   6, 'Snofox', 60);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   6,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   60);
+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 1 - 2004'),
-   7, 'RiChY', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   7,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0);
+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 1 - 2004'),
-   8, 'Haggar', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   8,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   9, 'Mulefisk', 48);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   9,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   48);
+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 1 - 2004'),
-   10, 'Daniil', 46);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   10,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   46);
+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 1 - 2004'),
-   11, 'T|na', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   11,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0);
+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 1 - 2004'),
-   12, 'Stream', 44);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   12,
+   (SELECT player FROM players WHERE nick='Stream'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   13, 'Purity', 43);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   13,
+   (SELECT player FROM players WHERE nick='Purity'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   14, 'Spinnvill', 42);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   14,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   15, 'Jallaman', 41);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   15,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   41);
+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 1 - 2004'),
-   16, 'Smiph', 40);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   16,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   40);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Electus' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   17, 'Electus', 39);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   17,
+   (SELECT player FROM players WHERE nick='Electus'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   18, 'Havok', 38);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   18,
+   (SELECT player FROM players WHERE nick='Havok'),
+   38);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   19, 'Dexter', 37);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   19,
+   (SELECT player FROM players WHERE nick='Dexter'),
+   37);
+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 1 - 2004'),
-   20, 'Draconia', 36);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   20,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   21, 'Advena', 35);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   21,
+   (SELECT player FROM players WHERE nick='Advena'),
+   35);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   22, 'Slusk', 34);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   22,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   23, 'Telc', 33);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   23,
+   (SELECT player FROM players WHERE nick='Telc'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   24, 'Matsi', 32);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   24,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   32);
+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 1 - 2004'),
-   25, 'Olemann', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   25,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   0);
+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 1 - 2004'),
-   26, 'Duckling', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   26,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   0);
+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 1 - 2004'),
-   27, 'Ylini', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   27,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   28, 'Golddragon', 28);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   28,
+   (SELECT player FROM players WHERE nick='Golddragon'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'tombot' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   29, 'tombot', 27);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   29,
+   (SELECT player FROM players WHERE nick='tombot'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   30, 'x3mnrj', 26);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   30,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   31, 'Tha Dragon', 25);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   31,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   25);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Octu' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   32, 'Octu', 24);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   32,
+   (SELECT player FROM players WHERE nick='Octu'),
+   24);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ink' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   33, 'Ink', 23);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   33,
+   (SELECT player FROM players WHERE nick='Ink'),
+   23);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Auran' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
-   34, 'Auran', 22);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   34,
+   (SELECT player FROM players WHERE nick='Auran'),
+   22);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy'))
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -151,30 +252,29 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7505);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    7204);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    7952);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -182,30 +282,29 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5104);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    6302);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6940);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    0,
@@ -213,30 +312,29 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7279);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    7205);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    7649);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Slusk'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Slusk'),
    0,
@@ -244,30 +342,29 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5544);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Slusk'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    6465);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Slusk'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7619);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    0,
@@ -275,15 +372,15 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6968);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    8480);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    2,
@@ -291,33 +388,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7702);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Golddragon'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Golddragon'),
    0,
@@ -325,7 +421,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5536);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Golddragon'),
    1,
@@ -333,22 +429,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5202);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Golddragon'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    6905);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -356,7 +451,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5390);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -364,22 +459,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4746);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8151);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -387,7 +481,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6849);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -395,22 +489,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6513);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8242);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
    0,
@@ -418,7 +511,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5675);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
    1,
@@ -426,22 +519,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4952);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7354);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -449,7 +541,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6720);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -457,7 +549,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6243);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
@@ -465,33 +557,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8513);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='tombot'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='tombot'),
    0,
@@ -499,7 +590,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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='tombot'),
    1,
@@ -507,22 +598,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6868);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='tombot'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    6622);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ink'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ink'),
    0,
@@ -530,7 +620,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4458);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ink'),
    1,
@@ -538,22 +628,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4053);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ink'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    5636);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -561,7 +650,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5985);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -569,22 +658,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7459);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    7837);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    0,
@@ -592,7 +680,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6173);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    1,
@@ -600,22 +688,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7732);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8031);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Telc'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Telc'),
    0,
@@ -623,7 +710,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5563);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Telc'),
    1,
@@ -631,22 +718,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7290);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Telc'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    't',
    7467);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -654,7 +740,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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -662,7 +748,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8636);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -670,33 +756,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7666);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    0,
@@ -704,7 +789,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5235);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    1,
@@ -712,22 +797,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5049);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7172);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Auran'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Auran'),
    0,
@@ -735,7 +819,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4330);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Auran'),
    1,
@@ -743,22 +827,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3698);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Auran'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    4459);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Advena'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Advena'),
    0,
@@ -766,7 +849,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5233);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Advena'),
    1,
@@ -774,22 +857,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5076);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Advena'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7787);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
@@ -797,7 +879,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7143);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
@@ -805,22 +887,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7727);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Snofox'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7700);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -828,7 +909,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4862);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -836,22 +917,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6848);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6668);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -859,7 +939,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8288);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -867,7 +947,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8252);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
@@ -875,33 +955,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7566);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='x3mnrj'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='x3mnrj'),
    0,
@@ -909,7 +988,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6004);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='x3mnrj'),
    1,
@@ -917,22 +996,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5699);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='x3mnrj'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    6712);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Octu'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Octu'),
    0,
@@ -940,7 +1018,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5789);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Octu'),
    1,
@@ -948,22 +1026,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4891);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Octu'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    6321);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Electus'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Electus'),
    0,
@@ -971,7 +1048,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6256);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Electus'),
    1,
@@ -979,22 +1056,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6376);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Electus'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7992);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Purity'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Purity'),
    0,
@@ -1002,7 +1078,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6498);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Purity'),
    1,
@@ -1010,22 +1086,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6584);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Purity'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8079);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Havok'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Havok'),
    0,
@@ -1033,7 +1108,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6482);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Havok'),
    1,
@@ -1041,22 +1116,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5994);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Havok'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7576);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    0,
@@ -1064,7 +1138,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6130);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    1,
@@ -1072,7 +1146,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5705);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    2,
@@ -1080,33 +1154,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7935);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Dexter'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Dexter'),
    0,
@@ -1114,7 +1187,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6276);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Dexter'),
    1,
@@ -1122,22 +1195,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7296);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Dexter'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8433);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Olemann'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
@@ -1145,7 +1217,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6171);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
@@ -1153,22 +1225,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6554);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7315);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    0,
@@ -1176,7 +1247,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5269);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    1,
@@ -1184,22 +1255,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5511);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7357);
-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 roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1207,7 +1277,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6425);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1215,22 +1285,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8002);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8452);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1238,7 +1307,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6501);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -1246,22 +1315,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8519);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8529);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -1269,7 +1337,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6503);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    1,
@@ -1277,7 +1345,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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    2,
@@ -1286,37 +1354,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8248);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -1324,7 +1391,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5962);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -1332,22 +1399,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5704);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8098);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -1355,7 +1421,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7436);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
    1,
@@ -1363,22 +1429,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6489);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Daniil'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8489);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
@@ -1386,7 +1451,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7619);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
@@ -1394,22 +1459,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6603);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snofox'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8445);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -1417,7 +1481,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8436);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -1425,22 +1489,21 @@ 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8425);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Purity'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Purity'),
    0,
@@ -1448,7 +1511,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7441);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Purity'),
    1,
@@ -1456,22 +1519,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6068);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Purity'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8424);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -1479,7 +1541,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8253);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -1487,7 +1549,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6456);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -1495,33 +1557,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8595);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Havok'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Havok'),
    0,
@@ -1529,7 +1590,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6396);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Havok'),
    1,
@@ -1537,22 +1598,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    0);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Havok'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    't',
    3161);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -1560,7 +1620,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6943);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -1568,22 +1628,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4881);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    0);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -1591,7 +1650,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7235);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -1599,22 +1658,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6126);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8160);
-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 roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1622,7 +1680,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6370);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1630,22 +1688,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5386);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8107);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1653,7 +1710,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7691);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1661,22 +1718,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6540);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8190);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1684,7 +1740,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7777);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -1692,7 +1748,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6359);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
@@ -1700,33 +1756,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7800);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    0,
@@ -1734,7 +1789,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5974);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    1,
@@ -1742,22 +1797,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7951);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8229);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -1765,7 +1819,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5953);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -1773,22 +1827,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7738);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7874);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Electus'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Electus'),
    0,
@@ -1796,7 +1849,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5444);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Electus'),
    1,
@@ -1804,22 +1857,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7090);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Electus'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    7249);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    0,
@@ -1827,7 +1879,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5540);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    1,
@@ -1835,22 +1887,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6936);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    7821);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -1858,7 +1909,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6206);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -1866,22 +1917,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8084);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    7733);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Tom'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Tom'),
    0,
@@ -1889,7 +1939,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5836);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Tom'),
    1,
@@ -1897,7 +1947,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8046);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Tom'),
    2,
@@ -1906,32 +1956,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8508);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=3;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -1939,22 +1988,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8251);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8380);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -1962,22 +2010,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7881);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8316);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
@@ -1985,22 +2032,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8295);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8678);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2008,22 +2054,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8092);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8680);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    0,
@@ -2031,22 +2076,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7806);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    7815);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2054,22 +2098,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8414);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8180);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2077,22 +2120,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8406);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8260);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2100,22 +2142,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8441);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8539);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    9
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    0,
@@ -2123,7 +2164,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8489);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    1,
@@ -2132,32 +2173,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8381);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=4;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2165,22 +2205,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6595);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8588);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2188,22 +2227,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6301);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8706);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2211,22 +2249,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6654);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8693);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2234,22 +2271,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6596);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7821);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    0,
@@ -2257,22 +2293,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6766);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    't',
    8379);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
@@ -2280,22 +2315,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6433);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8563);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2303,7 +2337,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6803);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2312,32 +2346,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8351);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=5;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2345,22 +2378,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7245);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8452);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    0,
@@ -2368,22 +2400,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6701);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8960);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2391,22 +2422,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7521);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8615);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2414,22 +2444,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7227);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8541);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2437,7 +2466,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6819);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -2446,32 +2475,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8853);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=6;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=6;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2479,22 +2507,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6663);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8637);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2502,22 +2529,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6662);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8044);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2525,22 +2551,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6810);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    't',
    8506);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2548,7 +2573,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6759);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2557,32 +2582,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8544);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=7;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2590,22 +2614,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8391);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8130);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2613,22 +2636,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    9537);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8352);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2636,7 +2658,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    9032);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2645,32 +2667,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8623);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=8;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2678,22 +2699,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6678);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8781);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' 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 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2701,7 +2721,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6827);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,