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 3',
    (SELECT country FROM countries WHERE countryname='Norway'),
    'Drammen Bowling',
    '2003-08-03',
    (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 3' 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 3' 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, '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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3,
   (SELECT player FROM players WHERE nick='Daniil'),
   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 3' 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, '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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   66);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6,
   (SELECT player FROM players WHERE nick='Telc'),
   60);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7,
   (SELECT player FROM players WHERE nick='Yeye'),
   55);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8,
   (SELECT player FROM players WHERE nick='Slusk'),
   51);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   9,
   (SELECT player FROM players WHERE nick='Draconia'),
   48);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   10,
   (SELECT player FROM players WHERE nick='kjmcw'),
   46);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   11,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   45);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   12,
   (SELECT player FROM players WHERE nick='Lejordet'),
   44);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   13,
   (SELECT player FROM players WHERE nick='Vampyro'),
   43);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   14,
   (SELECT player FROM players WHERE nick='Matsi'),
   42);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   15,
   (SELECT player FROM players WHERE nick='Havok'),
   41);
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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   16,
   (SELECT player FROM players WHERE nick='Smiph'),
   40);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Suspect' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Suspect' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   17,
   (SELECT player FROM players WHERE nick='Suspect'),
   39);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   18,
   (SELECT player FROM players WHERE nick='Purity'),
   38);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   19,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   37);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   3475);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
   'f',
   3809);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   6242);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Lejordet'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Lejordet'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   3562);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Lejordet'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
   'f',
   3735);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Lejordet'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   6943);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Draconia'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Secret Rendez-vous')),
   'f',
   4016);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Remember You')),
   'f',
   4438);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Jam Jam Reggae (AM Swing Mix)')),
   't',
   7479);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Secret Rendez-vous')),
   'f',
   3659);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Remember You')),
   'f',
   4367);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Trip Machine Climax')),
   't',
   7391);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   'f',
   4943);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
   'f',
   4098);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   6884);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   'f',
   6338);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
   'f',
   5589);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   6831);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('era (nostalmix)')),
   'f',
   5667);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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',
   4902);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Don\'t Try to Stop It')),
   't',
   5634);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   'f',
   7084);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
   'f',
   7014);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   't',
   7086);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Daniil'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('era (nostalmix)')),
   'f',
   7012);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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',
   7294);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Candy☆')),
   't',
   7130);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   4912);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   3279);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
   't',
   5969);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matsi'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matsi'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   6208);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matsi'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   4587);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matsi'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   6233);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   7551);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='kjmcw'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   4823);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='kjmcw'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7438);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Slusk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   6537);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Slusk'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   5252);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Slusk'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   6967);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8256);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   5906);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Tom'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   't',
   5858);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Suspect'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Suspect'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   4399);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Suspect'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
   'f',
   4954);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Suspect'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   't',
   6959);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Vampyro'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   6465);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Vampyro'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
   'f',
   4085);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Vampyro'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   't',
   6835);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Yeye'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Yeye'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   6766);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Yeye'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
   'f',
   5263);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Yeye'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   7234);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Telc'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Telc'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   6105);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Telc'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
   'f',
   5321);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Telc'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7297);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   8352);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
   'f',
   5583);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snute'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
   't',
   7049);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Slusk'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Slusk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
   'f',
   4556);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Slusk'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
   'f',
   5382);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Slusk'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   7576);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='kjmcw'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
   'f',
   4530);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='kjmcw'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
   'f',
   5726);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='kjmcw'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   7207);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('That was then, This is now')),
   'f',
   5056);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('www.blonde girl (MOMO Mix)')),
   'f',
   6073);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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',
   7524);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
   'f',
   5140);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
   'f',
   6443);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8092);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Daniil'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('That was then, This is now')),
   'f',
   5046);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('www.blonde girl (MOMO Mix)')),
   'f',
   5771);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Tsugaru')),
   't',
   7660);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
   'f',
   5291);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
   'f',
   5402);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Mulefisk'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   6378);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Telc'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
   'f',
   5779);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Telc'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
   'f',
   5254);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Telc'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   7042);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
   'f',
   6106);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
   'f',
   5747);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   7235);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Yeye'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
   'f',
   4980);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Yeye'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
   'f',
   4948);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Yeye'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   7733);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
   'f',
   5676);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
   'f',
   6436);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Tom'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   8060);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Draconia'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Look to the sky')),
   'f',
   4872);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('B4U (B4 Za Beat Mix)')),
   'f',
   5081);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Paranoia KCET (Clean Mix)')),
   't',
   7701);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
   'f',
   5538);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8223);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Telc'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
   'f',
   5433);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Telc'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (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 3' 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('Cotton-Eye Joe')),
   'f',
   5900);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Max 300')),
   't',
   6985);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
   'f',
   5677);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
   't',
   6430);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Cotton-Eye Joe')),
   'f',
   6240);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Max 300')),
   't',
   8004);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Cotton-Eye Joe')),
   'f',
   6002);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('So Deep (Perfect Sphere Mix)')),
   't',
   8019);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   5956);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7988);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Luv to Me (AMD Mix)')),
   'f',
   6259);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('PARANOiA Rebirth')),
   't',
   8065);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   6627);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8205);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 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 3' 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('Luv to Me (AMD Mix)')),
   'f',
   6716);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Max 300')),
   't',
   8791);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 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 3' 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('Luv to Me (AMD Mix)')),
   'f',
   7089);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Electro Tuned (the SubS Mix)')),
   't',
   8476);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' 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 3' 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('Spin the disc')),
   'f',
   6852);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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',
   7810);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   6975);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   8034);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 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 3' 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('Spin the disc')),
   'f',
   7570);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Exotic Ethnic')),
   't',
   8703);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 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 3' 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('Spin the disc')),
   'f',
   7596);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Hypnotic Crisis')),
   't',
   7906);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   7630);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   8152);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Dead End')),
   'f',
   8263);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Paranoia KCET (Clean Mix)')),
   't',
   8557);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Dead End')),
   'f',
   8407);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Paranoia KCET (Clean Mix)')),
   't',
   8396);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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 3' 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 3' 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('Let the Beat Hit \'em!')),
   'f',
   6379);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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',
   8421);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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 3' 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('Let the Beat Hit \'em!')),
   'f',
   5920);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' 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('Crash!')),
   't',
   8664);
commit;
