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