Added test data (almost entire CC 2004 season).

[ccbs] / sql / cc04 / cc5-04.sql

diff --git a/sql/cc04/cc5-04.sql b/sql/cc04/cc5-04.sql
new file mode 100644 (file)
index 0000000..a660957
--- /dev/null
+++ b/sql/cc04/cc5-04.sql
@@ -0,0 +1,2011 @@
+begin;
+INSERT INTO tournaments 
+  (season, name, country, location, "date", machine, scoringsystem) VALUES (
+    (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
+    'Challenge Cup 5 - NM',
+    (SELECT country FROM countries WHERE name='Norway'),
+    'OsloLan',
+    '2004-10-02',
+    (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
+    (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score')
+);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (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 name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   4721);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5019);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   6152);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Zeila'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Zeila'),
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5066);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Zeila'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   5352);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Stream'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Stream'),
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6156);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Stream'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   7590);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5813);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   6831);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6444);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   7576);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   5567);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   4361);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   5491);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6262);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6086);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6603);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6327);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   7596);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6255);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   7084);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6772);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   8406);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mickva'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mickva'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   4465);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mickva'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   4028);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Havok'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   4920);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Havok'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   4843);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Felz'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Felz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5808);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Felz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   5815);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mync'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mync'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5263);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Mync'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   5942);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   6737);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   6570);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   7205);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   6463);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Ingviild'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Ingviild'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   5859);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Ingviild'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   4881);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   6613);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Ngan'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   5443);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   7812);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Cuivien'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   6291);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   8313);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   6442);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   8573);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   6436);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   'f',
+   7958);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
+   'f',
+   6351);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   5747);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   6617);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Lindaninja'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Lindaninja'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   6165);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Lindaninja'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   6631);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Asphodel'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Asphodel'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   7341);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Asphodel'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   6061);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   7809);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Cehtna'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   7520);
+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 roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='T|na'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8235);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   7930);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8154);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   7758);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   'f',
+   8580);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   'f',
+   8478);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Athena'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Athena'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   4975);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Athena'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   5292);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Andre'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Andre'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5503);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Andre'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   5618);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Marilla'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Marilla'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5338);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Marilla'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   5008);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6040);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   6589);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   4809);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   6176);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6040);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   8064);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6274);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   7686);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=2;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8122);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7553);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mync'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mync'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   7831);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mync'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7442);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8742);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   8478);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8218);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7626);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8734);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   8640);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='OJK'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8692);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7952);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=2;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6062);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6369);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6416);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6971);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6535);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6863);
+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 roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='T|na'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6705);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6938);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6565);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   7037);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6181);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6748);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=2;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   5689);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8037);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6172);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8011);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6544);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8240);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   5960);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8158);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6287);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Stream'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7795);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6870);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8658);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=3;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8665);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8071);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8651);
+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 roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7787);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8492);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8267);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8565);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8580);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   9
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8805);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=4;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=4;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6387);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6883);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6593);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6498);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6765);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6536);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
+   'f',
+   6884);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=5;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=5;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   7858);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   8682);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   8257);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   8741);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   8403);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=6;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=6;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8198);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   7744);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8365);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8455);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=7;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=7;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   8550);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   8763);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   8516);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   8,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   8, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   8, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=8;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=8;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   6621);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   6634);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=9;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=9;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
+   'f',
+   5271);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
+   'f',
+   5683);
+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 roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   9, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
+   'f',
+   5509);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   10,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   10, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   10, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=10;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND 
+  round=10;
+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 roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   10, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   10, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8343);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   10, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+   10, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   8013);
+commit;