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