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

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

diff --git a/sql/cc04/cc2-04.sql b/sql/cc04/cc2-04.sql
index d1585b55138fd1e47995edb8566e41fd7cae7c0d..f0511c5798df63b323c4ff80d9c22e3b86818e32 100644 (file)
--- a/sql/cc04/cc2-04.sql
+++ b/sql/cc04/cc2-04.sql
@@ -1,7 +1,7 @@
 begin;
 INSERT INTO tournaments 
   (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
 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 2',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Kino 1 Sandvika',
     'Challenge Cup 2',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Kino 1 Sandvika',


@@ -9,128 +9,128 @@ INSERT INTO tournaments
     (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
     (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
 );
     (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, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1,
    (SELECT player FROM players WHERE nick='OJK'),
    100);
    1,
    (SELECT player FROM players WHERE nick='OJK'),
    100);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2,
    (SELECT player FROM players WHERE nick='Snute'),
    0);
    2,
    (SELECT player FROM players WHERE nick='Snute'),
    0);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3,
    (SELECT player FROM players WHERE nick='DufF'),
    0);
    3,
    (SELECT player FROM players WHERE nick='DufF'),
    0);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4,
    (SELECT player FROM players WHERE nick='Snofox'),
    73);
    4,
    (SELECT player FROM players WHERE nick='Snofox'),
    73);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5,
    (SELECT player FROM players WHERE nick='T|na'),
    66);
    5,
    (SELECT player FROM players WHERE nick='T|na'),
    66);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6,
    (SELECT player FROM players WHERE nick='RiChY'),
    60);
    6,
    (SELECT player FROM players WHERE nick='RiChY'),
    60);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7,
    (SELECT player FROM players WHERE nick='Stream'),
    55);
    7,
    (SELECT player FROM players WHERE nick='Stream'),
    55);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    8,
    (SELECT player FROM players WHERE nick='Olemann'),
    51);
    8,
    (SELECT player FROM players WHERE nick='Olemann'),
    51);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Raazu' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    9,
    (SELECT player FROM players WHERE nick='Raazu'),
    48);
    9,
    (SELECT player FROM players WHERE nick='Raazu'),
    48);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    10,
    (SELECT player FROM players WHERE nick='Ylini'),
    46);
    10,
    (SELECT player FROM players WHERE nick='Ylini'),
    46);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    11,
    (SELECT player FROM players WHERE nick='Smiph'),
    45);
    11,
    (SELECT player FROM players WHERE nick='Smiph'),
    45);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    12,
    (SELECT player FROM players WHERE nick='Havok'),
    44);
    12,
    (SELECT player FROM players WHERE nick='Havok'),
    44);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    13,
    (SELECT player FROM players WHERE nick='Draconia'),
    43);
    13,
    (SELECT player FROM players WHERE nick='Draconia'),
    43);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dabi' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    14,
    (SELECT player FROM players WHERE nick='Dabi'),
    42);
    14,
    (SELECT player FROM players WHERE nick='Dabi'),
    42);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bush' NOT IN ( SELECT nick FROM players );

 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    15,
    (SELECT player FROM players WHERE nick='Bush'),
    41);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    15,
    (SELECT player FROM players WHERE nick='Bush'),
    41);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    1,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 1);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    0,
    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    0,


@@ -138,7 +138,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4327);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    4327);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    1,
    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    1,


@@ -146,7 +146,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4251);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    4251);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    2,
    1, 1,
    (SELECT player FROM players WHERE nick='Bush'),
    2,


@@ -154,13 +154,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5910);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    5910);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,


@@ -168,7 +168,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5476);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5476);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,


@@ -176,7 +176,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6242);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6242);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    2,


@@ -184,13 +184,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7977);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7977);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    0,


@@ -198,7 +198,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6224);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6224);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    1,


@@ -206,7 +206,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6659);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6659);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    2,
    1, 1,
    (SELECT player FROM players WHERE nick='Stream'),
    2,


@@ -214,13 +214,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7572);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7572);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    0,


@@ -228,7 +228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6530);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6530);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    1,


@@ -236,7 +236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6702);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6702);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
    1, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    2,


@@ -244,13 +244,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7631);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7631);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 (
    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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    0,


@@ -258,7 +258,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7561);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7561);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    1,


@@ -266,7 +266,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7616);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7616);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    2,
    1, 1,
    (SELECT player FROM players WHERE nick='Snute'),
    2,


@@ -274,32 +274,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6839);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    't',
    6839);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 2);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    0,
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    0,


@@ -307,7 +307,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3973);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    3973);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    1,
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    1,


@@ -315,7 +315,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3845);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    3845);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    2,
    1, 2,
    (SELECT player FROM players WHERE nick='Dabi'),
    2,


@@ -323,13 +323,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6484);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    6484);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,


@@ -337,7 +337,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7827);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7827);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,


@@ -345,7 +345,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6329);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6329);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,
    1, 2,
    (SELECT player FROM players WHERE nick='Olemann'),
    2,


@@ -353,13 +353,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8032);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8032);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,


@@ -367,7 +367,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 (
    'f',
    7830);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,


@@ -375,7 +375,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6336);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6336);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,
    1, 2,
    (SELECT player FROM players WHERE nick='Smiph'),
    2,


@@ -383,13 +383,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7544);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7544);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,


@@ -397,7 +397,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8058);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8058);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,


@@ -405,7 +405,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7672);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7672);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,
    1, 2,
    (SELECT player FROM players WHERE nick='RiChY'),
    2,


@@ -413,13 +413,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8167);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8167);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    0,


@@ -427,7 +427,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8651);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8651);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    1,


@@ -435,7 +435,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8426);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8426);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    2,
    1, 2,
    (SELECT player FROM players WHERE nick='DufF'),
    2,


@@ -443,32 +443,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8392);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    't',
    8392);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 3);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 
    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 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    0,
    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    0,


@@ -476,7 +476,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5012);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5012);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    1,
    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    1,


@@ -484,7 +484,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4014);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    4014);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    2,
    1, 3,
    (SELECT player FROM players WHERE nick='Raazu'),
    2,


@@ -492,13 +492,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6940);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    6940);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    0,
    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    0,


@@ -506,7 +506,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5541);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5541);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    1,
    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    1,


@@ -514,7 +514,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    0);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    0);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    2,
    1, 3,
    (SELECT player FROM players WHERE nick='Draconia'),
    2,


@@ -522,13 +522,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7524);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7524);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    0,
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    0,


@@ -536,7 +536,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4355);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    4355);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    1,
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    1,


@@ -544,7 +544,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6284);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6284);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    2,
    1, 3,
    (SELECT player FROM players WHERE nick='Havok'),
    2,


@@ -552,13 +552,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    4399);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    4399);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,


@@ -566,7 +566,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5953);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5953);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,


@@ -574,7 +574,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8076);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8076);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    2,
    1, 3,
    (SELECT player FROM players WHERE nick='Snofox'),
    2,


@@ -582,13 +582,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7735);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7735);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    0,


@@ -596,7 +596,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6044);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6044);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    1,


@@ -604,7 +604,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8303);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8303);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    2,


@@ -613,31 +613,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8625);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    8625);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    2,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    2, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    2, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=2;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=2;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
    0,


@@ -645,7 +645,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7286);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7286);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='Raazu'),
    1,


@@ -653,13 +653,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7657);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7657);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    0,


@@ -667,7 +667,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7814);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7814);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1,


@@ -675,13 +675,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7986);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7986);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
    0,


@@ -689,7 +689,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7747);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7747);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='Olemann'),
    1,


@@ -697,13 +697,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7721);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7721);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,


@@ -711,7 +711,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8215);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8215);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,


@@ -719,13 +719,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8053);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8053);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,


@@ -733,7 +733,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8529);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8529);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,


@@ -741,13 +741,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8570);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8570);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,


@@ -755,7 +755,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8478);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8478);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,


@@ -763,13 +763,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8174);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8174);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,


@@ -777,7 +777,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8743);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8743);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,


@@ -785,13 +785,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8447);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8447);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    8
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    8
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,


@@ -799,7 +799,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8695);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8695);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,


@@ -807,13 +807,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8440);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8440);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    9
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    9
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,


@@ -821,7 +821,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8798);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8798);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,


@@ -830,31 +830,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8500);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    8500);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    3,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    3, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=3;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=3;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=3;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=3;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 (
    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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    0,


@@ -862,7 +862,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7698);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7698);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1,


@@ -870,13 +870,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7874);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    7874);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 (
    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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,


@@ -884,7 +884,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8241);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8241);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,


@@ -892,13 +892,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8574);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8574);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,


@@ -906,7 +906,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8139);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8139);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
    3, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,


@@ -914,13 +914,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8403);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8403);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,


@@ -928,7 +928,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8661);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8661);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
    3, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,


@@ -936,13 +936,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8456);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8456);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,


@@ -950,7 +950,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8272);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8272);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,


@@ -958,13 +958,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8353);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8353);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    3, 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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,


@@ -972,7 +972,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8783);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8783);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    3, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,


@@ -980,13 +980,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8673);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8673);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    3, 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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,


@@ -994,7 +994,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8633);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8633);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    3, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,


@@ -1003,31 +1003,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8584);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    8584);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    4,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    4, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=4;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=4;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=4;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=4;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,


@@ -1035,7 +1035,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5706);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5706);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,


@@ -1043,13 +1043,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8583);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8583);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    4, 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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,


@@ -1057,7 +1057,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5726);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5726);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,


@@ -1065,13 +1065,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8056);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8056);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,


@@ -1079,7 +1079,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5553);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5553);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
    4, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,


@@ -1087,13 +1087,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8525);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8525);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,


@@ -1101,7 +1101,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 (
    'f',
    5822);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    4, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,


@@ -1109,13 +1109,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8460);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8460);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,


@@ -1123,7 +1123,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5922);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    5922);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    4, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,


@@ -1132,31 +1132,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8725);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    8725);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    5,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    5, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=5;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=5;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=5;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=5;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,


@@ -1164,7 +1164,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6450);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6450);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
    5, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,


@@ -1172,13 +1172,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8236);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8236);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,


@@ -1186,7 +1186,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6742);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6742);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    5, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,


@@ -1194,13 +1194,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8728);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8728);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,


@@ -1208,7 +1208,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6605);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6605);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,


@@ -1216,13 +1216,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8534);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8534);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,


@@ -1230,7 +1230,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6689);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6689);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    5, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,


@@ -1239,31 +1239,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8828);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    8828);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    6,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    6, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=6;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=6;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=6;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=6;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,


@@ -1271,7 +1271,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7343);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7343);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,


@@ -1279,13 +1279,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8871);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8871);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    6, 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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,


@@ -1293,7 +1293,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7152);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    7152);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,
    6, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    1,


@@ -1301,13 +1301,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8718);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8718);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 (
    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 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,


@@ -1315,7 +1315,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6908);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    6908);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    6, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,


@@ -1324,31 +1324,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    9276);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    9276);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    7,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    7, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=7;
 UPDATE rounds SET chosensongs=1 WHERE 
   round=7;
 UPDATE rounds SET chosensongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND 

   round=7;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   round=7;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,


@@ -1356,7 +1356,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8662);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8662);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
    7, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,


@@ -1364,13 +1364,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8776);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    't',
    8776);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,


@@ -1378,7 +1378,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8676);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    'f',
    8676);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (

-   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),

    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,