Started on a bigscreen SQL schema.

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

diff --git a/sql/cc04/cc1-04.sql b/sql/cc04/cc1-04.sql
index f9ecdf93b889025af6b784689f94959d1a32e148..ddb4b5fd85fc62159a099fda1d904cfc976e9dea 100644 (file)
--- a/sql/cc04/cc1-04.sql
+++ b/sql/cc04/cc1-04.sql
@@ -1,1819 +1,2731 @@
 begin;
 INSERT INTO tournaments 
 begin;
 INSERT INTO tournaments 

-  (season, name, country, location, "date", machine, scoringsystem) VALUES (
-    (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
+  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
+    (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),

     'Challenge Cup 1 - 2004',
     'Challenge Cup 1 - 2004',

-    (SELECT country FROM countries WHERE name='Norway'),
+    (SELECT country FROM countries WHERE countryname='Norway'),

     'Oslo Bowling',
     '2004-03-07',
     'Oslo Bowling',
     '2004-03-07',

-    (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
-    (SELECT scoringsystem FROM scoringsystems WHERE name='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, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   100);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   5,
+   (SELECT player FROM players WHERE nick='Tom'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   6,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   7,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   8,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   9,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   48);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   10,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   46);
+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 tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   11,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   12,
+   (SELECT player FROM players WHERE nick='Stream'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   13,
+   (SELECT player FROM players WHERE nick='Purity'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   14,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   15,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   16,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   40);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   17,
+   (SELECT player FROM players WHERE nick='Electus'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   18,
+   (SELECT player FROM players WHERE nick='Havok'),
+   38);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   19,
+   (SELECT player FROM players WHERE nick='Dexter'),
+   37);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   20,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   21,
+   (SELECT player FROM players WHERE nick='Advena'),
+   35);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   22,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   23,
+   (SELECT player FROM players WHERE nick='Telc'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   24,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   25,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   26,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   27,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   28,
+   (SELECT player FROM players WHERE nick='Golddragon'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   29,
+   (SELECT player FROM players WHERE nick='tombot'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   30,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   31,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   25);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   32,
+   (SELECT player FROM players WHERE nick='Octu'),
+   24);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   33,
+   (SELECT player FROM players WHERE nick='Ink'),
+   23);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   34,
+   (SELECT player FROM players WHERE nick='Auran'),
+   22);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=1;
   round=1;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    7505);
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    7505);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    7204);
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    7204);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   7952);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    5104);
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    5104);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    6302);
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    6302);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6940);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    7279);
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    7279);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    7205);
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    7205);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   7649);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 1,
    (SELECT player FROM players WHERE nick='Slusk'),
    4
 );
    1, 1,
    (SELECT player FROM players WHERE nick='Slusk'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    5544);
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    5544);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    6465);
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    6465);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7619);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    5
 );
    1, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    6968);
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    6968);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    8480);
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    'f',
    8480);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7702);

 INSERT INTO groups (tournament, round, parallel) VALUES (
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=1;
   round=1;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    5536);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    5536);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    5202);
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    5202);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Golddragon'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   6905);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    5390);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    5390);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    4746);
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    4746);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8151);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6849);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6849);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    6513);
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    6513);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8242);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
    4
 );
    1, 2,
    (SELECT player FROM players WHERE nick='Matsi'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    5675);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    5675);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    4952);
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    4952);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7354);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6720);
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
    'f',
    6720);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    6243);
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    6243);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+   't',
+   8513);

 INSERT INTO groups (tournament, round, parallel) VALUES (
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=1;
   round=1;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4876);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4876);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    6868);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    6868);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='tombot'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   6622);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4458);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4458);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    4053);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    4053);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Ink'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   5636);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5985);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5985);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7459);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7459);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+   't',
+   7837);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    4
 );
    1, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6173);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6173);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7732);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7732);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8031);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 3,
    (SELECT player FROM players WHERE nick='Telc'),
    5
 );
    1, 3,
    (SELECT player FROM players WHERE nick='Telc'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5563);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5563);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7290);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7290);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   't',
+   7467);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6545);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6545);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8636);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8636);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7666);

 INSERT INTO groups (tournament, round, parallel) VALUES (
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 4,
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=1;
   round=1;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    1
 );
    1, 4,
    (SELECT player FROM players WHERE nick='Duckling'),
    1
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    5235);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    5235);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    5049);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    5049);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7172);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 4,
    (SELECT player FROM players WHERE nick='Auran'),
    2
 );
    1, 4,
    (SELECT player FROM players WHERE nick='Auran'),
    2
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    4330);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    4330);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    3698);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    3698);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Auran'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   4459);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 4,
    (SELECT player FROM players WHERE nick='Advena'),
    3
 );
    1, 4,
    (SELECT player FROM players WHERE nick='Advena'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    5233);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    5233);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    5076);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    5076);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Advena'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7787);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    7143);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    7143);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    7727);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    7727);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7700);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    5
 );
    1, 4,
    (SELECT player FROM players WHERE nick='Smiph'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    4862);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    4862);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    6848);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    6848);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6668);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 4,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    6
 );
    1, 4,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    6
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8288);
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8288);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    8252);
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    8252);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7566);

 INSERT INTO groups (tournament, round, parallel) VALUES (
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    1, 5,
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=1;
   round=1;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 5,
    (SELECT player FROM players WHERE nick='x3mnrj'),
    1
 );
    1, 5,
    (SELECT player FROM players WHERE nick='x3mnrj'),
    1
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6004);
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6004);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5699);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5699);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6712);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 5,
    (SELECT player FROM players WHERE nick='Octu'),
    2
 );
    1, 5,
    (SELECT player FROM players WHERE nick='Octu'),
    2
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    5789);
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    5789);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    4891);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    4891);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Octu'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6321);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 5,
    (SELECT player FROM players WHERE nick='Electus'),
    3
 );
    1, 5,
    (SELECT player FROM players WHERE nick='Electus'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6256);
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6256);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6376);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6376);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Electus'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7992);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 5,
    (SELECT player FROM players WHERE nick='Purity'),
    4
 );
    1, 5,
    (SELECT player FROM players WHERE nick='Purity'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6498);
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6498);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6584);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6584);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8079);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6482);
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6482);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5994);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5994);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7576);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    6
 );
    1, 5,
    (SELECT player FROM players WHERE nick='Draconia'),
    6
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6130);
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6130);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5705);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5705);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7935);

 INSERT INTO groups (tournament, round, parallel) VALUES (
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
    1, 6,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=1;
   round=1;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 6,
    (SELECT player FROM players WHERE nick='Dexter'),
    1
 );
    1, 6,
    (SELECT player FROM players WHERE nick='Dexter'),
    1
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6276);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6276);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7296);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7296);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Dexter'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8433);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6171);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6171);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    6554);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    6554);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7315);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    3
 );
    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    5269);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    5269);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),
    1, 6,
    (SELECT player FROM players WHERE nick='Tha Dragon'),

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    5511);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    5511);

-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 scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7357);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6425);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6425);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8002);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8002);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8452);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6501);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6501);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8519);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8519);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8529);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    6
 );
    1, 6,
    (SELECT player FROM players WHERE nick='Daniil'),
    6
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6503);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6503);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7729);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7729);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8248);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=2;
   round=2;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    5962);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    5962);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    5704);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    5704);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8098);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    7436);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    7436);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6489);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6489);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8489);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    7619);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    7619);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6603);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6603);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8445);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    8436);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    8436);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6567);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6567);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8425);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 1,
    (SELECT player FROM players WHERE nick='Purity'),
    5
 );
    2, 1,
    (SELECT player FROM players WHERE nick='Purity'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    7441);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    7441);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6068);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6068);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8424);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    8253);
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    'f',
    8253);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6456);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6456);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8595);

 INSERT INTO groups (tournament, round, parallel) VALUES (
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=2;
   round=2;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    6396);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    6396);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    0);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    0);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   't',
+   3161);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    6943);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    6943);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4881);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4881);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    3
 );
    2, 2,
    (SELECT player FROM players WHERE nick='Haggar'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7235);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7235);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6126);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6126);

-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 scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8160);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    6370);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    6370);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5386);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5386);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8107);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7691);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7691);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6540);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6540);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8190);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7777);
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    'f',
    7777);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6359);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6359);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   7800);

 INSERT INTO groups (tournament, round, parallel) VALUES (
 INSERT INTO groups (tournament, round, parallel) VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
    2, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=2;
   round=2;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5974);
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5974);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7951);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7951);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8229);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5953);
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5953);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7738);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7738);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7874);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 3,
    (SELECT player FROM players WHERE nick='Electus'),
    3
 );
    2, 3,
    (SELECT player FROM players WHERE nick='Electus'),
    3
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5444);
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5444);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7090);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7090);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Electus'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7249);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    4
 );
    2, 3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    4
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5540);
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5540);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    6936);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    6936);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7821);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    5
 );
    2, 3,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    6206);
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    6206);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8084);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8084);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7733);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    2, 3,
    (SELECT player FROM players WHERE nick='Tom'),
    6
 );
    2, 3,
    (SELECT player FROM players WHERE nick='Tom'),
    6
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5836);
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
    'f',
    5836);

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   1,

    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8046);
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8046);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8508);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=3;
   round=3;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8251);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8251);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8380);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7881);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7881);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8316);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8295);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8295);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8678);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8092);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8092);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8680);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7806);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    7806);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   7815);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8414);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8414);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8180);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8406);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8406);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8260);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8441);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8441);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8539);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8489);
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8489);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8381);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=4;
   round=4;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6595);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6595);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8588);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6301);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6301);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8706);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6654);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6654);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8693);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6596);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6596);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7821);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    4, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    5
 );
    4, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    5
 );

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6766);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6766);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   't',
+   8379);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6433);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6433);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8563);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6803);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
    'f',
    6803);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8351);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=5;
   round=5;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7245);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7245);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8452);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6701);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6701);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8960);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7521);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7521);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8615);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7227);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7227);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8541);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6819);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6819);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8853);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=6;
   round=6;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6663);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6663);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8637);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6662);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6662);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   8044);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6810);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6810);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   't',
+   8506);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6759);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6759);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8544);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 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 name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=7;
   round=7;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    8391);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    8391);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8130);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9537);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9537);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8352);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9032);
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9032);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   8623);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

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

-  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 

   round=8;
   round=8;

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
    'f',
    6678);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
    'f',
    6678);

-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8781);

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

-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

-INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),

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

+   0,

    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
    'f',
    6827);
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
    'f',
    6827);

+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8691);

 commit;
 commit;