Add scripts for getting CC03 data, and premade SQL.

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

diff --git a/sql/cc03/cc6-03.sql b/sql/cc03/cc6-03.sql
new file mode 100644 (file)
index 0000000..54265f1
--- /dev/null
+++ b/sql/cc03/cc6-03.sql
@@ -0,0 +1,2300 @@
+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 6',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Oslo Bowling',
+    '2003-11-02',
+    (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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 6' 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, '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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5,
+   (SELECT player FROM players WHERE nick='DufF'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   60);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7,
+   (SELECT player FROM players WHERE nick='Havok'),
+   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 6' 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, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   9,
+   (SELECT player FROM players WHERE nick='T|na'),
+   48);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   10,
+   (SELECT player FROM players WHERE nick='Telc'),
+   46);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   11,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   45);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   12,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   44);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   13,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   43);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   14,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   42);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   15,
+   (SELECT player FROM players WHERE nick='Electus'),
+   41);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   16,
+   (SELECT player FROM players WHERE nick='Purity'),
+   40);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   17,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   39);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   18,
+   (SELECT player FROM players WHERE nick='Advena'),
+   38);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   19,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   37);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   20,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Suspect' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Suspect' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   21,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   35);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nevrosert' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nevrosert' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   22,
+   (SELECT player FROM players WHERE nick='Nevrosert'),
+   34);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   23,
+   (SELECT player FROM players WHERE nick='Private Ryan'),
+   33);
+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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   24,
+   (SELECT player FROM players WHERE nick='Haz'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   25,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   31);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nevrosert'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nevrosert'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nevrosert'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
+   'f',
+   4579);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nevrosert'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6735);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 Reflex')),
+   'f',
+   3063);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Never Ending Story')),
+   'f',
+   3907);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   6015);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 Reflex')),
+   'f',
+   4471);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Never Ending Story')),
+   'f',
+   5120);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Crash!')),
+   't',
+   6472);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   3374);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
+   'f',
+   4974);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   6833);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 Reflex')),
+   'f',
+   5105);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Never Ending Story')),
+   'f',
+   6425);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Healing Vision (Angelic Mix)')),
+   't',
+   7918);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   4795);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5745);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6438);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   5122);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5613);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6071);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Let Them Move')),
+   'f',
+   5092);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Silent Hill')),
+   'f',
+   5619);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   7482);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   5549);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5579);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   7492);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Let Them Move')),
+   'f',
+   6292);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Silent Hill')),
+   'f',
+   6455);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('era (nostalmix)')),
+   't',
+   7512);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (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 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+   'f',
+   6101);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7638);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8212);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Memories')),
+   'f',
+   4884);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6640);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   5627);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+   'f',
+   5224);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8142);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7182);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+   'f',
+   6315);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6768);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7803);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Memories')),
+   'f',
+   6462);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8197);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Healing Vision (Angelic Mix)')),
+   't',
+   7749);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   4206);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   5117);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6097);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Advena'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   4552);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Advena'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6761);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Advena'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7122);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   5297);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6698);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7428);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   5886);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7052);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7403);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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',
+   6276);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7016);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   7674);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4749);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   5535);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7480);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5216);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   7478);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7440);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Electus'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4956);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Electus'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6523);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Electus'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8158);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4696);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6963);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 5,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7478);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('That was then, This is now')),
+   'f',
+   5121);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('B4U')),
+   'f',
+   6597);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   7531);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   6104);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5800);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7497);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   6640);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5838);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7693);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (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 6' 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('Afronova Primeval')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Don\'t Try to Stop It')),
+   'f',
+   5518);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('era (nostalmix)')),
+   't',
+   6586);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   7084);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6231);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7003);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   8044);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6939);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8044);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   5348);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   6667);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7092);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7067);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   7499);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   't',
+   7200);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7316);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   7914);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   7968);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Spin the disc')),
+   'f',
+   7171);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Paranoia KCET (Clean Mix)')),
+   'f',
+   8143);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   8035);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7546);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8540);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   't',
+   7579);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   7067);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   4574);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6972);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')),
+   'f',
+   6614);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')),
+   'f',
+   4664);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7239);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Havok'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   7493);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   5199);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6946);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   8643);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   5987);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   't',
+   8007);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Electro Tuned (the SubS Mix)')),
+   'f',
+   8235);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')),
+   'f',
+   5712);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   8043);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
+   'f',
+   5247);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7963);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')),
+   'f',
+   4997);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7806);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')),
+   'f',
+   5585);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')),
+   't',
+   8046);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
+   'f',
+   4722);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7414);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')),
+   'f',
+   6101);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8151);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')),
+   'f',
+   6374);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   8150);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')),
+   'f',
+   6012);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')),
+   't',
+   8134);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Higher')),
+   'f',
+   6193);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')),
+   't',
+   8323);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Higher')),
+   'f',
+   6014);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Trip Machine Climax')),
+   't',
+   8113);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+   'f',
+   4624);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7303);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 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 6' 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('Secret Rendez-vous')),
+   'f',
+   5038);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   8737);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 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 6' 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('Secret Rendez-vous')),
+   'f',
+   6178);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')),
+   't',
+   8278);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Secret Rendez-vous')),
+   'f',
+   5631);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Afronova')),
+   't',
+   8194);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Secret Rendez-vous')),
+   'f',
+   5441);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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',
+   8342);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Secret Rendez-vous')),
+   'f',
+   5932);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Crash!')),
+   't',
+   8353);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 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 6' 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('Secret Rendez-vous')),
+   'f',
+   6227);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')),
+   't',
+   7896);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 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 6' 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('D2R')),
+   'f',
+   5833);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')),
+   't',
+   8295);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')),
+   'f',
+   5640);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8142);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')),
+   'f',
+   5816);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Paranoia KCET (Clean Mix)')),
+   't',
+   8256);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('D2R')),
+   'f',
+   6030);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8613);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('D2R')),
+   'f',
+   6287);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8418);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   7185);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7885);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 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 6' 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('So Deep (Perfect Sphere Mix)')),
+   'f',
+   6497);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Max 300')),
+   't',
+   7496);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('So Deep (Perfect Sphere Mix)')),
+   'f',
+   8261);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7507);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 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 6' 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('So Deep (Perfect Sphere Mix)')),
+   'f',
+   8308);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('PARANOiA Rebirth')),
+   't',
+   8328);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   6422);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7716);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Cotton-Eye Joe')),
+   'f',
+   6333);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Exotic Ethnic')),
+   't',
+   8812);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Cotton-Eye Joe')),
+   'f',
+   6287);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')),
+   't',
+   8596);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Never Let You Down')),
+   'f',
+   6751);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Max 300')),
+   'f',
+   8548);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Never Let You Down')),
+   'f',
+   6756);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Max 300')),
+   'f',
+   8753);
+commit;