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

diff --git a/sql/cc04/cc3-04.sql b/sql/cc04/cc3-04.sql
index e26d061..90eaad1 100644
--- a/sql/cc04/cc3-04.sql
+++ b/sql/cc04/cc3-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('Can\'t Stop Fallin\' in Love')),
    'f',
    5340);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Ted Kristian'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7032);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick WHERE 'Pål Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -75,6 +82,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')),
    'f',
    5946);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Pål Andre'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   5875);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -96,6 +110,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')),
    'f',
    7095);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8047);
 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 3'),
@@ -117,6 +138,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')),
    'f',
    7560);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7720);
 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 3'),
@@ -138,6 +166,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')),
    'f',
    7646);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   't',
+   7702);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 2);
@@ -178,6 +213,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5338);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Jim Andre'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   't',
+   6198);
 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 3'),
@@ -199,6 +241,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    3773);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Andre'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   5277);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -220,6 +269,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5249);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7228);
 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 3'),
@@ -241,6 +297,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6708);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   't',
+   6445);
 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 3'),
@@ -262,6 +325,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7214);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   't',
+   6791);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 3);
@@ -302,6 +372,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    3531);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Glukko'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   5270);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -344,6 +421,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    3333);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Zyc'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   5149);
 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 3'),
@@ -365,6 +449,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    4391);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7298);
 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 3'),
@@ -386,6 +477,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    'f',
    8510);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   8504);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 4);
@@ -426,6 +524,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6214);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8348);
 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 3'),
@@ -447,6 +552,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6326);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8278);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -468,6 +580,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6008);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   7040);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -489,6 +608,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6169);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7682);
 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 3'),
@@ -510,6 +636,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6628);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8179);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 5);
@@ -550,6 +683,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    4383);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Eruanna'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6040);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -571,6 +711,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7069);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Advena'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7624);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -592,6 +739,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    6693);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Tassen'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7298);
 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 3'),
@@ -613,6 +767,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7357);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7321);
 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 3'),
@@ -634,6 +795,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7919);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8043);
 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 3'),
@@ -655,6 +823,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    'f',
    7881);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   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',
+   7740);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    1, 6);
@@ -695,6 +870,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',
    6212);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7211);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -716,6 +898,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',
    5655);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Gollum'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6369);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -737,6 +926,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',
    8521);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7439);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -758,6 +954,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',
    3813);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Auran'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   't',
+   4377);
 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 3'),
@@ -779,6 +982,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',
    7569);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7703);
 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 3'),
@@ -800,6 +1010,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',
    7689);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Stream'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8064);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -845,6 +1062,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    4790);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7961);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -866,6 +1090,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5504);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   7989);
 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 3'),
@@ -887,6 +1118,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5725);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8713);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -908,6 +1146,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    4994);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8140);
 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 3'),
@@ -929,6 +1174,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5515);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   8310);
 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 3'),
@@ -950,6 +1202,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
    'f',
    5518);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8271);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 2);
@@ -990,6 +1249,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    4295);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6188);
 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 3'),
@@ -1011,6 +1277,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    5857);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8053);
 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 3'),
@@ -1032,6 +1305,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    5881);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8283);
 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 3'),
@@ -1053,6 +1333,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    6437);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Stream'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8232);
 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 3'),
@@ -1074,6 +1361,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    6858);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8420);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1095,6 +1389,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
    'f',
    6499);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8601);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
    2, 3);
@@ -1135,6 +1436,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    3767);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Zyc'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);
 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 3'),
@@ -1156,6 +1464,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5773);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   6811);
 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 3'),
@@ -1177,6 +1492,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5898);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8750);
 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 3'),
@@ -1198,6 +1520,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    5513);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7941);
 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 3'),
@@ -1219,6 +1548,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    6341);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8630);
 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 3'),
@@ -1240,6 +1576,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
    'f',
    6211);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   8384);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1273,6 +1616,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6565);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Stream'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7765);
 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 3'),
@@ -1287,6 +1637,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6520);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8489);
 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 3'),
@@ -1301,6 +1658,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7553);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8621);
 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 3'),
@@ -1315,6 +1679,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7015);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   't',
+   8627);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1329,6 +1700,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7258);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8228);
 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 3'),
@@ -1343,6 +1721,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7143);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8453);
 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 3'),
@@ -1357,6 +1742,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7605);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8374);
 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 3'),
@@ -1371,6 +1763,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7185);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8475);
 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 3'),
@@ -1385,6 +1784,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    6892);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8468);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1418,6 +1824,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7528);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8273);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1432,6 +1845,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7376);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8693);
 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 3'),
@@ -1446,6 +1866,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7371);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   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, '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 3'),
@@ -1460,6 +1887,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7282);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8778);
 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 3'),
@@ -1474,6 +1908,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7352);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8808);
 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 3'),
@@ -1488,6 +1929,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7606);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   4, 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',
+   8748);
 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 3'),
@@ -1502,6 +1950,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    'f',
    7572);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8555);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1535,6 +1990,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7573);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8539);
 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 3'),
@@ -1549,6 +2011,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7586);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8349);
 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 3'),
@@ -1563,6 +2032,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7742);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8914);
 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 3'),
@@ -1577,6 +2053,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7692);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8612);
 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 3'),
@@ -1591,6 +2074,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
    'f',
    7830);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8782);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1624,6 +2114,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6376);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8635);
 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 3'),
@@ -1638,6 +2135,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6094);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8264);
 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 3'),
@@ -1652,6 +2156,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6623);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8828);
 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 3'),
@@ -1666,6 +2177,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
    'f',
    6455);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8728);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
@@ -1699,6 +2217,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8273);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Hugo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8169);
 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 3'),
@@ -1713,6 +2238,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8420);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8678);
 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 3'),
@@ -1727,6 +2259,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    'f',
    8604);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8794);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),