Update CC test data.

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

diff --git a/sql/cc04/cc6-04.sql b/sql/cc04/cc6-04.sql
index a489a0b9e698144fff1d30da5fde5c993a6d6fa3..c1823f7363e75e21b8fd15cd4b4441e2b97f0295 100644 (file)
--- a/sql/cc04/cc6-04.sql
+++ b/sql/cc04/cc6-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('Make A Jam!')),
    'f',
    5501);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5501);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7419);

 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 6'),
 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 6'),


@@ -75,6 +82,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6227);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6227);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8128);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -96,6 +110,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5710);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    5710);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Glukko'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   't',
+   6217);

 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 6'),
 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 6'),


@@ -117,6 +138,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6776);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6776);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7682);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -138,6 +166,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6685);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    6685);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   7879);

 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 6'),
 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 6'),


@@ -159,6 +194,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7370);
    (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
    'f',
    7370);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7850);

 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 2);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    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('Groove 2001')),
    'f',
    4862);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    4862);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Glock'),
+   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+   't',
+   6209);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -220,6 +269,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    4915);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    4915);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Athena'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6770);

 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 6'),
 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 6'),


@@ -241,6 +297,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6092);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6092);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8000);

 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 6'),
 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 6'),


@@ -262,6 +325,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6430);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6430);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8087);

 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 6'),
 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 6'),


@@ -283,6 +353,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    5959);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    5959);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8164);

 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 6'),
 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 6'),


@@ -304,6 +381,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6834);
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
    'f',
    6834);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7948);

 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 3);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    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('DXY!')),
    'f',
    4486);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    4486);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6459);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -365,6 +456,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6820);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6820);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='ViD'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8600);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -386,6 +484,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5109);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5109);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Hyper'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7931);

 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 6'),
 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 6'),


@@ -407,6 +512,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5713);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    5713);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8175);

 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 6'),
 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 6'),


@@ -428,6 +540,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    7573);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    7573);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7759);

 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 6'),
 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 6'),


@@ -449,6 +568,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6988);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    6988);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7904);

 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 6'),
 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 6'),


@@ -470,6 +596,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    7599);
    (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
    'f',
    7599);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   't',
+   7661);

 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 4);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 4);


@@ -510,6 +643,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5420);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5420);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Electron'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7443);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -531,6 +671,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4598);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4598);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Guru'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   4905);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -552,6 +699,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4341);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    4341);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Annkakri'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6245);

 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 6'),
 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 6'),


@@ -573,6 +727,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5600);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5600);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Felz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8080);

 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 6'),
 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 6'),


@@ -594,6 +755,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6218);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6218);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7977);

 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 6'),
 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 6'),


@@ -615,6 +783,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5958);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    5958);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7425);

 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 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -636,6 +811,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6748);
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
    6748);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   7973);

 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 5);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 5);


@@ -676,6 +858,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5900);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5900);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Goku'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8359);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -697,6 +886,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4624);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4624);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Montana'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6637);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -718,6 +914,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4202);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    4202);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='JonAnders'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   't',
+   5502);

 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 6'),
 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 6'),


@@ -739,6 +942,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6053);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6053);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7984);

 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 6'),
 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 6'),


@@ -760,6 +970,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6100);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6100);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8393);

 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 6'),
 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 6'),


@@ -781,6 +998,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6543);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    6543);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8218);

 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 6'),
 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 6'),


@@ -802,6 +1026,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5993);
    (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
    'f',
    5993);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 5,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8380);

 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 6);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    1, 6);


@@ -842,6 +1073,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5382);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5382);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Matti'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6848);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -863,6 +1101,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5011);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5011);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='v|per'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   6587);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -884,6 +1129,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    4324);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    4324);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Zackie'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7930);

 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 6'),
 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 6'),


@@ -905,6 +1157,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5565);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5565);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Mync'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8405);

 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 6'),
 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 6'),


@@ -926,6 +1185,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5751);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    5751);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7400);

 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 6'),
 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 6'),


@@ -947,6 +1213,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6416);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6416);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8174);

 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 6'),
 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 6'),


@@ -968,6 +1241,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6500);
    (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
    'f',
    6500);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   1, 6,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8217);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1013,6 +1293,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7085);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7085);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8642);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1034,6 +1321,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7492);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7492);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8193);

 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 6'),
 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 6'),


@@ -1055,6 +1349,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7877);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7877);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8246);

 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 6'),
 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 6'),


@@ -1076,6 +1377,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7370);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    7370);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8578);

 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 6'),
 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 6'),


@@ -1097,6 +1405,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    8498);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    8498);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7791);

 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 6'),
 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 6'),


@@ -1118,6 +1433,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    6574);
    (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
    'f',
    6574);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8746);

 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    2, 2);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    2, 2);


@@ -1158,6 +1480,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5171);
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5171);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Felz'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   7990);

 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 6'),
 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 6'),


@@ -1179,6 +1508,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    4738);
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    4738);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Mync'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   7743);

 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 6'),
 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 6'),


@@ -1200,6 +1536,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    6567);
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    6567);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   8418);

 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 6'),
 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 6'),


@@ -1221,6 +1564,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5690);
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5690);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='T|na'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8644);

 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 6'),
 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 6'),


@@ -1242,6 +1592,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    6182);
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    6182);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   8377);

 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 6'),
 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 6'),


@@ -1263,6 +1620,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5429);
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
    'f',
    5429);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8230);

 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    2, 3);
 INSERT INTO groups (tournament, round, parallel) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
    2, 3);


@@ -1303,6 +1667,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7291);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    7291);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8168);

 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 6'),
 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 6'),


@@ -1324,6 +1695,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8560);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8560);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   7971);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1345,6 +1723,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8719);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8719);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8686);

 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 6'),
 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 6'),


@@ -1366,6 +1751,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8333);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8333);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8544);

 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 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1387,6 +1779,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8720);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8720);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8793);

 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 6'),
 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 6'),


@@ -1408,6 +1807,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8545);
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
    8545);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8190);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1441,6 +1847,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',
    8064);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8064);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8627);

 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 6'),
 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 6'),


@@ -1455,6 +1868,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',
    8296);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8296);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8550);

 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 6'),
 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 6'),


@@ -1469,6 +1889,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',
    8207);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8207);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8133);

 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 6'),
 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 6'),


@@ -1483,6 +1910,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',
    8015);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8015);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8414);

 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 6'),
 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 6'),


@@ -1497,6 +1931,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',
    8704);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8704);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8635);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1511,6 +1952,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',
    8494);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8494);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8459);

 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 6'),
 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 6'),


@@ -1525,6 +1973,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',
    8755);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8755);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8367);

 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 6'),
 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 6'),


@@ -1539,6 +1994,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',
    8769);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8769);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   't',
+   8743);

 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 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1553,6 +2015,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',
    8631);
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    'f',
    8631);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8251);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1586,6 +2055,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6585);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6585);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8675);

 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 6'),
 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 6'),


@@ -1600,6 +2076,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7296);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7296);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8557);

 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 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1614,6 +2097,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6862);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6862);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8753);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1628,6 +2118,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6871);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6871);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8802);

 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 6'),
 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 6'),


@@ -1642,6 +2139,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6848);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    6848);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8826);

 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 6'),
 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 6'),


@@ -1656,6 +2160,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7316);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7316);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8493);

 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 6'),
 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 6'),


@@ -1670,6 +2181,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7651);
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
    'f',
    7651);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8673);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1703,6 +2221,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6649);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6649);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8825);

 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 6'),
 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 6'),


@@ -1717,6 +2242,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6860);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6860);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8636);

 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 6'),
 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 6'),


@@ -1731,6 +2263,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6603);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6603);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8868);

 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 6'),
 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 6'),


@@ -1745,6 +2284,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6652);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6652);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8169);

 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 6'),
 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 6'),


@@ -1759,6 +2305,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6675);
    (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
    'f',
    6675);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8939);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1792,6 +2345,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    5446);
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    5446);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8499);

 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1806,6 +2366,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    5477);
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    5477);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8241);

 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 6'),
 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 6'),


@@ -1820,6 +2387,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    6489);
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    6489);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8776);

 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 6'),
 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 6'),


@@ -1834,6 +2408,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    6480);
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
    'f',
    6480);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8849);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),


@@ -1867,6 +2448,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7282);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7282);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   't',
+   8841);

 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 6'),
 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 6'),


@@ -1881,6 +2469,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7327);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7327);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8803);

 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 6'),
 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 6'),


@@ -1895,6 +2490,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7717);
    (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
    'f',
    7717);

+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8717);

 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),