Shape text using Pango and HarfBuzz; gives us nice ligatures and exotic scripts.

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

diff --git a/sql/cc04/cc3-04.sql b/sql/cc04/cc3-04.sql
index c4d7be7fc5310fb9236a1e6579f5af4cf725bb90..9d8a78aacbe784be086f9b9e9bc3bcde56343349 100644 (file)
--- a/sql/cc04/cc3-04.sql
+++ b/sql/cc04/cc3-04.sql
@@ -1,7 +1,7 @@
 begin;
 INSERT INTO tournaments 
   (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
-    (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
+    (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
     'Challenge Cup 3',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Askim',
@@ -9,135 +9,230 @@ INSERT INTO tournaments
     (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
     (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
 );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   1, 'Snute', 100);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   100);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   2, 'DufF', 90);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   3, 'Hugo', 81);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   3,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   4, 'Oliyzia', 73);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   5, 'RiChY', 66);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   5,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   6, 'OJK', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   6,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   7, 'Haggar', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   7,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   8, 'T|na', 51);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   8,
+   (SELECT player FROM players WHERE nick='T|na'),
+   51);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   9, 'Stream', 48);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   9,
+   (SELECT player FROM players WHERE nick='Stream'),
+   48);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   10, 'Nameless', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   10,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   11, 'Ylini', 45);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   11,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   45);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   12, 'Mulefisk', 44);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   12,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   13, 'Th0rny', 43);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   13,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   14, 'Duckling', 42);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   14,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   15, 'Olemann', 41);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   15,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   16, 'Smiph', 40);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   16,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   40);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   17, 'Dabi', 39);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   17,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   18, 'Zyc', 38);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   18,
+   (SELECT player FROM players WHERE nick='Zyc'),
+   38);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   19, 'Draconia', 37);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   19,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   37);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   20, 'Advena', 36);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   20,
+   (SELECT player FROM players WHERE nick='Advena'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   21, 'Bonzo', 0);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   21,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   22, 'Ted Kristian', 34);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   22,
+   (SELECT player FROM players WHERE nick='Ted Kristian'),
+   34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   23, 'Jim Andre', 33);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   23,
+   (SELECT player FROM players WHERE nick='Jim Andre'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   24, 'Glukko', 32);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   24,
+   (SELECT player FROM players WHERE nick='Glukko'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   25, 'Tassen', 31);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   25,
+   (SELECT player FROM players WHERE nick='Tassen'),
+   31);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   26, 'Matsi', 30);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   26,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   30);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   27, 'Gollum', 29);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   27,
+   (SELECT player FROM players WHERE nick='Gollum'),
+   29);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pål Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   28, 'Pål Andre', 28);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   28,
+   (SELECT player FROM players WHERE nick='Pål Andre'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   29, 'Andre', 27);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   29,
+   (SELECT player FROM players WHERE nick='Andre'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   30, 'Eruanna', 26);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   30,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Auran' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   31, 'Auran', 25);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   31,
+   (SELECT player FROM players WHERE nick='Auran'),
+   25);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
-   32, 'Ole-Christian', 24);
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
+   32,
+   (SELECT player FROM players WHERE nick='Ole-Christian'),
+   24);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    0,
@@ -145,7 +240,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4475);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    1,
@@ -153,22 +248,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5340);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Ted Kristian'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7032);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick WHERE 'Pål Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
    0,
@@ -176,7 +270,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4760);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
    1,
@@ -184,22 +278,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5946);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Pål Andre'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    5875);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    0,
@@ -207,7 +300,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5734);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    1,
@@ -215,22 +308,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7095);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8047);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -238,7 +330,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6356);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -246,22 +338,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7560);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    7720);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -269,7 +360,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6480);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -277,7 +368,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7646);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
@@ -285,33 +376,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7702);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jim Andre'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jim Andre'),
    0,
@@ -319,7 +409,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5809);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jim Andre'),
    1,
@@ -327,22 +417,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5338);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Jim Andre'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
    't',
    6198);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Andre'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Andre'),
    0,
@@ -350,7 +439,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4264);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Andre'),
    1,
@@ -358,22 +447,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3773);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Andre'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    5277);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    0,
@@ -381,7 +469,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5388);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    1,
@@ -389,22 +477,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5249);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7228);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -412,7 +499,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6226);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -420,22 +507,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6708);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    't',
    6445);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -443,7 +529,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7353);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -451,7 +537,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7214);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 2,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
@@ -459,33 +545,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6791);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Glukko'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Glukko'),
    0,
@@ -493,7 +578,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4346);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Glukko'),
    1,
@@ -501,22 +586,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3531);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Glukko'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    5270);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ole-Christian'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ole-Christian'),
    0,
@@ -524,22 +608,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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ole-Christian'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    0);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    0,
@@ -547,7 +630,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4898);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    1,
@@ -555,22 +638,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3333);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    5149);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -578,7 +660,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5189);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -586,22 +668,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4391);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7298);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -609,7 +690,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5822);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -617,7 +698,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8510);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -625,33 +706,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8504);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Th0rny'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Th0rny'),
    0,
@@ -659,7 +739,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5789);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Th0rny'),
    1,
@@ -667,22 +747,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6214);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Th0rny'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8348);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Nameless'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -690,7 +769,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5618);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -698,22 +777,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6326);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Nameless'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8278);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Matsi'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Matsi'),
    0,
@@ -721,7 +799,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4525);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Matsi'),
    1,
@@ -729,22 +807,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6008);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Matsi'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    7040);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
    0,
@@ -752,7 +829,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5716);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
    1,
@@ -760,22 +837,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6169);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='Draconia'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7682);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -783,7 +859,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6023);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -791,7 +867,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6628);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 4,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
@@ -799,33 +875,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8179);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    0,
@@ -833,7 +908,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5410);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    1,
@@ -841,22 +916,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4383);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Eruanna'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6040);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Advena'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Advena'),
    0,
@@ -864,7 +938,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6729);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Advena'),
    1,
@@ -872,22 +946,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7069);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Advena'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7624);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Tassen'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Tassen'),
    0,
@@ -895,7 +968,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6911);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Tassen'),
    1,
@@ -903,22 +976,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6693);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Tassen'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7298);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Duckling'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Duckling'),
    0,
@@ -926,7 +998,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8252);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Duckling'),
    1,
@@ -934,22 +1006,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7357);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Duckling'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7321);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Olemann'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
@@ -957,7 +1028,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7471);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
@@ -965,22 +1036,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7919);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8043);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -988,7 +1058,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8546);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -996,7 +1066,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7881);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 5,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -1004,33 +1074,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7740);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Bonzo'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Bonzo'),
    0,
@@ -1038,7 +1107,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4564);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Bonzo'),
    1,
@@ -1046,22 +1115,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6212);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Bonzo'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7211);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Gollum'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Gollum'),
    0,
@@ -1069,7 +1137,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3139);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Gollum'),
    1,
@@ -1077,22 +1145,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5655);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Gollum'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6369);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Hugo'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Hugo'),
    0,
@@ -1100,7 +1167,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6888);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Hugo'),
    1,
@@ -1108,22 +1175,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8521);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Hugo'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    7439);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Auran'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Auran'),
    0,
@@ -1131,7 +1197,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3300);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Auran'),
    1,
@@ -1139,22 +1205,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3813);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Auran'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
    't',
    4377);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Smiph'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -1162,7 +1227,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5696);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -1170,22 +1235,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7569);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7703);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -1193,7 +1257,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5989);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -1201,7 +1265,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7689);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    1, 6,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
@@ -1210,37 +1274,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8064);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
-INSERT INTO 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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -1248,7 +1311,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5825);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -1256,22 +1319,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4790);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7961);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    0,
@@ -1279,7 +1341,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6533);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    1,
@@ -1287,22 +1349,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5504);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    7989);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -1310,7 +1371,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7101);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
@@ -1318,22 +1379,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5725);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8713);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
    0,
@@ -1341,7 +1401,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6377);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
    1,
@@ -1349,22 +1409,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4994);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Th0rny'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8140);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1372,7 +1431,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7140);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1380,22 +1439,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5515);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8310);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1403,7 +1461,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6447);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1411,7 +1469,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5518);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -1419,33 +1477,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8271);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    0,
@@ -1453,7 +1510,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4394);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    1,
@@ -1461,22 +1518,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4295);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    6188);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    0,
@@ -1484,7 +1540,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5898);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    1,
@@ -1492,22 +1548,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5857);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Duckling'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8053);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -1515,7 +1570,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5873);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -1523,22 +1578,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5881);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8283);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Stream'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -1546,7 +1600,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5820);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -1554,22 +1608,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6437);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8232);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -1577,7 +1630,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6509);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -1585,22 +1638,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6858);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8420);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Hugo'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Hugo'),
    0,
@@ -1608,7 +1660,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6424);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Hugo'),
    1,
@@ -1616,7 +1668,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6499);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Hugo'),
    2,
@@ -1624,33 +1676,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8601);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=2;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    0,
@@ -1658,7 +1709,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3711);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    1,
@@ -1666,22 +1717,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3767);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Zyc'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    0);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Nameless'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Nameless'),
    0,
@@ -1689,7 +1739,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8621);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Nameless'),
    1,
@@ -1697,22 +1747,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5773);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Nameless'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    6811);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -1720,7 +1769,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8853);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -1728,22 +1777,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5898);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Haggar'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8750);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
@@ -1751,7 +1799,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6836);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
@@ -1759,22 +1807,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5513);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7941);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1782,7 +1829,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8490);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -1790,22 +1837,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6341);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8630);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -1813,7 +1859,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8781);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -1821,7 +1867,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6211);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    2, 3,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
@@ -1830,32 +1876,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8384);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=3;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=3;
-INSERT INTO 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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -1863,22 +1908,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6565);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    7765);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1886,22 +1930,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6520);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8489);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -1909,22 +1952,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7553);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8621);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1932,22 +1974,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7015);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    't',
    8627);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    0,
@@ -1955,22 +1996,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7258);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8228);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1978,22 +2018,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7143);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8453);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2001,22 +2040,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7605);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8374);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    8
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2024,22 +2062,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7185);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8475);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    9
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2047,7 +2084,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6892);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
@@ -2056,32 +2093,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8468);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=4;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=4;
-INSERT INTO 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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    0,
@@ -2089,22 +2125,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7528);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8273);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    0,
@@ -2112,22 +2147,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7376);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    '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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2135,22 +2169,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7371);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8723);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -2158,22 +2191,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7282);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8778);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2181,22 +2213,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7352);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8808);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2204,22 +2235,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7606);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8748);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2227,7 +2257,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7572);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2236,32 +2266,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8555);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=5;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=5;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    0,
@@ -2269,22 +2298,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7573);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8539);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -2292,22 +2320,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7586);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8349);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2315,22 +2342,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7742);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8914);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2338,22 +2364,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7692);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8612);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2361,7 +2386,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7830);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2370,32 +2395,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8782);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=6;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=6;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    0,
@@ -2403,22 +2427,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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8635);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -2426,22 +2449,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6094);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8264);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2449,22 +2471,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6623);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8828);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2472,7 +2493,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6455);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
@@ -2481,32 +2502,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8728);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=7;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=7;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    0,
@@ -2514,22 +2534,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8273);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Hugo'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8169);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2537,22 +2556,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8420);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8678);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2560,7 +2578,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8604);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -2569,34 +2587,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8794);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 
   round=8;
-INSERT INTO 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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -2604,22 +2621,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5640);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    8906);
-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 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -2627,7 +2643,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5750);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,