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