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

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

diff --git a/sql/various/various-5.sql b/sql/various/various-5.sql
new file mode 100644 (file)
index 0000000..c391345
--- /dev/null
+++ b/sql/various/various-5.sql
@@ -0,0 +1,1744 @@
+begin;
+INSERT INTO tournaments 
+  (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
+    (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+    'Fredrikstad Turnering',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Fredrikstad Mestern Bowling',
+    '2003-09-21',
+    (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, 'FantNo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'FantNo' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2,
+   (SELECT player FROM players WHERE nick='Purity'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Freaky Mama=)' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Freaky Mama=)' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4,
+   (SELECT player FROM players WHERE nick='ViD'),
+   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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Naughty' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Naughty' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7,
+   (SELECT player FROM players WHERE nick='T|na'),
+   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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   8,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   9,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sniff' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sniff' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   10,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   11,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'erikTman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'erikTman' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   12,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   13,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   14,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Svimse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Svimse' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   15,
+   (SELECT player FROM players WHERE nick='Svimse'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   16,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nypd' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nypd' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   17,
+   (SELECT player FROM players WHERE nick='Nypd'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   18,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Joachim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Joachim' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   19,
+   (SELECT player FROM players WHERE nick='Joachim'),
+   NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   20,
+   (SELECT player FROM players WHERE nick='Haz'),
+   NULL);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5840);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+   'f',
+   6114);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   7496);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5569);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+   'f',
+   5317);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   6867);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nypd'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nypd'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   3862);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nypd'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+   'f',
+   4500);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Nypd'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   't',
+   4745);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   6192);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+   'f',
+   5938);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7329);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   'f',
+   5287);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+   'f',
+   5043);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 1,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7159);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2);
+UPDATE rounds SET randomsongs=0 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('')),
+   'f',
+   0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   't',
+   1370);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Cyanid'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   't',
+   2891);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('')),
+   'f',
+   4323);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   't',
+   3573);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   5054);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('')),
+   'f',
+   6817);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   't',
+   3553);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6517);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('')),
+   'f',
+   6293);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+   't',
+   5696);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+   't',
+   6693);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('')),
+   'f',
+   3730);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+   't',
+   3147);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 2,
+   (SELECT player FROM players WHERE nick='Jannemor'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   4358);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   3515);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   3147);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   5470);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   3938);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   3298);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   't',
+   5113);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   5460);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   6276);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
+   't',
+   6071);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   4872);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   3300);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6048);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Haz'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Haz'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+   'f',
+   1412);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Haz'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   'f',
+   1345);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 3,
+   (SELECT player FROM players WHERE nick='Haz'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   4819);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   5278);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6401);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Svimse'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Svimse'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   4300);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Svimse'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   4804);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Svimse'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   4559);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   5739);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+   't',
+   3383);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   5505);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   5504);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   6380);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Joachim'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Joachim'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+   'f',
+   1103);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Joachim'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+   'f',
+   2364);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   1, 4,
+   (SELECT player FROM players WHERE nick='Joachim'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   1355);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5189);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5678);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (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',
+   7552);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   4090);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   4791);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='T|na'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7502);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   4296);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5179);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6261);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5090);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5631);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   't',
+   7632);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   5097);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5581);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7483);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+   'f',
+   4844);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+   'f',
+   5202);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 1,
+   (SELECT player FROM players WHERE nick='DiJam'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
+);
+UPDATE rounds SET randomsongs=2 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=2;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   6989);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5870);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   7042);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   4763);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   4734);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Sniff'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+   't',
+   5407);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   4156);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   4075);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='erikTman'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+   't',
+   0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   6148);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5309);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7283);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   6267);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5196);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7020);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   'f',
+   5759);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+   'f',
+   5460);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   2, 2,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   2,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7096);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=3;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6164);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6893);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6629);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7007);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6228);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   't',
+   6771);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6662);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   6792);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6056);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='Naughty'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   6743);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+   'f',
+   6831);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   3, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   7555);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=4;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=4;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   4974);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   't',
+   6786);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   4583);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   5798);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   4441);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   't',
+   6444);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   4156);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   't',
+   7098);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+   'f',
+   5499);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   4, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   6885);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=5;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=5;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6478);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   't',
+   5992);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   6733);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='ViD'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+   't',
+   5490);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7513);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+   't',
+   6333);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   'f',
+   7651);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   5, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+   't',
+   6983);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=6;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=6;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   5887);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+   't',
+   6461);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   5978);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   't',
+   7154);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+   'f',
+   6566);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   6, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   't',
+   7754);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
+  VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7,
+   0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=7;
+UPDATE rounds SET chosensongs=1 WHERE 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  round=7;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6099);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+   't',
+   5967);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+   'f',
+   6480);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   7, 0,
+   (SELECT player FROM players WHERE nick='FantNo'),
+   1,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   7929);
+commit;