X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc5-04.sql;fp=sql%2Fcc04%2Fcc5-04.sql;h=2bb2e31b5b127345734c0e74884472350be132e9;hp=a660957781c1053813139cd2a80f042c984feb4c;hb=1c54093a61bb4f6633bc7649e72a33a2ccb3bb40;hpb=905e6c9f072de56b750e1aa2a34f64a528e205e9

diff --git a/sql/cc04/cc5-04.sql b/sql/cc04/cc5-04.sql
index a660957..2bb2e31 100644
--- a/sql/cc04/cc5-04.sql
+++ b/sql/cc04/cc5-04.sql
@@ -54,6 +54,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    0);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   6966);
 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'),
@@ -75,6 +82,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    6152);
+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('PARANOiA Rebirth')),
+   't',
+   7108);
 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'),
@@ -96,6 +110,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    5352);
+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('Crash!')),
+   't',
+   7198);
 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'),
@@ -117,6 +138,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    7590);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8352);
 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'),
@@ -138,6 +166,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    6831);
+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('Dead End')),
+   't',
+   7766);
 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'),
@@ -159,6 +194,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    'f',
    7576);
+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('My Summer Love')),
+   't',
+   7626);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
    1, 2);
@@ -199,6 +241,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    4361);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   5565);
 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'),
@@ -220,6 +269,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    6262);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   7712);
 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'),
@@ -241,6 +297,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    6603);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8273);
 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'),
@@ -262,6 +325,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    7596);
+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('Dead End')),
+   't',
+   7879);
 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'),
@@ -283,6 +353,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    7084);
+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('PARANOiA Rebirth')),
+   't',
+   8287);
 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'),
@@ -304,6 +381,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    'f',
    8406);
+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('Spin the disc')),
+   't',
+   7950);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
    1, 3);
@@ -344,6 +428,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    4028);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   5991);
 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'),
@@ -365,6 +456,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    4843);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7321);
 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'),
@@ -386,6 +484,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    5815);
+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('PARANOiA Rebirth')),
+   't',
+   7912);
 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'),
@@ -407,6 +512,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    5942);
+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('Exotic Ethnic')),
+   't',
+   8607);
 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'),
@@ -428,6 +540,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    6570);
+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('Spin the disc')),
+   't',
+   7713);
 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'),
@@ -449,6 +568,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
    'f',
    6463);
+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('B4U')),
+   't',
+   7926);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
    1, 4);
@@ -489,6 +615,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    4881);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   6608);
 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'),
@@ -510,6 +643,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    5443);
+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('End of the Century')),
+   't',
+   5594);
 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'),
@@ -531,6 +671,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    6291);
+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('Crash!')),
+   't',
+   8215);
 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'),
@@ -552,6 +699,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    6442);
+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('Tsugaru')),
+   't',
+   8048);
 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'),
@@ -573,6 +727,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    6436);
+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('Crash!')),
+   't',
+   8156);
 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'),
@@ -594,6 +755,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
    'f',
    6351);
+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('Dead End')),
+   't',
+   8482);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
    1, 5);
@@ -634,6 +802,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    6617);
+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('Hypnotic Crisis')),
+   't',
+   5844);
 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'),
@@ -655,6 +830,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    6631);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   7569);
 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'),
@@ -676,6 +858,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    6061);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   7656);
 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'),
@@ -697,6 +886,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7520);
+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('So Deep (Perfect Sphere Mix)')),
+   't',
+   7030);
 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'),
@@ -718,6 +914,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7930);
+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('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7759);
 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'),
@@ -739,6 +942,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    7758);
+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('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7463);
 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'),
@@ -760,6 +970,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    'f',
    8478);
+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('La Senorita')),
+   't',
+   8195);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
    1, 6);
@@ -800,6 +1017,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    5292);
+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('Spin the disc')),
+   't',
+   6141);
 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'),
@@ -821,6 +1045,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    5618);
+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('Spin the disc')),
+   't',
+   6345);
 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'),
@@ -842,6 +1073,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    5008);
+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('Crash!')),
+   't',
+   6534);
 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'),
@@ -863,6 +1101,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    6589);
+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('Crash!')),
+   't',
+   8005);
 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'),
@@ -884,6 +1129,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    6176);
+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('Tsugaru')),
+   't',
+   7953);
 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'),
@@ -905,6 +1157,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    8064);
+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('So Deep (Perfect Sphere Mix)')),
+   't',
+   7648);
 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'),
@@ -926,6 +1185,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    'f',
    7686);
+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('Spin the disc')),
+   't',
+   7587);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -971,6 +1237,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    'f',
    7553);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8550);
 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'),
@@ -992,6 +1265,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    'f',
    7442);
+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('PARANOiA Rebirth')),
+   't',
+   8239);
 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'),
@@ -1013,6 +1293,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    'f',
    8478);
+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('Dynamite Rave')),
+   't',
+   8785);
 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'),
@@ -1034,6 +1321,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    'f',
    7626);
+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('Crash!')),
+   't',
+   8773);
 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'),
@@ -1055,6 +1349,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    'f',
    8640);
+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('Dynamite Rave')),
+   't',
+   8773);
 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'),
@@ -1076,6 +1377,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    'f',
    7952);
+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('Dynamite Rave')),
+   't',
+   8653);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
    2, 2);
@@ -1116,6 +1424,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6369);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8251);
 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'),
@@ -1137,6 +1452,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6971);
+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('PARANOiA Rebirth')),
+   't',
+   8504);
 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'),
@@ -1158,6 +1480,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6863);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8476);
 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'),
@@ -1179,6 +1508,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6938);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8378);
 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'),
@@ -1200,6 +1536,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    7037);
+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('PARANOiA Rebirth')),
+   't',
+   8454);
 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'),
@@ -1221,6 +1564,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    'f',
    6748);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8457);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
    2, 3);
@@ -1261,6 +1611,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8037);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8235);
 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'),
@@ -1282,6 +1639,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8011);
+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('Crash!')),
+   't',
+   8558);
 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'),
@@ -1303,6 +1667,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8240);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8820);
 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'),
@@ -1324,6 +1695,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8158);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8486);
 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'),
@@ -1345,6 +1723,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    7795);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8495);
 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'),
@@ -1366,6 +1751,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8658);
+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('Afronova')),
+   't',
+   8677);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1399,6 +1791,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8665);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8561);
 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'),
@@ -1413,6 +1812,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8071);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8262);
 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'),
@@ -1427,6 +1833,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8651);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8731);
 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'),
@@ -1441,6 +1854,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7787);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8652);
 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'),
@@ -1455,6 +1875,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8492);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8654);
 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'),
@@ -1469,6 +1896,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8267);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8734);
 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'),
@@ -1483,6 +1917,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8565);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8643);
 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'),
@@ -1497,6 +1938,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8580);
+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('Healing Vision (Angelic Mix)')),
+   't',
+   8693);
 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'),
@@ -1511,6 +1959,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    8805);
+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('So Deep (Perfect Sphere Mix)')),
+   't',
+   8819);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1544,6 +1999,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6387);
+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('So Deep (Perfect Sphere Mix)')),
+   't',
+   7925);
 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'),
@@ -1558,6 +2020,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6883);
+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('Exotic Ethnic')),
+   't',
+   8820);
 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'),
@@ -1572,6 +2041,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6593);
+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('Exotic Ethnic')),
+   't',
+   8561);
 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'),
@@ -1586,6 +2062,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6498);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8723);
 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'),
@@ -1600,6 +2083,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6765);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8606);
 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'),
@@ -1614,6 +2104,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6536);
+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('Candy')),
+   't',
+   8855);
 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'),
@@ -1628,6 +2125,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6884);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8757);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1661,6 +2165,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    7858);
+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('Max 300')),
+   't',
+   8472);
 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'),
@@ -1675,6 +2186,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    8682);
+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('PARANOiA Rebirth')),
+   't',
+   8800);
 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'),
@@ -1689,6 +2207,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    8257);
+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('Tsugaru')),
+   't',
+   8754);
 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'),
@@ -1703,6 +2228,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    8741);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8766);
 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'),
@@ -1717,6 +2249,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
    'f',
    8403);
+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('Electro Tuned (the SubS Mix)')),
+   't',
+   8604);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1750,6 +2289,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    8198);
+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('Max 300')),
+   't',
+   9195);
 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'),
@@ -1764,6 +2310,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7744);
+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('Max 300')),
+   't',
+   8691);
 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'),
@@ -1778,6 +2331,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    8365);
+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('Trip Machine Climax')),
+   't',
+   8600);
 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'),
@@ -1792,6 +2352,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    8455);
+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('Crash!')),
+   't',
+   8875);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1825,6 +2392,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    8550);
+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('Max 300')),
+   't',
+   8972);
 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'),
@@ -1839,6 +2413,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    8763);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8905);
 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'),
@@ -1853,6 +2434,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    'f',
    8516);
+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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8070);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1886,6 +2474,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    'f',
    6621);
+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('Exotic Ethnic')),
+   't',
+   8891);
 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'),
@@ -1900,6 +2495,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    'f',
    6634);
+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('Max 300')),
+   't',
+   9672);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1933,6 +2535,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    5271);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   7905);
 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'),
@@ -1947,6 +2556,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    5683);
+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('Tsugaru')),
+   't',
+   8381);
 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'),
@@ -1961,6 +2577,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
    'f',
    5509);
+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('Tsugaru')),
+   't',
+   8471);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
@@ -1994,6 +2617,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8343);
+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('Paranoia KCET (Clean Mix)')),
+   't',
+   8674);
 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'),
@@ -2008,4 +2638,11 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8013);
+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('Max 300')),
+   't',
+   7325);
 commit;