Added CC04-8 data.

diff --git a/sql/cc04/cc8-04.sql b/sql/cc04/cc8-04.sql
new file mode 100644 (file)
index 0000000..6d26165
--- /dev/null
+++ b/sql/cc04/cc8-04.sql
@@ -0,0 +1,3202 @@
+begin;
+INSERT INTO tournaments 
+  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
+    (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
+    'Challenge Cup 8',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Bowling 1 Lillehammer',
+    '2004-12-19',
+    (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
+    (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
+);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   100);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4,
+   (SELECT player FROM players WHERE nick='OJK'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   55);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   51);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   9,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   48);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   10,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   46);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   11,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   45);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   12,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   13,
+   (SELECT player FROM players WHERE nick='T|na'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   14,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   15,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   16,
+   (SELECT player FROM players WHERE nick='Stream'),
+   40);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   17,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   18,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   38);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zredna' AS nick WHERE 'Zredna' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   19,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   37);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   20,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   21,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   35);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   22,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nuust' AS nick WHERE 'Nuust' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   23,
+   (SELECT player FROM players WHERE nick='Nuust'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   24,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick WHERE 'Sesse' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   25,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   31);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Master' AS nick WHERE 'Master' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   26,
+   (SELECT player FROM players WHERE nick='Master'),
+   30);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   27,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   29);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   28,
+   (SELECT player FROM players WHERE nick='Felz'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   29,
+   (SELECT player FROM players WHERE nick='Mync'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   30,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   31,
+   (SELECT player FROM players WHERE nick='Guru'),
+   25);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   32,
+   (SELECT player FROM players WHERE nick='Montana'),
+   24);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   33,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   23);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   34,
+   (SELECT player FROM players WHERE nick='JonAnders'),
+   22);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Evil Ed' AS nick WHERE 'Evil Ed' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   35,
+   (SELECT player FROM players WHERE nick='Evil Ed'),
+   21);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   36,
+   (SELECT player FROM players WHERE nick='Hyper'),
+   20);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   37,
+   (SELECT player FROM players WHERE nick='Goku'),
+   19);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   38,
+   (SELECT player FROM players WHERE nick='Zackie'),
+   18);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   39,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   17);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   40,
+   (SELECT player FROM players WHERE nick='Indy'),
+   16);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   41,
+   (SELECT player FROM players WHERE nick='v|per'),
+   15);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   42,
+   (SELECT player FROM players WHERE nick='Glock'),
+   14);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   43,
+   (SELECT player FROM players WHERE nick='Athena'),
+   13);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   44,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   12);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Master'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Master'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6619);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Master'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6488);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Master'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8270);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6738);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6660);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8308);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6734);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6369);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7694);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6624);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6356);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8093);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6706);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6719);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8059);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6929);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6937);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7756);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Nuust'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Nuust'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   7237);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Nuust'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   6727);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Nuust'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8453);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6593);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   5471);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7571);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Hyper'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Hyper'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6264);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Hyper'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   4876);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Hyper'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8320);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   7945);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   6385);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8507);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   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 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   7963);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   6734);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8396);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   8388);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7354);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   8694);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Evil Ed'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Evil Ed'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   4609);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Evil Ed'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5827);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Evil Ed'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7355);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='v|per'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='v|per'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5134);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='v|per'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5276);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='v|per'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6718);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   6247);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   6328);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8542);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5687);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   6207);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8572);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   6308);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   6567);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7994);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   6623);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   7128);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   't',
+   7554);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   7636);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8428);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8406);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   8003);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8158);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8519);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zackie'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zackie'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   5276);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zackie'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   6514);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Zackie'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7845);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Athena'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Athena'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   4802);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Athena'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   5373);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Athena'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7489);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mync'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mync'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   7202);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mync'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8496);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mync'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8554);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   7483);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8679);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8809);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   8321);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8881);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   't',
+   8616);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5470);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6054);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8663);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Guru'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Guru'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5347);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Guru'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   5650);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Guru'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8047);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Goku'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Goku'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   4947);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Goku'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   5990);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Goku'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   7891);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   4600);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   4726);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7537);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5210);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6351);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8180);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   6101);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6778);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8466);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5487);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6818);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8107);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Glock'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Glock'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6054);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Glock'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   'f',
+   5164);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Glock'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6318);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='JonAnders'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='JonAnders'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6545);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='JonAnders'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   'f',
+   5614);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='JonAnders'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7394);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7156);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   'f',
+   7261);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8533);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6690);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   'f',
+   7365);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8441);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7458);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   'f',
+   7554);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8774);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7729);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   'f',
+   7620);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   8501);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Indy'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   5526);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
+   'f',
+   5459);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Indy'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7379);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Montana'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Montana'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   7483);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Montana'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
+   'f',
+   5227);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Montana'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7768);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Felz'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Felz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   7800);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Felz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
+   'f',
+   6311);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Felz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   7844);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   8006);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
+   'f',
+   6209);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8510);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='T|na'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   7910);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
+   'f',
+   6828);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8627);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   8463);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
+   'f',
+   7025);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   1, 7,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   8691);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stream'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stream'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8235);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stream'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   8241);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stream'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8621);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8508);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7030);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8358);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8551);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7999);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8787);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8803);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7817);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8543);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8780);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   8316);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8748);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8852);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   8327);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8728);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   'f',
+   8694);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   8286);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8660);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   6347);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   7766);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8344);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   6316);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   7166);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Zredna'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8524);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   6795);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   8776);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   8850);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   5902);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   7552);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8584);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   6269);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   8408);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8717);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   6430);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   8157);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8766);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
+   'f',
+   6782);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   8742);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8500);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6347);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8358);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8516);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6261);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8225);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8294);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6218);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8663);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8760);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6085);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8491);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8550);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6508);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8698);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8630);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5161);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8179);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8147);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6617);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8732);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8332);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 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 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   6085);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8615);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   5663);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8664);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   6167);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8697);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   6571);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8537);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   6545);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8520);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   5880);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8851);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   6434);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8770);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   6697);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8887);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+   'f',
+   5690);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8608);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=4;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=4;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   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 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   6599);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8377);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   7122);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8309);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   7322);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8639);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   7369);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8574);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   7541);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8823);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   7100);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   't',
+   8450);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   7766);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8673);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=5;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=5;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   8648);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8629);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   8829);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8556);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   8463);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8313);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   8498);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8793);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   8909);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8934);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (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 8'),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=6;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8669);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   8951);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8729);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   9424);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 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 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8588);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   9179);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8654);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   9826);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=7;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=7;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 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 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7559);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8751);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7562);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8834);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7506);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8918);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=8;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND 
+  round=8;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5582);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8826);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5915);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8891);
+commit;

diff --git a/sql/cc04/update-cc04.sh b/sql/cc04/update-cc04.sh
index d1902bbc3b5d3b5d5b35dec6b5d82cb249eec7b2..231f3a851980d8375a72816e20a8ce3d1c38add5 100755 (executable)
--- a/sql/cc04/update-cc04.sh
+++ b/sql/cc04/update-cc04.sh
@@ -16,4 +16,5 @@ SEASON="Challenge Cup 2004"
 5      39
 6      40
 7      41
+8      42
 EOF