Add scripts for getting CC03 data, and premade SQL.

[ccbs] / sql / cc03 / cc4-03.sql

diff --git a/sql/cc03/cc4-03.sql b/sql/cc03/cc4-03.sql
new file mode 100644 (file)
index 0000000..e1b9be0
--- /dev/null
+++ b/sql/cc03/cc4-03.sql
@@ -0,0 +1,2659 @@
+begin;
+INSERT INTO tournaments 
+  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
+    (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+    'Challenge Cup 4',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Oslo Bowling',
+    '2002-10-27',
+    (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, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   100);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5,
+   (SELECT player FROM players WHERE nick='DufF'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   55);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   51);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   9,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   48);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   10,
+   (SELECT player FROM players WHERE nick='Telc'),
+   46);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   11,
+   (SELECT player FROM players WHERE nick='ViD'),
+   45);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   12,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   13,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   14,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   15,
+   (SELECT player FROM players WHERE nick='Havok'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lykkesopp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lykkesopp' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   16,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   40);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   17,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Vampyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Vampyro' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   18,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   38);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   19,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   37);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   20,
+   (SELECT player FROM players WHERE nick='Purity'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   21,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   35);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   22,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Electus' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   23,
+   (SELECT player FROM players WHERE nick='Electus'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   24,
+   (SELECT player FROM players WHERE nick='Advena'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'FantNo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'FantNo' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   25,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   31);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   26,
+   (SELECT player FROM players WHERE nick='Indy'),
+   30);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   27,
+   (SELECT player FROM players WHERE nick='T|na'),
+   29);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ink' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   28,
+   (SELECT player FROM players WHERE nick='Ink'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   29,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Private Ryan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Private Ryan' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   30,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   31,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   25);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   32,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   24);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   4375);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
+   'f',
+   3021);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   't',
+   5087);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Advena'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Advena'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   4683);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Advena'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
+   'f',
+   3339);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Advena'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   5549);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   4578);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
+   'f',
+   3344);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6223);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Havok'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   7203);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
+   'f',
+   5630);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   't',
+   4005);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8222);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
+   'f',
+   6426);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   't',
+   8021);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4981);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6119);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7714);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Electus'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Electus'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4368);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Electus'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5813);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (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',
+   6277);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4703);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6280);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7609);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   3765);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5197);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5437);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   7120);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   7996);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   5218);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5654);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   6812);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   6204);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5885);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7158);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   5680);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5471);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6831);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   5968);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5746);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7742);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   6677);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5663);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   6722);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   'f',
+   5497);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6533);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   6567);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   'f',
+   6283);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6144);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6716);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   'f',
+   6371);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   5858);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7630);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   'f',
+   6119);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   5799);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7625);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   'f',
+   7047);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6494);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+   't',
+   6830);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   5673);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5537);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7079);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Ink'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Ink'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   4015);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Ink'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   4863);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Ink'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6242);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   1958);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   1597);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   6119);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5965);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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',
+   7077);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   6432);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5265);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7580);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   6791);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   6133);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6919);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   6916);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   6809);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7459);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Indy'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Indy'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   4721);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   5683);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Indy'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6575);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   4465);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   4167);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6554);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Purity'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   4764);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   6352);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (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',
+   6982);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Telc'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   6809);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   7395);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6871);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   8090);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   7247);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   't',
+   7628);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5190);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   3795);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   5962);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5346);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   6453);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   7257);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5731);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   6274);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   't',
+   6955);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5562);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   6207);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7205);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5925);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   6147);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7368);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   7747);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7524);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
+   't',
+   6229);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
+   'f',
+   6069);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   5648);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7684);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
+   'f',
+   5358);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   5815);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   6934);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
+   'f',
+   5262);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   5638);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   't',
+   3360);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
+   'f',
+   5244);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   5233);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
+   'f',
+   6040);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   6057);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7848);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
+   'f',
+   5804);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   6013);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7764);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6861);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   6804);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   6821);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6738);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   6529);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7247);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6144);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   6956);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Lykkesopp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
+   't',
+   5415);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7081);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   6885);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6800);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7282);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7330);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7266);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8141);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8221);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   't',
+   6653);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5077);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7667);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5129);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6442);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5588);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7420);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5806);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7431);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5119);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7657);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5308);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7686);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6088);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   7977);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6086);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8214);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6058);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   't',
+   7956);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=4;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=4;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   5681);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7525);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6666);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7979);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6317);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8333);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   5862);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7385);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6813);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   8165);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6940);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   7899);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6626);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   7502);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=5;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=5;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   6570);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8317);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   7105);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8255);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   7174);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8253);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   8324);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7359);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   6557);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8484);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=6;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=6;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7918);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8452);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7340);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8058);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   6988);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8341);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7743);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8761);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=7;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=7;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
+   'f',
+   6209);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   6875);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
+   'f',
+   6382);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8354);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
+   'f',
+   6356);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8602);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=8;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=8;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5709);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8396);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5679);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8556);
+commit;