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=0000000000000000000000000000000000000000;hb=38489516a9ad620f3f5cf5a8e5f36117c579e922;hpb=7dfd3ff8c5e3fde12813a1e7b937e5816a027f7a

diff --git a/sql/various/various-3.sql b/sql/various/various-3.sql
new file mode 100644
index 0000000..4bad2ef
--- /dev/null
+++ b/sql/various/various-3.sql
@@ -0,0 +1,650 @@
+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' )),
+    'Aftenposten Cup',
+    (SELECT country FROM countries WHERE countryname='Norway'),
+    'Oslo Bowling',
+    '2003-09-23',
+    (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
+    (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
+);
+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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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' )),
+   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 
+  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 
+  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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Malin'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='p33r'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Rannveig'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Havok'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Lejordet'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Advena'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Nevrosert'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Indy'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Purity'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Pfxp'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Iris'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='kjmcw'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Yeye'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Kabooze'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Psychofreud'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Tom'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+   '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' )),
+   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' )),
+   1, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+   't',
+   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' )),
+   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' )),
+   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 
+  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 
+  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' )),
+   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' )),
+   2, 0,
+   (SELECT player FROM players WHERE nick='Magnar'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   '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' )),
+   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' )),
+   2, 0,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+   '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' )),
+   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' )),
+   2, 0,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+   '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' )),
+   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' )),
+   2, 0,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+   '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' )),
+   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' )),
+   2, 0,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0,
+   (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+   't',
+   8250);
+commit;