Add scripts for getting CC03 data, and premade SQL.

[ccbs] / sql / cc03 / cc1-03.sql

diff --git a/sql/cc03/cc1-03.sql b/sql/cc03/cc1-03.sql
new file mode 100644 (file)
index 0000000..0fea40f
--- /dev/null
+++ b/sql/cc03/cc1-03.sql
@@ -0,0 +1,1597 @@
+begin;
+INSERT INTO tournaments 
+  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
+    (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+    'Challenge Cup 1',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Oslo Bowling',
+    '2003-05-25',
+    (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
+    (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
+);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   100);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   55);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   8,
+   (SELECT player FROM players WHERE nick='Telc'),
+   51);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   9,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   48);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   10,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   46);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   11,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   45);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   12,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   13,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   14,
+   (SELECT player FROM players WHERE nick='Havok'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   15,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Vampyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Vampyro' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   16,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   40);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'TheKnight' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'TheKnight' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   17,
+   (SELECT player FROM players WHERE nick='TheKnight'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   18,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   38);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   3926);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   3806);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6647);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   7568);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   7096);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7454);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   5575);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   3661);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   6915);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   5455);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   6535);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   7864);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   5185);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   4101);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7709);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   5560);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7504);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+   't',
+   7101);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   4690);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   5016);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Vampyro'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   6309);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   5309);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   5780);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   4999);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   5528);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   6735);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6636);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   5807);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   4853);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   't',
+   6133);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   5584);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   5091);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6438);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   5425);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   5027);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   6102);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='TheKnight'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='TheKnight'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   5175);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='TheKnight'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   4315);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='TheKnight'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   5698);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   'f',
+   7728);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6338);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   7591);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6717);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5141);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6898);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   5362);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   4767);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6785);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   1844);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   3538);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   't',
+   3555);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7297);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   7229);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   't',
+   6649);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   6926);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   6320);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7437);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Telc'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   5423);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Telc'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   5566);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Telc'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   5929);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   6695);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   5615);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   6806);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   4936);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   5373);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6074);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   7899);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   6571);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7238);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   6288);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5026);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   6998);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5420);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   4877);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7038);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5401);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   4877);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   6368);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   6305);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5931);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8222);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+   'f',
+   5871);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5310);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8202);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   6406);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   't',
+   7317);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   5257);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   't',
+   6048);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   7751);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7552);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8535);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   't',
+   7282);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   7657);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8025);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=4;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=4;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   4222);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7412);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   4090);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7765);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   4394);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8245);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   4379);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   7906);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
+   'f',
+   4643);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8272);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=5;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=5;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4784);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7254);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4982);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8407);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   4978);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8085);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5267);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8395);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=6;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=6;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+   'f',
+   4204);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8250);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+   'f',
+   4846);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8355);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+   'f',
+   4723);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8459);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=7;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
+  round=7;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   7496);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8355);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   7293);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8092);
+commit;