Sync from --pgweb.

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

diff --git a/sql/various/various-8.sql b/sql/various/various-8.sql
index 4bb76a9213de32730dc209afd7c4c1049db9b3b4..05cce8a8bfe5976ba3a1910b2ed5f7b8a3487125 100644 (file)
--- a/sql/various/various-8.sql
+++ b/sql/various/various-8.sql
@@ -1,7 +1,7 @@
 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' )),
+    (SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
     'Tønsberg Turnering',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Tønsberg - Sjøsenteret bowling',
@@ -11,108 +11,108 @@ INSERT INTO tournaments
 );
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1,
    (SELECT player FROM players WHERE nick='OJK'),
    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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2,
    (SELECT player FROM players WHERE nick='T|na'),
    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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3,
    (SELECT player FROM players WHERE nick='Pfxp'),
    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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4,
    (SELECT player FROM players WHERE nick='Jallaman'),
    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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5,
    (SELECT player FROM players WHERE nick='erikTman'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Benny' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6,
    (SELECT player FROM players WHERE nick='Benny'),
    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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7,
    (SELECT player FROM players WHERE nick='Nypd'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'msichana' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'msichana' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    8,
    (SELECT player FROM players WHERE nick='msichana'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nelly' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nelly' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    9,
    (SELECT player FROM players WHERE nick='Nelly'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tomi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tomi' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    10,
    (SELECT player FROM players WHERE nick='Tomi'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Annkakris' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    11,
    (SELECT player FROM players WHERE nick='Annkakris'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Henrik' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Henrik' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    12,
    (SELECT player FROM players WHERE nick='Henrik'),
    NULL);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Nelly'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Nelly'),
    0,
@@ -120,7 +120,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4480);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Nelly'),
    1,
@@ -128,7 +128,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4082);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Nelly'),
    2,
@@ -136,13 +136,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    4531);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Henrik'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Henrik'),
    0,
@@ -150,7 +150,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3432);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Henrik'),
    1,
@@ -158,7 +158,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3025);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Henrik'),
    2,
@@ -166,13 +166,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    3475);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Jallaman'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -180,7 +180,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5121);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -188,7 +188,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5287);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='Jallaman'),
    2,
@@ -196,13 +196,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5431);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    0,
@@ -210,7 +210,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3897);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    1,
@@ -218,7 +218,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3679);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    2,
@@ -226,34 +226,34 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    3987);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
 );
 UPDATE rounds SET randomsongs=3 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Pfxp'),
    0,
@@ -261,7 +261,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4988);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Pfxp'),
    1,
@@ -269,7 +269,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5000);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Pfxp'),
    2,
@@ -277,13 +277,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5449);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Annkakris'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Annkakris'),
    0,
@@ -291,7 +291,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    1434);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Annkakris'),
    1,
@@ -299,7 +299,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    2284);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='Annkakris'),
    2,
@@ -307,13 +307,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3831);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='erikTman'),
    0,
@@ -321,7 +321,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4517);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='erikTman'),
    1,
@@ -329,7 +329,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4216);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='erikTman'),
    2,
@@ -337,13 +337,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5081);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -351,7 +351,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4890);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -359,7 +359,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5204);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 2,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -367,32 +367,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5111);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Tomi'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Tomi'),
    0,
@@ -400,7 +400,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    2986);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Tomi'),
    1,
@@ -408,7 +408,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    2194);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Tomi'),
    2,
@@ -416,13 +416,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    4096);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -430,7 +430,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5846);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -438,7 +438,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5402);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
@@ -446,13 +446,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7146);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Nypd'),
    0,
@@ -460,7 +460,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4828);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Nypd'),
    1,
@@ -468,7 +468,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3743);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Nypd'),
    2,
@@ -476,13 +476,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    4814);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Benny'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Benny'),
    0,
@@ -490,7 +490,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4753);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Benny'),
    1,
@@ -498,7 +498,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3736);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    1, 3,
    (SELECT player FROM players WHERE nick='Benny'),
    2,
@@ -507,36 +507,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    4314);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=2;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Benny'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Benny'),
    0,
@@ -544,7 +544,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3915);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Benny'),
    1,
@@ -552,21 +552,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3800);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='Benny'),
    2,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86')),
+   (SELECT song FROM songs WHERE lower(title)=lower('CandyâÂ\98Â\86')),
    't',
    4177);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -574,7 +574,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6197);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -582,7 +582,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4031);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='T|na'),
    2,
@@ -590,13 +590,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7295);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    0,
@@ -604,7 +604,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3530);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    1,
@@ -612,7 +612,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3310);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='msichana'),
    2,
@@ -620,13 +620,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    3487);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -634,7 +634,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7707);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -642,7 +642,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5566);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 1,
    (SELECT player FROM players WHERE nick='OJK'),
    2,
@@ -650,32 +650,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7520);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=2;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Nypd'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Nypd'),
    0,
@@ -683,7 +683,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3784);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Nypd'),
    1,
@@ -691,7 +691,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3985);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Nypd'),
    2,
@@ -699,13 +699,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    4564);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -713,7 +713,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5230);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -721,7 +721,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4926);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Jallaman'),
    2,
@@ -729,13 +729,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6343);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='erikTman'),
    0,
@@ -743,7 +743,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4994);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='erikTman'),
    1,
@@ -751,7 +751,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4855);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='erikTman'),
    2,
@@ -759,13 +759,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5706);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Pfxp'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Pfxp'),
    0,
@@ -773,7 +773,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6112);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Pfxp'),
    1,
@@ -781,7 +781,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5491);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    2, 2,
    (SELECT player FROM players WHERE nick='Pfxp'),
    2,
@@ -790,31 +790,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    7514);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=3;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=3;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Benny'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Benny'),
    0,
@@ -822,7 +822,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4019);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Benny'),
    1,
@@ -830,13 +830,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5033);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='erikTman'),
    0,
@@ -844,7 +844,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4328);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='erikTman'),
    1,
@@ -852,13 +852,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5675);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -866,7 +866,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4245);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -874,13 +874,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5627);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -888,7 +888,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6864);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -896,13 +896,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6612);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    0,
@@ -910,7 +910,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7522);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    1,
@@ -918,13 +918,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6396);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -932,7 +932,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8025);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    3, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -941,31 +941,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    7269);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=4;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=4;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -973,7 +973,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4999);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -981,13 +981,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6648);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='erikTman'),
    0,
@@ -995,7 +995,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4896);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='erikTman'),
    1,
@@ -1003,13 +1003,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6707);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1017,7 +1017,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5649);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1025,13 +1025,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6626);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    0,
@@ -1039,7 +1039,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5833);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    1,
@@ -1047,13 +1047,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7494);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1061,7 +1061,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6316);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    4, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1070,31 +1070,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8081);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=5;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=5;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -1102,7 +1102,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5777);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -1110,13 +1110,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6185);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1124,7 +1124,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6312);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1132,13 +1132,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7196);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    0,
@@ -1146,7 +1146,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6483);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    1,
@@ -1154,13 +1154,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7855);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1168,7 +1168,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6946);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    5, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1177,31 +1177,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    7845);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=6;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=6;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1209,7 +1209,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8397);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,
@@ -1217,13 +1217,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8429);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    0,
@@ -1231,7 +1231,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8097);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    1,
@@ -1239,13 +1239,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    0);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1253,7 +1253,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8452);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    6, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1262,31 +1262,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    6982);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
 );
 UPDATE rounds SET randomsongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=7;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
   round=7;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    0,
@@ -1294,7 +1294,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6077);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0,
    (SELECT player FROM players WHERE nick='OJK'),
    1,
@@ -1302,13 +1302,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8364);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0,
    (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='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -1316,7 +1316,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6015);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
    7, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    1,