begin;
INSERT INTO tournaments 
  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
    (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
    'Euromix2 serie 01',
    (SELECT country FROM countries WHERE countryname='Norway'),
    'Akers Mic',
    '2002-10-06',
    (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, '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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1,
   (SELECT player FROM players WHERE nick='Daniil'),
   22);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lars Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lars Christian' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   19);
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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3,
   (SELECT player FROM players WHERE nick='Havok'),
   17);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4,
   (SELECT player FROM players WHERE nick='Th0rny'),
   15);
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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5,
   (SELECT player FROM players WHERE nick='kjmcw'),
   13);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6,
   (SELECT player FROM players WHERE nick='Eilin'),
   11);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7,
   (SELECT player FROM players WHERE nick='Slusk'),
   9);
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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8,
   (SELECT player FROM players WHERE nick='Snute'),
   8);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oxehunden' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oxehunden' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9,
   (SELECT player FROM players WHERE nick='Oxehunden'),
   7);
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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   10,
   (SELECT player FROM players WHERE nick='Lejordet'),
   6);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=1;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Oxehunden'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Oxehunden'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   5718);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   5399);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   5843);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   't',
   4850);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Lejordet'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Lejordet'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   3952);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
   't',
   6082);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
   't',
   6534);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
   't',
   5590);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   9
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
   't',
   5676);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   10
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
   't',
   5029);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=2;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   5154);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
   't',
   5482);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
   't',
   5057);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
   't',
   6504);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
   't',
   5946);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Oxehunden'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Oxehunden'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
   't',
   4944);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
   't',
   4074);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   9
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
   't',
   3193);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=3;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   6893);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   't',
   6273);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
   't',
   5373);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   4789);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   4197);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   4718);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
   't',
   5432);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=4;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
   't',
   4920);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   't',
   6120);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
   't',
   4372);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   4993);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
   't',
   5929);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   5577);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   't',
   5528);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=5;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   0,
   (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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
   't',
   5295);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
   't',
   5113);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   4967);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
   't',
   5947);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
   't',
   5494);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=6;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   4618);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (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='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
   't',
   6345);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
   't',
   5194);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
   't',
   5447);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   't',
   5159);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=7;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
   't',
   5817);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
   't',
   0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
   't',
   5639);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
   't',
   5035);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8, 0);
UPDATE rounds SET randomsongs=0 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=8;
UPDATE rounds SET chosensongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=8;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Havok'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
   't',
   4334);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
   't',
   4793);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
   't',
   6059);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9,
   0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND 
  round=9;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9, 0,
   (SELECT player FROM players WHERE nick='Lars Christian'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   'f',
   6664);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   9, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   'f',
   7011);
commit;
