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 8',
    (SELECT country FROM countries WHERE countryname='Norway'),
    'Oslo Bowling',
    '2003-12-14',
    (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, '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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1,
   (SELECT player FROM players WHERE nick='Snute'),
   100);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2,
   (SELECT player FROM players WHERE nick='Tom'),
   90);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3,
   (SELECT player FROM players WHERE nick='DufF'),
   81);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4,
   (SELECT player FROM players WHERE nick='Daniil'),
   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 8' 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, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6,
   (SELECT player FROM players WHERE nick='RiChY'),
   60);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7,
   (SELECT player FROM players WHERE nick='T|na'),
   55);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8,
   (SELECT player FROM players WHERE nick='Snofox'),
   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 8' 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, '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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   10,
   (SELECT player FROM players WHERE nick='Smiph'),
   46);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   11,
   (SELECT player FROM players WHERE nick='Pfxp'),
   45);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   12,
   (SELECT player FROM players WHERE nick='Stream'),
   44);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   13,
   (SELECT player FROM players WHERE nick='ViD'),
   43);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   14,
   (SELECT player FROM players WHERE nick='Jallaman'),
   42);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   15,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   41);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   16,
   (SELECT player FROM players WHERE nick='Slusk'),
   40);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   17,
   (SELECT player FROM players WHERE nick='kjmcw'),
   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 8' 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, '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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   19,
   (SELECT player FROM players WHERE nick='Havok'),
   37);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Benny' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   20,
   (SELECT player FROM players WHERE nick='Benny'),
   36);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nevrosert' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nevrosert' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   21,
   (SELECT player FROM players WHERE nick='Nevrosert'),
   35);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   22,
   (SELECT player FROM players WHERE nick='Haggar'),
   34);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   23,
   (SELECT player FROM players WHERE nick='Haz'),
   33);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   24,
   (SELECT player FROM players WHERE nick='Lejordet'),
   32);
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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   25,
   (SELECT player FROM players WHERE nick='Matsi'),
   31);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   26,
   (SELECT player FROM players WHERE nick='Golddragon'),
   30);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   27,
   (SELECT player FROM players WHERE nick='Ylini'),
   29);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   28,
   (SELECT player FROM players WHERE nick='Tha Dragon'),
   28);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   29,
   (SELECT player FROM players WHERE nick='Jannemor'),
   27);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Liquid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Liquid' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   30,
   (SELECT player FROM players WHERE nick='Liquid'),
   26);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Ylini'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Ylini'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   5133);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Ylini'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
   'f',
   5018);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Ylini'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   6172);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Nevrosert'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Nevrosert'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   6564);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Nevrosert'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
   'f',
   4984);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Nevrosert'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   7045);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   6823);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
   'f',
   4938);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7449);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Slusk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   7539);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Slusk'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
   'f',
   4757);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Slusk'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   7676);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Tom'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   'f',
   8645);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
   'f',
   5274);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Tom'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
   't',
   6683);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (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 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Benny'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Benny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   5313);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Benny'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
   'f',
   3801);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Benny'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   7402);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Stream'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Stream'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   6300);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Stream'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
   'f',
   4131);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Stream'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8035);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Trip Machine (Luv Mix)')),
   'f',
   5892);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Remember You')),
   'f',
   3965);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   7363);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Matsi'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Matsi'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   5509);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Matsi'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
   'f',
   4014);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Matsi'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   6863);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   8200);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
   'f',
   4614);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Snute'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   't',
   6199);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jallaman'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jallaman'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
   'f',
   5768);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jallaman'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   6378);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jallaman'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   7218);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jannemor'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jannemor'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
   'f',
   5315);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jannemor'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   4772);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Jannemor'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   5424);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Lejordet'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Lejordet'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
   'f',
   4805);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Lejordet'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   5456);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Lejordet'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   6172);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Smiph'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Smiph'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
   'f',
   5742);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Smiph'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   6875);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Smiph'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   7491);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='DufF'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
   'f',
   6338);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   8497);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 3,
   (SELECT player FROM players WHERE nick='DufF'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   7400);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Golddragon'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Golddragon'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   4024);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Golddragon'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
   'f',
   5693);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Golddragon'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   6775);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Haz'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Haz'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   5708);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Haz'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
   'f',
   5153);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Haz'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   6186);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snofox'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snofox'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   4845);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snofox'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
   'f',
   6248);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snofox'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   7777);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Daniil'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   5651);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Daniil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
   'f',
   6353);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Daniil'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   't',
   7290);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   'f',
   5955);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
   'f',
   6524);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   't',
   8044);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT song FROM songs WHERE lower(title)=lower('Destiny'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Haggar'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Haggar'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   4708);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Haggar'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
   'f',
   5066);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Haggar'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   6644);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Tha Dragon'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Tha Dragon'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   4209);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Tha Dragon'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
   'f',
   3987);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Tha Dragon'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
   't',
   6037);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='ViD'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='ViD'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   5376);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='ViD'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
   'f',
   5345);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='ViD'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   7349);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='RiChY'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='RiChY'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   5726);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='RiChY'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
   'f',
   5866);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='RiChY'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   8449);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Draconia'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Draconia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   4424);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Draconia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
   'f',
   4913);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Draconia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   7984);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Liquid'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Liquid'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   4615);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Liquid'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
   'f',
   4643);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Liquid'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   't',
   0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Pfxp'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Pfxp'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   7532);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Pfxp'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
   'f',
   5926);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Pfxp'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8007);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='T|na'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='T|na'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   7793);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='T|na'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
   'f',
   5615);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='T|na'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   7982);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Havok'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   7226);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Havok'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
   'f',
   5623);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Havok'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   7515);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='kjmcw'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   7392);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='kjmcw'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
   'f',
   5999);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   1, 6,
   (SELECT player FROM players WHERE nick='kjmcw'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7689);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Jallaman'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Jallaman'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
   'f',
   6372);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Jallaman'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   6510);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Jallaman'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7456);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Draconia'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Draconia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
   'f',
   6151);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Draconia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   7121);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Draconia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8314);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
   'f',
   6135);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   6885);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Smiph'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8018);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (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 8' 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('Don\'t Try to Stop It')),
   'f',
   5773);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Tsugaru')),
   'f',
   6727);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Paranoia KCET (Clean Mix)')),
   't',
   7611);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
   'f',
   6901);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8160);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   7530);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
   'f',
   6886);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8374);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Tom'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8187);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   'f',
   4916);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   5483);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Purity'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   't',
   5309);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   'f',
   5841);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6057);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8248);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='ViD'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='ViD'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   'f',
   6063);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='ViD'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   5497);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='ViD'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8076);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='T|na'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='T|na'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   'f',
   6236);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='T|na'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6095);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='T|na'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8282);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Pfxp'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Pfxp'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   'f',
   5970);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Pfxp'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   5973);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Pfxp'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   7999);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   'f',
   6060);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6315);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   8365);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   'f',
   4959);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
   'f',
   5401);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Spinnvill'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7325);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   'f',
   5160);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='kjmcw'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
   'f',
   5142);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='kjmcw'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7240);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   'f',
   5345);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Daniil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
   'f',
   6250);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Daniil'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8127);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Stream'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Stream'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   'f',
   5378);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Stream'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
   'f',
   6238);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Stream'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7046);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Snute'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   'f',
   6320);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
   'f',
   6557);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Snute'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
   't',
   8245);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='RiChY'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='RiChY'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
   'f',
   5996);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='RiChY'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
   'f',
   6249);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   2, 3,
   (SELECT player FROM players WHERE nick='RiChY'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   't',
   8132);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 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 8' 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 8' 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 8' 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 8' 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('Spin the disc')),
   'f',
   6611);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Crash!')),
   't',
   8489);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snofox'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snofox'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   6694);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snofox'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7660);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Draconia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   6644);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Draconia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   7358);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='RiChY'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='RiChY'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   7355);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='RiChY'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8257);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Spin the disc')),
   'f',
   7783);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('PARANOiA Rebirth')),
   't',
   8205);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='T|na'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='T|na'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   6890);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='T|na'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7615);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Spin the disc')),
   'f',
   7761);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   8389);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Spin the disc')),
   'f',
   7586);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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',
   8426);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   9
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Spin the disc')),
   'f',
   7173);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Dead End')),
   't',
   7650);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='T|na'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='T|na'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
   'f',
   5323);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='T|na'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7667);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('That was then, This is now')),
   'f',
   5367);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   8484);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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('That was then, This is now')),
   'f',
   5262);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   8196);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='RiChY'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='RiChY'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
   'f',
   4357);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='RiChY'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   8866);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('That was then, This is now')),
   'f',
   5486);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Paranoia KCET (Clean Mix)')),
   't',
   8456);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('That was then, This is now')),
   'f',
   5658);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Healing Vision (Angelic Mix)')),
   't',
   8290);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('That was then, This is now')),
   'f',
   5611);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('So Deep (Perfect Sphere Mix)')),
   't',
   8380);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 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 8' 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('Keep On Movin\'')),
   'f',
   5573);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Paranoia KCET (Clean Mix)')),
   't',
   8378);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Keep On Movin\'')),
   'f',
   6469);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('So Deep (Perfect Sphere Mix)')),
   't',
   8359);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
   'f',
   5279);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8292);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (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 8' 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('Keep On Movin\'')),
   'f',
   5682);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Afronova Primeval')),
   't',
   8249);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 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 8' 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('Keep On Movin\'')),
   'f',
   5663);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8640);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
   'f',
   6084);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
   't',
   8677);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 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 8' 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('Test My Best')),
   'f',
   6497);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Exotic Ethnic')),
   't',
   7863);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Test My Best')),
   'f',
   6489);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8669);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   6, 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 8' 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('Test My Best')),
   'f',
   6644);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Tsugaru')),
   't',
   8356);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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 8' 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7, 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
   'f',
   4428);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8619);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Remember You')),
   'f',
   4685);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Exotic Ethnic')),
   't',
   8365);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Remember You')),
   'f',
   4704);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' 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('Paranoia KCET (Clean Mix)')),
   't',
   8770);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 0,
   (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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND 
  round=8;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   'f',
   7700);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   8567);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 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 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   'f',
   7513);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   9264);
commit;
