Sync with --pgweb.

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

diff --git a/sql/various/various-3.sql b/sql/various/various-3.sql
index 3abb22579a8f77270bac0d5b5d8a1dec883d70ab..4bad2ef9b054fe5e60da03c363b1eee584bdba8d 100644 (file)
--- a/sql/various/various-3.sql
+++ b/sql/various/various-3.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' )),
     'Aftenposten Cup',
     (SELECT country FROM countries WHERE countryname='Norway'),
     'Oslo Bowling',
@@ -11,188 +11,188 @@ INSERT INTO tournaments
 );
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1,
    (SELECT player FROM players WHERE nick='DufF'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2,
    (SELECT player FROM players WHERE nick='Snute'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    3,
    (SELECT player FROM players WHERE nick='Magnar'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    4,
    (SELECT player FROM players WHERE nick='Daniil'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    5,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    6,
    (SELECT player FROM players WHERE nick='RiChY'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    7,
    (SELECT player FROM players WHERE nick='Tom'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Psychofreud' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Psychofreud' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    8,
    (SELECT player FROM players WHERE nick='Psychofreud'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    9,
    (SELECT player FROM players WHERE nick='T|na'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    10,
    (SELECT player FROM players WHERE nick='Draconia'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kabooze' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kabooze' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    11,
    (SELECT player FROM players WHERE nick='Kabooze'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    12,
    (SELECT player FROM players WHERE nick='Yeye'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    13,
    (SELECT player FROM players WHERE nick='kjmcw'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    14,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    15,
    (SELECT player FROM players WHERE nick='Iris'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    16,
    (SELECT player FROM players WHERE nick='Pfxp'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    17,
    (SELECT player FROM players WHERE nick='Purity'),
    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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    18,
    (SELECT player FROM players WHERE nick='Indy'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nevrosert' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nevrosert' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    19,
    (SELECT player FROM players WHERE nick='Nevrosert'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    20,
    (SELECT player FROM players WHERE nick='Advena'),
    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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    21,
    (SELECT player FROM players WHERE nick='Matsi'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    22,
    (SELECT player FROM players WHERE nick='Lejordet'),
    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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    23,
    (SELECT player FROM players WHERE nick='Smiph'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    24,
    (SELECT player FROM players WHERE nick='Havok'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Rannveig' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Rannveig' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    25,
    (SELECT player FROM players WHERE nick='Rannveig'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'p33r' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'p33r' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    26,
    (SELECT player FROM players WHERE nick='p33r'),
    NULL);
 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Malin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Malin' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    27,
    (SELECT player FROM players WHERE nick='Malin'),
    NULL);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' 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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0);
 UPDATE rounds SET randomsongs=0 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=1;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' 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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Malin'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Malin'),
    0,
@@ -200,13 +200,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    3127);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='p33r'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='p33r'),
    0,
@@ -214,13 +214,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    3371);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Rannveig'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Rannveig'),
    0,
@@ -228,13 +228,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    3480);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Havok'),
    0,
@@ -242,13 +242,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    3872);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Smiph'),
    0,
@@ -256,13 +256,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    4182);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Lejordet'),
    6
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Lejordet'),
    0,
@@ -270,13 +270,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    5816);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    7
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Matsi'),
    0,
@@ -284,13 +284,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6179);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Advena'),
    8
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Advena'),
    0,
@@ -298,13 +298,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6193);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Nevrosert'),
    9
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Nevrosert'),
    0,
@@ -312,13 +312,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6216);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    10
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Indy'),
    0,
@@ -326,13 +326,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6469);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Purity'),
    11
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Purity'),
    0,
@@ -340,13 +340,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6620);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    12
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Pfxp'),
    0,
@@ -354,13 +354,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6718);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    13
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Iris'),
    0,
@@ -368,13 +368,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6740);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    14
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    0,
@@ -382,13 +382,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    6836);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='kjmcw'),
    15
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='kjmcw'),
    0,
@@ -396,13 +396,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7197);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Yeye'),
    16
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Yeye'),
    0,
@@ -410,13 +410,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7218);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Kabooze'),
    17
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Kabooze'),
    0,
@@ -424,13 +424,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7286);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Draconia'),
    18
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Draconia'),
    0,
@@ -438,13 +438,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7511);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    19
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='T|na'),
    0,
@@ -452,13 +452,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7513);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Psychofreud'),
    20
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Psychofreud'),
    0,
@@ -466,13 +466,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7989);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    21
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    0,
@@ -480,13 +480,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8157);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    22
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='RiChY'),
    0,
@@ -494,13 +494,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8178);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Magnar'),
    23
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Magnar'),
    0,
@@ -508,13 +508,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8208);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    24
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -522,13 +522,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8230);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    25
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -536,13 +536,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8487);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Daniil'),
    26
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -550,13 +550,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8517);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    27
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    1, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,
@@ -565,26 +565,26 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    8554);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' 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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0);
 UPDATE rounds SET randomsongs=0 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND 
   round=2;
 UPDATE rounds SET chosensongs=1 WHERE 
-  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND 
+  tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' 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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Magnar'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Magnar'),
    0,
@@ -592,13 +592,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8003);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='DufF'),
    0,
@@ -606,13 +606,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    8508);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    3
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
@@ -620,13 +620,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7867);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Daniil'),
    4
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Daniil'),
    0,
@@ -634,13 +634,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    't',
    7999);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    5
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
-   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+   (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
    2, 0,
    (SELECT player FROM players WHERE nick='Snute'),
    0,