X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fvarious-6.sql;fp=sql%2Fvarious%2Fvarious-6.sql;h=5b9ebe350463406df25dacc73e5721474080db3b;hp=3103160481f078fca171cf340f4828bf6a9d89b1;hb=f77426158d4ef1b9b4a344de2d6cf6ef0c398734;hpb=e5f210a4894f541c6b2d2b9cdddea887ebea1fb3 diff --git a/sql/various/various-6.sql b/sql/various/various-6.sql index 3103160..5b9ebe3 100644 --- a/sql/various/various-6.sql +++ b/sql/various/various-6.sql @@ -1,7 +1,7 @@ begin; INSERT INTO tournaments (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( - (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 'Pingleturnering', (SELECT country FROM countries WHERE countryname='Norway'), 'Ski Metro Bowling', @@ -11,92 +11,92 @@ INSERT INTO tournaments ); 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, (SELECT player FROM players WHERE nick='Snute'), 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, (SELECT player FROM players WHERE nick='Stream'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, (SELECT player FROM players WHERE nick='DufF'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, (SELECT player FROM players WHERE nick='Olemann'), 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, (SELECT player FROM players WHERE nick='Ylini'), 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, (SELECT player FROM players WHERE nick='Matsi'), 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, (SELECT player FROM players WHERE nick='Magnar'), 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 8, (SELECT player FROM players WHERE nick='Advena'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gollum' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 9, (SELECT player FROM players WHERE nick='Gollum'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sparks' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sparks' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 10, (SELECT player FROM players WHERE nick='Sparks'), NULL); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Magnar'), 0, @@ -104,7 +104,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3411); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Magnar'), 1, @@ -112,7 +112,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3756); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Magnar'), 2, @@ -120,13 +120,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4404); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Advena'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Advena'), 0, @@ -134,7 +134,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3313); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Advena'), 1, @@ -142,7 +142,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3023); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Advena'), 2, @@ -150,13 +150,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3569); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Snute'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -164,7 +164,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3823); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -172,7 +172,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4597); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -180,13 +180,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4830); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Gollum'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Gollum'), 0, @@ -194,7 +194,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3284); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Gollum'), 1, @@ -202,7 +202,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3634); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Gollum'), 2, @@ -210,13 +210,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Olemann'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -224,7 +224,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3845); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -232,7 +232,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3698); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -240,13 +240,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4257); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Ylini'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -254,7 +254,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3205); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -262,7 +262,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4043); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -270,13 +270,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4149); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Sparks'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Sparks'), 0, @@ -284,7 +284,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3710); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Sparks'), 1, @@ -292,7 +292,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3541); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Sparks'), 2, @@ -300,13 +300,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3760); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='DufF'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -314,7 +314,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3924); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -322,7 +322,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4480); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -330,13 +330,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4638); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Matsi'), 9 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Matsi'), 0, @@ -344,7 +344,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 2398); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Matsi'), 1, @@ -352,7 +352,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 2726); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Matsi'), 2, @@ -360,13 +360,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3114); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Stream'), 10 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -374,7 +374,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4022); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -382,7 +382,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4189); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 1, 0, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -391,32 +391,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 4393); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Matsi'), 0, @@ -424,7 +424,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3052); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Matsi'), 1, @@ -432,7 +432,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 2527); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Matsi'), 2, @@ -440,13 +440,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4644); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Advena'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Advena'), 0, @@ -454,7 +454,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 2919); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Advena'), 1, @@ -462,7 +462,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Advena'), 2, @@ -470,13 +470,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Magnar'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Magnar'), 0, @@ -484,7 +484,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3157); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Magnar'), 1, @@ -492,7 +492,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 897); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Magnar'), 2, @@ -500,13 +500,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4560); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Ylini'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -514,7 +514,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4060); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -522,7 +522,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4665); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -530,13 +530,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4765); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -544,7 +544,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4770); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -552,7 +552,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4880); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -560,13 +560,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4858); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -574,7 +574,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4736); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -582,7 +582,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4746); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -590,13 +590,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4348); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -604,7 +604,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5719); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -612,7 +612,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5034); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -620,13 +620,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4598); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -634,7 +634,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5699); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -642,7 +642,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4818); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -651,32 +651,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 5513); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0); UPDATE rounds SET randomsongs=0 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=3; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=3; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=3; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Advena'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Advena'), 0, @@ -684,7 +684,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4196); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Advena'), 1, @@ -692,7 +692,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Advena'), 2, @@ -700,13 +700,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3502); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Ylini'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -714,7 +714,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4548); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -722,7 +722,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4248); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -730,13 +730,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4492); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -744,7 +744,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5396); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -752,7 +752,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4405); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -760,13 +760,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4808); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Olemann'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -774,7 +774,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5012); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -782,7 +782,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4703); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -790,13 +790,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4785); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -804,7 +804,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5045); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -812,7 +812,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5274); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -820,13 +820,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4972); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -834,7 +834,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5699); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -842,7 +842,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4818); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -851,29 +851,29 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 5206); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0); UPDATE rounds SET randomsongs=0 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=4; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=4; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -881,7 +881,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4769); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -889,7 +889,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4593); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -897,13 +897,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4291); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Olemann'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -911,7 +911,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4305); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -919,7 +919,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4963); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -927,13 +927,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4475); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Stream'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -941,7 +941,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4916); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -949,7 +949,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4991); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -957,13 +957,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4981); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -971,7 +971,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4932); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -979,7 +979,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5091); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -987,13 +987,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5617); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1001,7 +1001,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5037); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1009,7 +1009,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4972); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -1018,32 +1018,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 5323); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0); UPDATE rounds SET randomsongs=0 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=5; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=5; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=5; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Olemann'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -1051,7 +1051,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -1059,7 +1059,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4873); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -1067,13 +1067,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5298); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1081,7 +1081,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5400); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1089,7 +1089,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5513); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -1097,13 +1097,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5491); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1111,7 +1111,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5666); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1119,7 +1119,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -1127,13 +1127,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5754); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1141,7 +1141,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6483); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1149,7 +1149,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6101); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -1158,34 +1158,34 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 5884); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=6; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND round=6; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1193,7 +1193,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6194); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1201,7 +1201,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6399); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -1209,13 +1209,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6902); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1223,7 +1223,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6545); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1231,7 +1231,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6381); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -1239,13 +1239,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6628); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1253,7 +1253,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6623); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1261,7 +1261,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6960); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -1270,38 +1270,38 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 6521); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) ); UPDATE rounds SET randomsongs=3 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1309,7 +1309,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5973); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1317,7 +1317,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6394); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -1325,13 +1325,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4517); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1339,7 +1339,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6197); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1347,7 +1347,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6428); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 2,