X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fcc03%2Fcc3-03.sql;fp=sql%2Fcc03%2Fcc3-03.sql;h=9fce0b1f7ba1db884eef14783001124c2b40b7ea;hb=4d850240c7ff389bf6ad596287abb7d542af72bb;hp=0000000000000000000000000000000000000000;hpb=69e91c419df45838d7c85633b10d0998f0f92f7a;p=ccbs

diff --git a/sql/cc03/cc3-03.sql b/sql/cc03/cc3-03.sql
new file mode 100644
index 0000000..9fce0b1
--- /dev/null
+++ b/sql/cc03/cc3-03.sql
@@ -0,0 +1,1685 @@
+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 3',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Drammen Bowling',
+    '2003-08-03',
+    (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 3' 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 3' 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, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   81);
+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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6,
+   (SELECT player FROM players WHERE nick='Telc'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   55);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   51);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   9,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   48);
+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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   10,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   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 3' 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, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   12,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Vampyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Vampyro' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   13,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   14,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   15,
+   (SELECT player FROM players WHERE nick='Havok'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   16,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   40);
+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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   17,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   39);
+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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   18,
+   (SELECT player FROM players WHERE nick='Purity'),
+   38);
+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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   19,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   37);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Secret Rendez-vous')),
+   'f',
+   3475);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Remember You')),
+   'f',
+   3809);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6242);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+   'f',
+   3562);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   3735);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   6943);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+   'f',
+   4016);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   4438);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7479);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+   'f',
+   3659);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   4367);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   7391);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   'f',
+   4943);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   4098);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6884);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('era (nostalmix)')),
+   'f',
+   6338);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Hypnotic Crisis')),
+   'f',
+   5589);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Dead End')),
+   't',
+   6831);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   'f',
+   5667);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   4902);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   't',
+   5634);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   'f',
+   7084);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7014);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   7086);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   'f',
+   7012);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7294);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   't',
+   7130);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 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 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   4912);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   3279);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   't',
+   5969);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   6208);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   4587);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6233);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   7551);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   4823);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7438);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   6537);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   5252);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6967);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8256);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   5906);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   't',
+   5858);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   4399);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   4954);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Suspect'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6959);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6465);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   4085);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6835);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6766);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5263);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7234);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6105);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5321);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7297);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8352);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5583);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   't',
+   7049);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4556);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   5382);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7576);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4530);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   5726);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7207);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('That was then, This is now')),
+   'f',
+   5056);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('www.blonde girl (MOMO Mix)')),
+   'f',
+   6073);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Afronova')),
+   't',
+   7524);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5140);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   6443);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8092);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5046);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   5771);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7660);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   5291);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5402);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6378);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Look to the sky')),
+   'f',
+   5779);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('B4U (B4 Za Beat Mix)')),
+   'f',
+   5254);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Paranoia KCET (Clean Mix)')),
+   't',
+   7042);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   6106);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5747);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7235);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   4980);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   4948);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7733);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Look to the sky')),
+   'f',
+   5676);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('B4U (B4 Za Beat Mix)')),
+   'f',
+   6436);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Afronova')),
+   't',
+   8060);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   4872);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5081);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7701);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 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 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   5538);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8223);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   5433);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Cotton-Eye Joe')),
+   'f',
+   5900);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Max 300')),
+   't',
+   6985);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Cotton-Eye Joe')),
+   'f',
+   5677);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Groove 2001')),
+   't',
+   6430);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 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 3' 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('Cotton-Eye Joe')),
+   'f',
+   6240);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Max 300')),
+   't',
+   8004);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 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 3' 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('Cotton-Eye Joe')),
+   'f',
+   6002);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8019);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 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 3' 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('Luv to Me (AMD Mix)')),
+   'f',
+   5956);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Tsugaru')),
+   't',
+   7988);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 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 3' 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('Luv to Me (AMD Mix)')),
+   'f',
+   6259);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8065);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+   'f',
+   6627);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8205);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 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 3' 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('Luv to Me (AMD Mix)')),
+   'f',
+   6716);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Max 300')),
+   't',
+   8791);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Luv to Me (AMD Mix)')),
+   'f',
+   7089);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Electro Tuned (the SubS Mix)')),
+   't',
+   8476);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Spin the disc')),
+   'f',
+   6852);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7810);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   6975);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8034);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 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 3' 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('Spin the disc')),
+   'f',
+   7570);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Exotic Ethnic')),
+   't',
+   8703);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Spin the disc')),
+   'f',
+   7596);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Hypnotic Crisis')),
+   't',
+   7906);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7630);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8152);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Dead End')),
+   'f',
+   8263);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 KCET (Clean Mix)')),
+   't',
+   8557);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Dead End')),
+   'f',
+   8407);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8396);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Let the Beat Hit \'em!')),
+   'f',
+   6379);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8421);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Let the Beat Hit \'em!')),
+   'f',
+   5920);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8664);
+commit;