begin;
INSERT INTO tournaments 
  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
    (SELECT season FROM seasons WHERE seasonname='International' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
    'European Tournament in London',
    (SELECT country FROM countries WHERE countryname='Europe'),
    'Namco Station - London (United Kingdom)',
    '2004-01-25',
    (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
    (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lion' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1,
   (SELECT player FROM players WHERE nick='Lion'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2,
   (SELECT player FROM players WHERE nick='Snute'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stelisevil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stelisevil' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4,
   (SELECT player FROM players WHERE nick='Tom'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Usagi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Usagi' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5,
   (SELECT player FROM players WHERE nick='Usagi'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7,
   (SELECT player FROM players WHERE nick='DufF'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mintsauce 82' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mintsauce 82' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'S2K' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'S2K' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   9,
   (SELECT player FROM players WHERE nick='S2K'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ryosuke' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ryosuke' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   10,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Xai' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Xai' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   10,
   (SELECT player FROM players WHERE nick='Xai'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Krisminime' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Krisminime' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   10,
   (SELECT player FROM players WHERE nick='Krisminime'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   13,
   (SELECT player FROM players WHERE nick='RiChY'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   13,
   (SELECT player FROM players WHERE nick='Snofox'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Healingvizion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Healingvizion' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   13,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afrojunglist' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afrojunglist' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   16,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jester' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jester' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   16,
   (SELECT player FROM players WHERE nick='Jester'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matt' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matt' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   16,
   (SELECT player FROM players WHERE nick='Matt'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   19,
   (SELECT player FROM players WHERE nick='Havok'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   19,
   (SELECT player FROM players WHERE nick='Smiph'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   19,
   (SELECT player FROM players WHERE nick='Daniil'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afronova' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afronova' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   19,
   (SELECT player FROM players WHERE nick='Afronova'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Albo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Albo' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   19,
   (SELECT player FROM players WHERE nick='Albo'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tieguy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tieguy' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   19,
   (SELECT player FROM players WHERE nick='Tieguy'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   25,
   (SELECT player FROM players WHERE nick='Draconia'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   25,
   (SELECT player FROM players WHERE nick='kjmcw'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Myst' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Myst' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   25,
   (SELECT player FROM players WHERE nick='Myst'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Badbeat' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Badbeat' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   25,
   (SELECT player FROM players WHERE nick='Badbeat'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   25,
   (SELECT player FROM players WHERE nick='Ylini'),
   NULL);
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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   30,
   (SELECT player FROM players WHERE nick='Lejordet'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mecklar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mecklar' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   30,
   (SELECT player FROM players WHERE nick='Mecklar'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'sd-koala' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'sd-koala' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   30,
   (SELECT player FROM players WHERE nick='sd-koala'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'LLDJ' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'LLDJ' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   30,
   (SELECT player FROM players WHERE nick='LLDJ'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Simon x' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Simon x' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   30,
   (SELECT player FROM players WHERE nick='Simon x'),
   NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Fez' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Fez' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   30,
   (SELECT player FROM players WHERE nick='Fez'),
   NULL);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Mecklar'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Mecklar'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
   'f',
   5812);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Mecklar'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   'f',
   5090);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Mecklar'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   6696);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Albo'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Albo'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
   'f',
   6746);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Albo'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   'f',
   6572);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Albo'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   't',
   8159);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
   'f',
   7456);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   'f',
   6981);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   7781);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='RiChY'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
   'f',
   7624);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='RiChY'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   'f',
   8030);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='RiChY'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   8316);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
   'f',
   7941);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   'f',
   8351);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
   't',
   8137);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Fez'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Fez'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
   'f',
   5212);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Fez'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
   'f',
   4986);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Fez'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   't',
   6177);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
   'f',
   6265);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Daniil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
   'f',
   6507);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Daniil'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   8734);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Draconia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
   'f',
   5909);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Draconia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
   'f',
   5637);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Draconia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8204);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
   'f',
   8100);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
   'f',
   6577);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8739);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
   'f',
   8073);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
   'f',
   6299);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   8312);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Xai'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Xai'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
   'f',
   7338);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Xai'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
   'f',
   6497);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 2,
   (SELECT player FROM players WHERE nick='Xai'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   8031);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Simon x'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Simon x'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   4726);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Simon x'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   'f',
   3494);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Simon x'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   't',
   4588);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Ylini'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Ylini'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   6114);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Ylini'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   'f',
   3894);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Ylini'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   7132);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matt'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matt'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   7510);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matt'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   'f',
   6371);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Matt'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7497);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   8189);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   'f',
   6828);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   7239);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Krisminime'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Krisminime'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   8489);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Krisminime'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   'f',
   7241);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Krisminime'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   7538);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Tieguy'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Tieguy'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   'f',
   8411);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Tieguy'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   'f',
   6738);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 3,
   (SELECT player FROM players WHERE nick='Tieguy'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
   't',
   5747);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='LLDJ'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='LLDJ'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   0);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='LLDJ'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   5255);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='LLDJ'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   5255);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Havok'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   6053);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Havok'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   6657);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Havok'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   7880);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snofox'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   7073);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snofox'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   7267);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Snofox'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7625);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Myst'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Myst'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   7594);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Myst'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   7411);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Myst'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
   't',
   4424);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   7487);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   7909);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   7606);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Usagi'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Usagi'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
   'f',
   7909);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Usagi'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   7914);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 4,
   (SELECT player FROM players WHERE nick='Usagi'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   8612);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Lejordet'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Lejordet'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   0);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Lejordet'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   'f',
   6235);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Lejordet'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
   't',
   643);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Smiph'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Smiph'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   5727);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Smiph'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   'f',
   6766);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Smiph'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7277);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='S2K'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='S2K'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   8103);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='S2K'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   'f',
   8057);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='S2K'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   8291);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='kjmcw'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   0);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='kjmcw'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   'f',
   8134);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='kjmcw'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   7216);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   8162);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   'f',
   8652);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Tom'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   7719);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   'f',
   7822);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   'f',
   8940);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 5,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   't',
   7645);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Afronova'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Afronova'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
   'f',
   5608);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Afronova'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   5365);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Afronova'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   5365);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='sd-koala'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='sd-koala'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
   'f',
   5266);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='sd-koala'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   5265);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='sd-koala'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   't',
   5916);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Jester'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Jester'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
   'f',
   6507);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Jester'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   5595);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Jester'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   8224);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Badbeat'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Badbeat'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
   'f',
   5929);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Badbeat'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   5445);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Badbeat'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
   't',
   6976);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
   'f',
   6985);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6731);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   't',
   7604);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Lion'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
   'f',
   7894);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6831);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   1, 6,
   (SELECT player FROM players WHERE nick='Lion'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
   't',
   8557);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=2;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Matt'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Matt'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   'f',
   6484);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Matt'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   4944);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Matt'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   7575);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   'f',
   6712);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   6623);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   8812);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   'f',
   6876);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   5416);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8766);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='RiChY'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   'f',
   6349);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='RiChY'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   5736);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='RiChY'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   7901);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   'f',
   6682);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   6476);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Snute'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8828);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   'f',
   6754);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
   'f',
   6198);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 1,
   (SELECT player FROM players WHERE nick='Ryosuke'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   8095);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
);
UPDATE rounds SET randomsongs=2 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=2;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   6502);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8342);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Snofox'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
   't',
   7948);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Jester'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Jester'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   7193);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Jester'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   7827);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Jester'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   7707);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   7703);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8483);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8028);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   7735);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8569);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='DufF'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   7984);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Krisminime'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Krisminime'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   7174);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Krisminime'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8485);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Krisminime'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8080);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
   'f',
   7849);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   'f',
   8678);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 2,
   (SELECT player FROM players WHERE nick='Tom'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
   't',
   8096);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=2;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   8037);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6638);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Afrojunglist'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
   't',
   7524);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Xai'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Xai'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   8371);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Xai'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6604);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Xai'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8220);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   7976);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6666);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Healingvizion'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8253);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='S2K'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='S2K'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   8540);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='S2K'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6508);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='S2K'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   8577);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Lion'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   8816);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6835);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Lion'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   8602);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Usagi'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Usagi'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   'f',
   8691);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Usagi'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
   'f',
   6905);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   2, 3,
   (SELECT player FROM players WHERE nick='Usagi'),
   2,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   't',
   8277);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=3;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7287);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8604);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='S2K'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='S2K'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7368);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='S2K'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   7697);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7421);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Mintsauce 82'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8084);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7121);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
   't',
   8465);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7691);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
   't',
   7974);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7520);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8709);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7764);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   't',
   8357);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7844);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8777);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   9
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
   'f',
   7797);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8609);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=4;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6386);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='DufF'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   8371);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6170);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   9039);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6493);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Oliyzia'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8551);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6379);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8828);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6633);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   8622);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6793);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   8620);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
   'f',
   6703);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
   't',
   8741);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=5;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   'f',
   7610);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
   't',
   8346);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   'f',
   7341);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Usagi'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8541);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   'f',
   7869);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   't',
   8481);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   'f',
   7855);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
   't',
   8697);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   'f',
   7869);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8494);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=6;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
   'f',
   7805);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Tom'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   8389);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
   'f',
   8401);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   8403);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
   'f',
   8389);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
   't',
   8791);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
   'f',
   7996);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   8802);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=7;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
   'f',
   5813);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   8943);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
   'f',
   5785);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   8981);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
   'f',
   5949);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Stelisevil'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
   't',
   8178);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=8;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND 
  round=8;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
   'f',
   7490);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Lion'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   9425);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
   'f',
   7363);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1,
   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
   't',
   8068);
commit;
