X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fvarious-5.sql;fp=sql%2Fvarious%2Fvarious-5.sql;h=c391345fb209fdc406962abb185d9621e51a6b63;hp=b5e25aac94d673edcb47db2a9fc65453b785c7d0;hb=9a91e199a828e7e317335bb4121761950f31ccef;hpb=f77426158d4ef1b9b4a344de2d6cf6ef0c398734 diff --git a/sql/various/various-5.sql b/sql/various/various-5.sql index b5e25aa..c391345 100644 --- a/sql/various/various-5.sql +++ b/sql/various/various-5.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' )), 'Fredrikstad Turnering', (SELECT country FROM countries WHERE countryname='Norway'), 'Fredrikstad Mestern Bowling', @@ -11,156 +11,156 @@ INSERT INTO tournaments ); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'FantNo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'FantNo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, (SELECT player FROM players WHERE nick='FantNo'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, (SELECT player FROM players WHERE nick='Purity'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Freaky Mama=)' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Freaky Mama=)' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, (SELECT player FROM players WHERE nick='Freaky Mama=)'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, (SELECT player FROM players WHERE nick='ViD'), 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, (SELECT player FROM players WHERE nick='Pfxp'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Naughty' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Naughty' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, (SELECT player FROM players WHERE nick='Naughty'), 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, (SELECT player FROM players WHERE nick='T|na'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 8, (SELECT player FROM players WHERE nick='Snofox'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 9, (SELECT player FROM players WHERE nick='x3mnrj'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sniff' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sniff' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 10, (SELECT player FROM players WHERE nick='Sniff'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 11, (SELECT player FROM players WHERE nick='DiJam'), 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 12, (SELECT player FROM players WHERE nick='erikTman'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 13, (SELECT player FROM players WHERE nick='Smiph'), 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 14, (SELECT player FROM players WHERE nick='Jallaman'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Svimse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Svimse' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 15, (SELECT player FROM players WHERE nick='Svimse'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 16, (SELECT player FROM players WHERE nick='Jannemor'), 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 17, (SELECT player FROM players WHERE nick='Nypd'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 18, (SELECT player FROM players WHERE nick='Cyanid'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Joachim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Joachim' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 19, (SELECT player FROM players WHERE nick='Joachim'), NULL); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 20, (SELECT player FROM players WHERE nick='Haz'), NULL); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -168,7 +168,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5840); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -176,7 +176,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6114); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -184,13 +184,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7496); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 0, @@ -198,7 +198,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5569); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 1, @@ -206,7 +206,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5317); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 2, @@ -214,13 +214,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6867); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Nypd'), 0, @@ -228,7 +228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3862); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Nypd'), 1, @@ -236,7 +236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4500); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Nypd'), 2, @@ -244,13 +244,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4745); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Purity'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Purity'), 0, @@ -258,7 +258,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6192); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Purity'), 1, @@ -266,7 +266,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5938); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Purity'), 2, @@ -274,13 +274,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7329); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Smiph'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Smiph'), 0, @@ -288,7 +288,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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Smiph'), 1, @@ -296,7 +296,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5043); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 1, (SELECT player FROM players WHERE nick='Smiph'), 2, @@ -304,25 +304,25 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7159); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2); UPDATE rounds SET randomsongs=0 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Cyanid'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Cyanid'), 0, @@ -330,7 +330,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Cyanid'), 1, @@ -338,7 +338,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 1370); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Cyanid'), 2, @@ -346,13 +346,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 2891); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='DiJam'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='DiJam'), 0, @@ -360,7 +360,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4323); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='DiJam'), 1, @@ -368,7 +368,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3573); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='DiJam'), 2, @@ -376,13 +376,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5054); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Pfxp'), 0, @@ -390,7 +390,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6817); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Pfxp'), 1, @@ -398,7 +398,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3553); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Pfxp'), 2, @@ -406,13 +406,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6517); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 0, @@ -420,7 +420,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6293); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 1, @@ -428,7 +428,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5696); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 2, @@ -436,13 +436,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6693); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Jannemor'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Jannemor'), 0, @@ -450,7 +450,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3730); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Jannemor'), 1, @@ -458,7 +458,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3147); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 2, (SELECT player FROM players WHERE nick='Jannemor'), 2, @@ -466,32 +466,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4358); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('20th November')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Jallaman'), 0, @@ -499,7 +499,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3515); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Jallaman'), 1, @@ -507,7 +507,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3147); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Jallaman'), 2, @@ -515,13 +515,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5470); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='erikTman'), 0, @@ -529,7 +529,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3938); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='erikTman'), 1, @@ -537,7 +537,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3298); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='erikTman'), 2, @@ -545,13 +545,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5113); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 0, @@ -559,7 +559,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5460); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 1, @@ -567,7 +567,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6276); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 2, @@ -575,13 +575,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6071); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Sniff'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Sniff'), 0, @@ -589,7 +589,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4872); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Sniff'), 1, @@ -597,7 +597,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3300); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Sniff'), 2, @@ -605,13 +605,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6048); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Haz'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Haz'), 0, @@ -619,7 +619,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 1412); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Haz'), 1, @@ -627,7 +627,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 1345); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 3, (SELECT player FROM players WHERE nick='Haz'), 2, @@ -635,32 +635,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 0, @@ -668,7 +668,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4819); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1, @@ -676,7 +676,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5278); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 2, @@ -684,13 +684,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6401); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Svimse'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Svimse'), 0, @@ -698,7 +698,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4300); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Svimse'), 1, @@ -706,7 +706,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4804); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Svimse'), 2, @@ -714,13 +714,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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Snofox'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -728,7 +728,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4559); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -736,7 +736,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5739); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Snofox'), 2, @@ -744,13 +744,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 3383); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Naughty'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Naughty'), 0, @@ -758,7 +758,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5505); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Naughty'), 1, @@ -766,7 +766,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5504); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Naughty'), 2, @@ -774,13 +774,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6380); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Joachim'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Joachim'), 0, @@ -788,7 +788,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 1103); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Joachim'), 1, @@ -796,7 +796,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 2364); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 1, 4, (SELECT player FROM players WHERE nick='Joachim'), 2, @@ -805,36 +805,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 1355); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='Purity'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='Purity'), 0, @@ -842,7 +842,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5189); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='Purity'), 1, @@ -850,7 +850,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5678); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='Purity'), 2, @@ -858,13 +858,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7552); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -872,7 +872,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4090); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -880,7 +880,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4791); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -888,13 +888,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7502); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 0, @@ -902,7 +902,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4296); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 1, @@ -910,7 +910,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5179); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='x3mnrj'), 2, @@ -918,13 +918,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6261); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 0, @@ -932,7 +932,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5090); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 1, @@ -940,7 +940,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5631); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 2, @@ -948,13 +948,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7632); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='Pfxp'), 0, @@ -962,7 +962,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5097); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='Pfxp'), 1, @@ -970,7 +970,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5581); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='Pfxp'), 2, @@ -978,13 +978,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7483); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='DiJam'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='DiJam'), 0, @@ -992,7 +992,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4844); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='DiJam'), 1, @@ -1000,7 +1000,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5202); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 1, (SELECT player FROM players WHERE nick='DiJam'), 2, @@ -1008,32 +1008,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='FantNo'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='FantNo'), 0, @@ -1041,7 +1041,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6989); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='FantNo'), 1, @@ -1049,7 +1049,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5870); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='FantNo'), 2, @@ -1057,13 +1057,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7042); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Sniff'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Sniff'), 0, @@ -1071,7 +1071,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4763); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Sniff'), 1, @@ -1079,7 +1079,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4734); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Sniff'), 2, @@ -1087,13 +1087,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5407); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='erikTman'), 0, @@ -1101,7 +1101,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4156); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='erikTman'), 1, @@ -1109,7 +1109,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4075); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='erikTman'), 2, @@ -1117,13 +1117,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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Naughty'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Naughty'), 0, @@ -1131,7 +1131,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6148); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Naughty'), 1, @@ -1139,7 +1139,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5309); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Naughty'), 2, @@ -1147,13 +1147,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7283); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 0, @@ -1161,7 +1161,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6267); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1, @@ -1169,7 +1169,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5196); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 2, @@ -1177,13 +1177,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7020); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Snofox'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -1191,7 +1191,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5759); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -1199,7 +1199,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5460); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 2, 2, (SELECT player FROM players WHERE nick='Snofox'), 2, @@ -1208,31 +1208,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7096); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Pfxp'), 0, @@ -1240,7 +1240,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6164); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Pfxp'), 1, @@ -1248,13 +1248,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6893); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='ViD'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='ViD'), 0, @@ -1262,7 +1262,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6629); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='ViD'), 1, @@ -1270,13 +1270,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7007); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Purity'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Purity'), 0, @@ -1284,7 +1284,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6228); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Purity'), 1, @@ -1292,13 +1292,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6771); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 0, @@ -1306,7 +1306,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6662); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1, @@ -1314,13 +1314,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6792); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Naughty'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Naughty'), 0, @@ -1328,7 +1328,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6056); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='Naughty'), 1, @@ -1336,13 +1336,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6743); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='FantNo'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='FantNo'), 0, @@ -1350,7 +1350,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6831); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 3, 0, (SELECT player FROM players WHERE nick='FantNo'), 1, @@ -1359,31 +1359,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7555); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Purity'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Purity'), 0, @@ -1391,7 +1391,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4974); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Purity'), 1, @@ -1399,13 +1399,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6786); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Pfxp'), 0, @@ -1413,7 +1413,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4583); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Pfxp'), 1, @@ -1421,13 +1421,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5798); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 0, @@ -1435,7 +1435,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4441); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1, @@ -1443,13 +1443,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6444); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='ViD'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='ViD'), 0, @@ -1457,7 +1457,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4156); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='ViD'), 1, @@ -1465,13 +1465,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7098); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='FantNo'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='FantNo'), 0, @@ -1479,7 +1479,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5499); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 4, 0, (SELECT player FROM players WHERE nick='FantNo'), 1, @@ -1488,31 +1488,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 6885); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 0, @@ -1520,7 +1520,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6478); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1, @@ -1528,13 +1528,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5992); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='ViD'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='ViD'), 0, @@ -1542,7 +1542,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6733); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='ViD'), 1, @@ -1550,13 +1550,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5490); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='Purity'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='Purity'), 0, @@ -1564,7 +1564,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7513); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='Purity'), 1, @@ -1572,13 +1572,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6333); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='FantNo'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='FantNo'), 0, @@ -1586,7 +1586,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7651); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 5, 0, (SELECT player FROM players WHERE nick='FantNo'), 1, @@ -1595,31 +1595,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 6983); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 0, @@ -1627,7 +1627,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5887); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='Freaky Mama=)'), 1, @@ -1635,13 +1635,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6461); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='Purity'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='Purity'), 0, @@ -1649,7 +1649,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5978); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='Purity'), 1, @@ -1657,13 +1657,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7154); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='FantNo'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='FantNo'), 0, @@ -1671,7 +1671,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6566); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 6, 0, (SELECT player FROM players WHERE nick='FantNo'), 1, @@ -1680,31 +1680,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7754); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )) AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, 0, (SELECT player FROM players WHERE nick='Purity'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, 0, (SELECT player FROM players WHERE nick='Purity'), 0, @@ -1712,7 +1712,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6099); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, 0, (SELECT player FROM players WHERE nick='Purity'), 1, @@ -1720,13 +1720,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5967); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, 0, (SELECT player FROM players WHERE nick='FantNo'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, 0, (SELECT player FROM players WHERE nick='FantNo'), 0, @@ -1734,7 +1734,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6480); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ¥ende' )), + (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )), 7, 0, (SELECT player FROM players WHERE nick='FantNo'), 1,