Add scripts for getting CC03 data, and premade SQL.

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

diff --git a/sql/cc03/cc5-03.sql b/sql/cc03/cc5-03.sql
new file mode 100644 (file)
index 0000000..9aa7bf3
--- /dev/null
+++ b/sql/cc03/cc5-03.sql
@@ -0,0 +1,2587 @@
+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 5',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Oslo Bowling',
+    '2003-10-19',
+    (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 5' 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 5' 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, '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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4,
+   (SELECT player FROM players WHERE nick='OJK'),
+   73);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   66);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   55);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   51);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   9,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   48);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   10,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   46);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   11,
+   (SELECT player FROM players WHERE nick='Electus'),
+   45);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   12,
+   (SELECT player FROM players WHERE nick='ViD'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   13,
+   (SELECT player FROM players WHERE nick='Purity'),
+   43);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   14,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   42);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   15,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   41);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   16,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   40);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   17,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   39);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   18,
+   (SELECT player FROM players WHERE nick='Indy'),
+   38);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   19,
+   (SELECT player FROM players WHERE nick='Havok'),
+   37);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   20,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   36);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   21,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   35);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   22,
+   (SELECT player FROM players WHERE nick='Advena'),
+   34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Iris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Iris' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   23,
+   (SELECT player FROM players WHERE nick='Iris'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   24,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Freaky Mama=)' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Freaky Mama=)' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   25,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   31);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   26,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   30);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   27,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   29);
+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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   28,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   29,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   30,
+   (SELECT player FROM players WHERE nick='Haz'),
+   26);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haz'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   2768);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   3079);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   't',
+   3624);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   4221);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   4354);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   't',
+   5644);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   4670);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   4347);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7451);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   4599);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   4252);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (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',
+   6888);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6229);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('20th November')),
+   'f',
+   5912);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Living in America')),
+   't',
+   6690);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6892);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   6580);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7310);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6009);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   5979);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7238);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6274);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   6010);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (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',
+   7956);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6120);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   'f',
+   5947);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   7459);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('End of the Century')),
+   'f',
+   7890);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Trip Machine (Luv Mix)')),
+   'f',
+   6608);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Spin the disc')),
+   't',
+   7671);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Iris'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Iris'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   3760);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Iris'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   4921);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Iris'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   5985);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   4424);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   4157);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   5556);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5069);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   5259);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   't',
+   5770);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5839);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   5738);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6332);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   6293);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   6115);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6880);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   4980);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   4673);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6277);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Indy'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   5399);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5400);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Indy'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6885);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='ViD'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   5799);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5137);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7907);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   5499);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   4302);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7343);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   6314);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5536);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7643);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   4761);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   5411);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6918);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5904);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   5765);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8186);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5447);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6036);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8035);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5666);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   5357);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7602);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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 5' 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('La Senorita')),
+   'f',
+   5947);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Burnin\' the Floor')),
+   'f',
+   6114);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Electro Tuned (the SubS Mix)')),
+   't',
+   7843);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   4808);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   4463);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   't',
+   4987);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Advena'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   4970);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Advena'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6383);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Advena'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6936);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Electus'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Electus'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5876);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Electus'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7977);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Electus'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7190);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5522);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6970);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6861);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5220);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7496);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7111);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   4682);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   3725);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6753);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (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 5' 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('Aaron\'s Party (Come Get It)')),
+   'f',
+   6504);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Afronova')),
+   'f',
+   5728);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Max 300')),
+   't',
+   6960);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6614);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   6618);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8096);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6900);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   6661);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7849);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 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 5' 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('Aaron\'s Party (Come Get It)')),
+   'f',
+   7048);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Afronova')),
+   'f',
+   8008);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Dead End')),
+   't',
+   8315);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Electus'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Electus'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   5645);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Electus'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   6282);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (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',
+   7567);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   3732);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   't',
+   3091);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   6981);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   4496);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8152);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5954);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8056);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7449);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   4835);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7460);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('Dead End')),
+   'f',
+   8377);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Stomp')),
+   'f',
+   5711);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Trip Machine Climax')),
+   't',
+   7902);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8385);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   6179);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8194);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (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 5' 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 5' 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 5' 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 5' 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('Memories')),
+   'f',
+   5016);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Spin the disc')),
+   'f',
+   6133);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Exotic Ethnic')),
+   't',
+   6413);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Memories')),
+   'f',
+   5489);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Spin the disc')),
+   'f',
+   6810);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Tsugaru')),
+   't',
+   7453);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+   'f',
+   5045);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   5932);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+   'f',
+   5485);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   6467);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7593);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+   'f',
+   5989);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7621);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   7872);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+   'f',
+   5431);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7146);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7460);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 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 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Trip Machine Climax')),
+   'f',
+   6194);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Electro Tuned (the SubS Mix)')),
+   't',
+   7355);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7429);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7824);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Trip Machine Climax')),
+   'f',
+   8022);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Afronova')),
+   't',
+   8039);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Trip Machine Climax')),
+   'f',
+   5759);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Paranoia KCET (Clean Mix)')),
+   't',
+   7804);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   6901);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7654);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7057);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7713);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Trip Machine Climax')),
+   'f',
+   7668);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Tsugaru')),
+   't',
+   8029);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Trip Machine Climax')),
+   'f',
+   7983);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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',
+   8184);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('Trip Machine Climax')),
+   'f',
+   8104);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('My Summer Love')),
+   't',
+   7539);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8033);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7947);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8160);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8337);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   7785);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   7257);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Tsugaru')),
+   'f',
+   8389);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('PARANOiA Rebirth')),
+   't',
+   8470);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Tsugaru')),
+   'f',
+   7771);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Paranoia KCET (Clean Mix)')),
+   't',
+   8458);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Tsugaru')),
+   'f',
+   8190);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Paranoia KCET (Clean Mix)')),
+   't',
+   7915);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 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 5' 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('Tsugaru')),
+   'f',
+   8055);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8541);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 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 5' 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 5' 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 5' 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 5' 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('5, 6, 7, 8')),
+   'f',
+   5673);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8261);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('5, 6, 7, 8')),
+   'f',
+   5421);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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',
+   8251);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5505);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8294);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('5, 6, 7, 8')),
+   'f',
+   5716);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Paranoia KCET (Clean Mix)')),
+   't',
+   8801);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('5, 6, 7, 8')),
+   'f',
+   5724);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Electro Tuned (the SubS Mix)')),
+   't',
+   8568);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5429);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7992);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6160);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8746);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('The Vibe is Right')),
+   'f',
+   6026);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Max 300')),
+   't',
+   8519);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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('The Vibe is Right')),
+   'f',
+   6328);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('PARANOiA Rebirth')),
+   't',
+   8291);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Groove 2001')),
+   'f',
+   6794);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Crash!')),
+   't',
+   8434);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 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 5' 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('Groove 2001')),
+   'f',
+   6238);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Max 300')),
+   't',
+   8813);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   'f',
+   6531);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8457);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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 5' 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 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('DXY!')),
+   'f',
+   7588);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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',
+   8807);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('DXY!')),
+   'f',
+   7246);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5' 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('Paranoia KCET (Clean Mix)')),
+   't',
+   8598);
+commit;