Add various tournaments from DDR Europe. Not all are insertable into the current...

[ccbs] / sql / various / various-1.sql

diff --git a/sql/various/various-1.sql b/sql/various/various-1.sql
new file mode 100644 (file)
index 0000000..ef48e86
--- /dev/null
+++ b/sql/various/various-1.sql
@@ -0,0 +1,5278 @@
+begin;
+INSERT INTO tournaments 
+  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
+    (SELECT season FROM seasons WHERE seasonname='European Cup' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+    'European Cup 1',
+    (SELECT country FROM countries WHERE countryname='Europe'),
+    'The Gathering (Norway)',
+    '2004-04-10',
+    (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, 'Dex' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dex' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1,
+   (SELECT player FROM players WHERE nick='Dex'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3,
+   (SELECT player FROM players WHERE nick='Snute'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stelisevil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stelisevil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ryosuke' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ryosuke' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lion' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6,
+   (SELECT player FROM players WHERE nick='Lion'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T_Bone_X_Zeo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T_Bone_X_Zeo' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8,
+   (SELECT player FROM players WHERE nick='Tom'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9,
+   (SELECT player FROM players WHERE nick='OJK'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smooth' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smooth' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   11,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tiger Yoshiki' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tiger Yoshiki' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   12,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'William' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'William' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   13,
+   (SELECT player FROM players WHERE nick='William'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Elias' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Elias' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   14,
+   (SELECT player FROM players WHERE nick='Elias'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   15,
+   (SELECT player FROM players WHERE nick='T|na'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   16,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   17,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   18,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   19,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   20,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kogepan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kogepan' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   21,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   22,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Milk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Milk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   23,
+   (SELECT player FROM players WHERE nick='Milk'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   24,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sesse' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   25,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyberg' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyberg' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   26,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Redixius' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Redixius' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   27,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Healingvizion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Healingvizion' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   28,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'stuf' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'stuf' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   29,
+   (SELECT player FROM players WHERE nick='stuf'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   30,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   31,
+   (SELECT player FROM players WHERE nick='Purity'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   32,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   33,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   34,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   35,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'LF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'LF' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   36,
+   (SELECT player FROM players WHERE nick='LF'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   37,
+   (SELECT player FROM players WHERE nick='Indy'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lurisoft' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lurisoft' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   38,
+   (SELECT player FROM players WHERE nick='Lurisoft'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'sd-koala' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'sd-koala' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   39,
+   (SELECT player FROM players WHERE nick='sd-koala'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yuna-chan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yuna-chan' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   40,
+   (SELECT player FROM players WHERE nick='Yuna-chan'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   41,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   42,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   43,
+   (SELECT player FROM players WHERE nick='Havok'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   44,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Steel' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Steel' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   45,
+   (SELECT player FROM players WHERE nick='Steel'),
+   NULL);
+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='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   46,
+   (SELECT player FROM players WHERE nick='wa-ho'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mync' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   47,
+   (SELECT player FROM players WHERE nick='Mync'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lu' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lu' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   48,
+   (SELECT player FROM players WHERE nick='Lu'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   49,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Puck' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Puck' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   50,
+   (SELECT player FROM players WHERE nick='Puck'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   51,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dashiva' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dashiva' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   52,
+   (SELECT player FROM players WHERE nick='Dashiva'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tazze' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tazze' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   53,
+   (SELECT player FROM players WHERE nick='Tazze'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Psychofreud' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Psychofreud' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   54,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   55,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kissmet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kissmet' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   56,
+   (SELECT player FROM players WHERE nick='Kissmet'),
+   NULL);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6637);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6633);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6548);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6503);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6463);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6460);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6420);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='William'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='William'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6297);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6207);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   10
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6181);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   11
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6154);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   12
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6140);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Elias'),
+   13
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Elias'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6098);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   14
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6069);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   15
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6053);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   16
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5979);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   17
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5939);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   18
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5927);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   19
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5924);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   20
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5818);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   21
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5809);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   22
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5759);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='stuf'),
+   23
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='stuf'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5702);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   24
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5697);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Milk'),
+   25
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Milk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5606);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   26
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5573);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   27
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5546);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   28
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5426);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   29
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5363);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   30
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5343);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   31
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5278);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   32
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5223);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   33
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5201);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Yuna-chan'),
+   34
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Yuna-chan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5134);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   35
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5098);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Dashiva'),
+   36
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Dashiva'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4986);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='sd-koala'),
+   37
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='sd-koala'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4976);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   38
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4949);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   39
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4922);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   40
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4844);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   41
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4838);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Indy'),
+   42
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Indy'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4801);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='LF'),
+   43
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='LF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4699);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Lu'),
+   44
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Lu'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4623);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Lurisoft'),
+   45
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Lurisoft'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4612);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   46
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4427);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Puck'),
+   47
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Puck'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4302);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='wa-ho'),
+   48
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='wa-ho'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4156);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Steel'),
+   49
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Steel'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4111);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   50
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   3806);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   51
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   3502);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tazze'),
+   52
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tazze'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   3318);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   53
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   3027);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Kissmet'),
+   54
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Kissmet'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   2733);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   55
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Mync'),
+   56
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Mync'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   0);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (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='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   6404);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Havok'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5242);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Havok'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7520);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   6271);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5180);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7953);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   6649);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5228);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8208);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   7013);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   5593);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7711);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+   'f',
+   7741);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
+   'f',
+   6510);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   't',
+   6892);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   'f',
+   5763);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   5161);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Indy'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6287);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   'f',
+   4646);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   4193);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7560);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   'f',
+   6153);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   6400);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+   't',
+   6800);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   'f',
+   6470);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   7689);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   't',
+   8391);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+   'f',
+   6702);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8225);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   't',
+   6703);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='LF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='LF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5123);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='LF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5913);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='LF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7458);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5171);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   5463);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Haanz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7289);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='stuf'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='stuf'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   5395);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='stuf'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   6092);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='stuf'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   7555);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6565);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   6270);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8169);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   'f',
+   6217);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
+   'f',
+   6737);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 3,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   't',
+   6703);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Lu'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Lu'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   5840);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Lu'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   5341);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Lu'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   't',
+   5296);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='sd-koala'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='sd-koala'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   6185);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='sd-koala'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   5742);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='sd-koala'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   't',
+   5688);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (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='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7038);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   6516);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   't',
+   6766);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   7432);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   6302);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7553);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Dex'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+   'f',
+   8376);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
+   'f',
+   6924);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 4,
+   (SELECT player FROM players WHERE nick='Dex'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7969);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Mync'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Mync'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6115);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Mync'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   4062);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Mync'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6109);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Lurisoft'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Lurisoft'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   5113);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Lurisoft'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   5695);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Lurisoft'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   6262);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Dashiva'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Dashiva'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   4914);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Dashiva'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Dashiva'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   't',
+   6786);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Milk'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Milk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   6203);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Milk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8233);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Milk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8513);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7390);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8627);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8344);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   'f',
+   7703);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   'f',
+   8189);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 5,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7745);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   4223);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   4005);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   4228);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   4396);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   3866);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   6818);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   6098);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7476);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7301);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   7528);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   7985);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   7789);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   7320);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8425);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Lion'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Lion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   'f',
+   6577);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Lion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   'f',
+   8776);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 6,
+   (SELECT player FROM players WHERE nick='Lion'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   7941);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kissmet'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kissmet'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   290);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kissmet'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   2521);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kissmet'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   't',
+   1720);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Puck'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Puck'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   3904);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Puck'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   4608);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Puck'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   5652);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Yuna-chan'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Yuna-chan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   5215);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Yuna-chan'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   5877);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Yuna-chan'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   't',
+   4610);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   5706);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   5880);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6072);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   6369);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6153);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7696);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Snute'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
+   'f',
+   6671);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6617);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 7,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   't',
+   7550);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   3987);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Maxion'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='wa-ho'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='wa-ho'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   5244);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='wa-ho'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   4089);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='wa-ho'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   6979);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Purity'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   6822);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5675);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7965);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   6841);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   5735);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8022);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Elias'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Elias'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   8036);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Elias'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6226);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='Elias'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8124);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='William'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='William'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+   'f',
+   8374);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='William'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
+   'f',
+   6380);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 8,
+   (SELECT player FROM players WHERE nick='William'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7028);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Tazze'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Tazze'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5350);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Tazze'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   5240);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Tazze'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   5093);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Steel'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Steel'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5529);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Steel'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   5636);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Steel'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7181);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6409);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   6148);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7506);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5720);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   5782);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7512);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   7011);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   7854);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8683);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   7127);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   'f',
+   7291);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 9,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7640);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   'f',
+   4407);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Dabi'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   5812);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   'f',
+   3850);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Chimera'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   't',
+   3806);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   'f',
+   6187);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   5258);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7801);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   'f',
+   5737);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   4784);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7960);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='DufF'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   'f',
+   6422);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   8582);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   't',
+   8594);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+   'f',
+   6137);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   'f',
+   7197);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   2, 10,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8079);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5453);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5038);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Redixius'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7908);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Milk'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Milk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5682);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Milk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5695);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Milk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7938);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5689);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5712);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8490);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5317);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5574);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8570);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5825);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5718);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8512);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Lion'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Lion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   'f',
+   5900);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Lion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5911);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 1,
+   (SELECT player FROM players WHERE nick='Lion'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8848);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7408);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   5135);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Cyberg'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8450);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7003);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   6621);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Sesse'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7606);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7528);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   7580);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8385);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='William'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='William'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7464);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='William'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   7660);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='William'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8563);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7932);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   8686);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   't',
+   7920);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   'f',
+   7324);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   'f',
+   8140);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 2,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8397);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (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='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   7003);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6695);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8450);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   6190);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6731);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   5944);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   7015);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6604);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Kogepan'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8142);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   8531);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   7544);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8591);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Elias'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Elias'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   8108);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Elias'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   7282);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='Elias'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   7375);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   8383);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   6371);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 3,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8520);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6185);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5397);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7947);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6208);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5104);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   't',
+   8455);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6467);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5128);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Healingvizion'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   't',
+   7360);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6610);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5595);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8404);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6677);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5499);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='Tom'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7682);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   6503);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
+   'f',
+   5673);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 4,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8398);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='stuf'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='stuf'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7236);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='stuf'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   5091);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='stuf'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   6524);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7439);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   4886);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7786);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7678);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   5830);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8108);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   7744);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   6626);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8186);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Dex'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8569);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7485);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='Dex'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8541);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   'f',
+   8566);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   6463);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   3, 5,
+   (SELECT player FROM players WHERE nick='OJK'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8268);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=4;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=4;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8187);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8650);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Elias'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Elias'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8237);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Elias'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7611);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8342);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8194);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   7128);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8238);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='William'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='William'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8008);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='William'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8409);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8319);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8385);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8776);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8434);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8680);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8635);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8641);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8380);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   10
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8742);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8432);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   11
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8557);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8311);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   12
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8865);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8441);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   13
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8661);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8204);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   14
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8768);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   't',
+   8659);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   15
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   'f',
+   8839);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8929);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=5;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=5;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6211);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8004);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6333);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Smooth'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8118);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6154);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8782);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6681);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8744);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6214);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8630);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6550);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8731);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6618);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8775);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6519);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8570);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6566);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8874);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   10
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6423);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8808);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   11
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6666);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+   't',
+   8466);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   12
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   6666);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   't',
+   8858);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=6;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=6;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   7732);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8316);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8054);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8118);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8205);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8540);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 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='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8084);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   8870);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   7938);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8654);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   7429);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='OJK'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8294);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8112);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8696);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   8159);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   8721);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
+   'f',
+   7996);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+   't',
+   8777);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=7;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=7;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5827);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8764);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5733);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Lion'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8749);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5622);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Ryosuke'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   8870);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5832);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   8836);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5662);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8935);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
+   'f',
+   5737);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   9351);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=8;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=8;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7068);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Stelisevil'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8691);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7410);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+   't',
+   8454);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7304);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8880);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 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='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   'f',
+   7429);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   8, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8684);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=9;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=9;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6884);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   8450);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6728);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   8470);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   'f',
+   6866);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   9, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   8735);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=10;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND 
+  round=10;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   8409);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   't',
+   8517);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+   'f',
+   8776);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
+   10, 0,
+   (SELECT player FROM players WHERE nick='Dex'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   8740);
+commit;