tag of sgunderson@bigfoot.com--2005-private/ccbs--mainline--0.1--patch-460

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

diff --git a/sql/various/various-4.sql b/sql/various/various-4.sql
index 9b6ed145813919c9bc3e62ffef87cef8eaad1d7c..a24434b3fb2910dd37ea04d12088725507dab82d 100644 (file)
--- a/sql/various/various-4.sql
+++ b/sql/various/various-4.sql
@@ -1,7 +1,7 @@
 begin;
 INSERT INTO tournaments 
   (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
-    (SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+    (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
     'Follo lag turnering',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Ski Metro Bowling',
@@ -11,123 +11,123 @@ INSERT INTO tournaments
 );
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1,
    (SELECT player FROM players WHERE nick='Havok'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1,
    (SELECT player FROM players WHERE nick='RiChY'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1,
    (SELECT player FROM players WHERE nick='Stream'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2,
    (SELECT player FROM players WHERE nick='Snofox'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2,
    (SELECT player FROM players WHERE nick='ViD'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2,
    (SELECT player FROM players WHERE nick='Jannemor'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3,
    (SELECT player FROM players WHERE nick='Jallaman'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3,
    (SELECT player FROM players WHERE nick='Indy'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4,
    (SELECT player FROM players WHERE nick='Snute'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4,
    (SELECT player FROM players WHERE nick='Slusk'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4,
    (SELECT player FROM players WHERE nick='Matsi'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5,
    (SELECT player FROM players WHERE nick='Smiph'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Iris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Iris' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5,
    (SELECT player FROM players WHERE nick='Iris'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5,
    (SELECT player FROM players WHERE nick='Ylini'),
    NULL);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=1;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    0,
@@ -135,7 +135,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4653);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    1,
@@ -143,13 +143,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5301);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    0,
@@ -157,7 +157,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3728);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    1,
@@ -166,41 +166,41 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    3723);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
-   (SELECT song FROM songs WHERE lower(title)=lower('CandyâÂ\98Â\86'))
+   (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=2;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
-   (SELECT song FROM songs WHERE lower(title)=lower('CandyâÂ\98Â\86')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86')),
    'f',
    5687);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -208,21 +208,21 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7943);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    0,
-   (SELECT song FROM songs WHERE lower(title)=lower('CandyâÂ\98Â\86')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86')),
    'f',
    5385);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    1,
@@ -231,33 +231,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    7583);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=3;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Jannemor'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Jannemor'),
    0,
@@ -265,7 +265,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4632);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Jannemor'),
    1,
@@ -273,13 +273,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4470);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -287,7 +287,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5638);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -296,33 +296,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    5961);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=4;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Slusk'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Slusk'),
    0,
@@ -330,7 +330,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4632);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Slusk'),
    1,
@@ -338,13 +338,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7219);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -352,7 +352,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4862);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -361,33 +361,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    6836);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=5;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -395,7 +395,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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    1,
@@ -403,13 +403,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5763);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    0,
@@ -417,7 +417,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4733);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    1,
@@ -426,33 +426,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    5903);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=6;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    0,
@@ -460,7 +460,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5949);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0,
    (SELECT player FROM players WHERE nick='Jallaman'),
    1,
@@ -468,13 +468,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6361);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0,
    (SELECT player FROM players WHERE nick='ViD'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0,
    (SELECT player FROM players WHERE nick='ViD'),
    0,
@@ -482,7 +482,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5865);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6, 0,
    (SELECT player FROM players WHERE nick='ViD'),
    1,
@@ -491,33 +491,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    7033);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=7;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -525,7 +525,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4136);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -533,13 +533,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6417);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    0,
@@ -547,7 +547,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3949);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    1,
@@ -556,33 +556,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    6290);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=8;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT player FROM players WHERE nick='ViD'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT player FROM players WHERE nick='ViD'),
    0,
@@ -590,7 +590,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6247);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT player FROM players WHERE nick='ViD'),
    1,
@@ -598,13 +598,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8112);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -612,7 +612,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7071);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -621,33 +621,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8421);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=9;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    0,
@@ -655,7 +655,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4785);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    1,
@@ -663,13 +663,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6046);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -677,7 +677,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6103);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,
@@ -686,33 +686,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8380);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=10;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -720,7 +720,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7395);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    1,
@@ -728,13 +728,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    8533);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
@@ -742,7 +742,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6785);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
@@ -751,33 +751,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8245);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=11;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    0,
@@ -785,7 +785,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5661);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
@@ -793,13 +793,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4896);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    0,
@@ -807,7 +807,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5612);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11, 0,
    (SELECT player FROM players WHERE nick='Spinnvill'),
    1,
@@ -816,33 +816,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    7466);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=12;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    0,
@@ -850,7 +850,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    3737);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    1,
@@ -858,13 +858,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4697);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT player FROM players WHERE nick='Jannemor'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT player FROM players WHERE nick='Jannemor'),
    0,
@@ -872,7 +872,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4397);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12, 0,
    (SELECT player FROM players WHERE nick='Jannemor'),
    1,
@@ -881,33 +881,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    4913);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=13;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    0,
@@ -915,7 +915,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6719);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT player FROM players WHERE nick='Snofox'),
    1,
@@ -923,13 +923,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7780);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT player FROM players WHERE nick='Slusk'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT player FROM players WHERE nick='Slusk'),
    0,
@@ -937,7 +937,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    1357);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13, 0,
    (SELECT player FROM players WHERE nick='Slusk'),
    1,
@@ -946,33 +946,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    6766);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
 );
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=14;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    0,
@@ -980,7 +980,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4824);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    1,
@@ -988,13 +988,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6750);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    0,
@@ -1002,7 +1002,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    4924);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    1,
@@ -1011,33 +1011,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    5773);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15,
    0, 0);
 INSERT INTO groups (tournament, round, parallel) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0);
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=15;
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    0,
@@ -1045,7 +1045,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    5900);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (SELECT player FROM players WHERE nick='Stream'),
    1,
@@ -1053,13 +1053,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    7930);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -1067,7 +1067,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    'f',
    6917);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    1,