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 05',
    (SELECT country FROM countries WHERE countryname='Norway'),
    'Akers Mic',
    '2002-11-03',
    (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
    (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
);
INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 05' 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, '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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2,
   (SELECT player FROM players WHERE nick='Th0rny'),
   19);
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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3,
   (SELECT player FROM players WHERE nick='Snute'),
   17);
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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4,
   (SELECT player FROM players WHERE nick='kjmcw'),
   15);
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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5,
   (SELECT player FROM players WHERE nick='Slusk'),
   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 05' 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, 'wa-ho' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'wa-ho' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7,
   (SELECT player FROM players WHERE nick='wa-ho'),
   9);
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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   8,
   (SELECT player FROM players WHERE nick='Lejordet'),
   8);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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 05' 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 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 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 05' 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('Hypnotic Crisis')),
   't',
   6878);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 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 05' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
   't',
   6258);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 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='Euromix2 serie 05' 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('B4U')),
   't',
   6467);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 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 05' 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('Spin the disc')),
   't',
   6284);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Spin the disc')),
   't',
   6256);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 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 05' 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',
   5421);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='wa-ho'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='wa-ho'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
   't',
   5978);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   1, 0,
   (SELECT player FROM players WHERE nick='Lejordet'),
   8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Max 300')),
   't',
   5326);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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 05' 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 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 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 05' 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('Let the Beat Hit \'em!')),
   't',
   6270);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 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='Euromix2 serie 05' 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('Never Gonna Make (Factory Team Mix)')),
   't',
   5773);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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('Afronova')),
   't',
   5591);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 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 05' 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('Afronova')),
   't',
   6276);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Never Let You Down')),
   't',
   5937);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='wa-ho'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='wa-ho'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
   't',
   5337);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   2, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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',
   5982);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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 05' 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 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Slusk'),
   1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('B4U')),
   't',
   6276);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 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='Euromix2 serie 05' 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('Aaron\'s Party (Come Get It)')),
   't',
   5588);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Dead End')),
   't',
   6434);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Eilin'),
   4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Silent Hill')),
   't',
   5183);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 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 05' 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('Never Let You Down')),
   't',
   6249);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   3, 0,
   (SELECT player FROM players WHERE nick='Th0rny'),
   6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Dynamite Rave')),
   't',
   5613);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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 05' 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 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
   't',
   6701);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 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 05' 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('Dead End')),
   't',
   7192);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Paranoia KCET (Clean Mix)')),
   't',
   6606);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 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 05' 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('Dead End')),
   't',
   6370);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   4, 0,
   (SELECT player FROM players WHERE nick='kjmcw'),
   5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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',
   6596);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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 05' 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 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 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 05' 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('Healing Vision (Angelic Mix)')),
   't',
   4707);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Daniil'),
   2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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('Jam Jam Reggae (AM Swing Mix)')),
   't',
   6555);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   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='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   5, 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 05' 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('era (nostalmix)')),
   't',
   6329);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 0,
   (SELECT player FROM players WHERE nick='Snute'),
   0,
   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
   'f',
   6031);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 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 05' 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('Spin the disc')),
   'f',
   6900);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   6, 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 05' 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('Spin the disc')),
   'f',
   6240);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
  VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
   7, 0,
   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
);
UPDATE rounds SET randomsongs=1 WHERE 
  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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 05' 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('Electro Tuned (the SubS Mix)')),
   'f',
   7676);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
   (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' 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 05' 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('Electro Tuned (the SubS Mix)')),
   'f',
   7216);
commit;
