+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' )),
+ 'Fredrikstad Turnering',
+ (SELECT country FROM countries WHERE countryname='Norway'),
+ 'Fredrikstad Mestern Bowling',
+ '2003-09-21',
+ (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, 'FantNo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'FantNo' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Purity'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Freaky Mama=)' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Freaky Mama=)' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4,
+ (SELECT player FROM players WHERE nick='ViD'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Naughty' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Naughty' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7,
+ (SELECT player FROM players WHERE nick='T|na'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 8,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 9,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sniff' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sniff' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 10,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 11,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'erikTman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'erikTman' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 12,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 13,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 14,
+ (SELECT player FROM players WHERE nick='Jallaman'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Svimse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Svimse' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 15,
+ (SELECT player FROM players WHERE nick='Svimse'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 16,
+ (SELECT player FROM players WHERE nick='Jannemor'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nypd' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nypd' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 17,
+ (SELECT player FROM players WHERE nick='Nypd'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 18,
+ (SELECT player FROM players WHERE nick='Cyanid'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Joachim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Joachim' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 19,
+ (SELECT player FROM players WHERE nick='Joachim'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 20,
+ (SELECT player FROM players WHERE nick='Haz'),
+ NULL);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+ 'f',
+ 5840);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+ 'f',
+ 6114);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 7496);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+ 'f',
+ 5569);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+ 'f',
+ 5317);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 6867);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nypd'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nypd'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+ 'f',
+ 3862);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nypd'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+ 'f',
+ 4500);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nypd'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+ 't',
+ 4745);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+ 'f',
+ 6192);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+ 'f',
+ 5938);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 7329);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+ 'f',
+ 5287);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
+ 'f',
+ 5043);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 7159);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2);
+UPDATE rounds SET randomsongs=0 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Cyanid'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Cyanid'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('')),
+ 'f',
+ 0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Cyanid'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+ 't',
+ 1370);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Cyanid'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+ 't',
+ 2891);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('')),
+ 'f',
+ 4323);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+ 't',
+ 3573);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 't',
+ 5054);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('')),
+ 'f',
+ 6817);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+ 't',
+ 3553);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 6517);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('')),
+ 'f',
+ 6293);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
+ 't',
+ 5696);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
+ 't',
+ 6693);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Jannemor'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Jannemor'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('')),
+ 'f',
+ 3730);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Jannemor'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
+ 't',
+ 3147);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Jannemor'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 't',
+ 4358);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Jallaman'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Jallaman'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+ 'f',
+ 3515);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Jallaman'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 3147);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Jallaman'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 5470);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+ 'f',
+ 3938);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 3298);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+ 't',
+ 5113);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+ 'f',
+ 5460);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 6276);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
+ 't',
+ 6071);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+ 'f',
+ 4872);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 3300);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 't',
+ 6048);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Haz'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Haz'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
+ 'f',
+ 1412);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Haz'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 1345);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Haz'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+ 'f',
+ 4819);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+ 'f',
+ 5278);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 6401);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Svimse'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Svimse'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+ 'f',
+ 4300);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Svimse'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+ 'f',
+ 4804);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Svimse'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+ 'f',
+ 4559);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+ 'f',
+ 5739);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 't',
+ 3383);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+ 'f',
+ 5505);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+ 'f',
+ 5504);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 6380);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Joachim'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Joachim'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
+ 'f',
+ 1103);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Joachim'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+ 'f',
+ 2364);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Joachim'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 1355);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+ 'f',
+ 5189);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+ 'f',
+ 5678);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 7552);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+ 'f',
+ 4090);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+ 'f',
+ 4791);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7502);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+ 'f',
+ 4296);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+ 'f',
+ 5179);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='x3mnrj'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 6261);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+ 'f',
+ 5090);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+ 'f',
+ 5631);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 7632);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+ 'f',
+ 5097);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+ 'f',
+ 5581);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7483);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+ 'f',
+ 4844);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
+ 'f',
+ 5202);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='DiJam'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 'f',
+ 6989);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+ 'f',
+ 5870);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 't',
+ 7042);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 'f',
+ 4763);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+ 'f',
+ 4734);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Sniff'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 5407);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 'f',
+ 4156);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+ 'f',
+ 4075);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='erikTman'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
+ 't',
+ 0);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 'f',
+ 6148);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+ 'f',
+ 5309);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7283);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 'f',
+ 6267);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+ 'f',
+ 5196);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7020);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 'f',
+ 5759);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+ 'f',
+ 5460);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 7096);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=3;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=3;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 'f',
+ 6164);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 6893);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 'f',
+ 6629);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7007);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 'f',
+ 6228);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 6771);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 'f',
+ 6662);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 6792);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 'f',
+ 6056);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Naughty'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 6743);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 'f',
+ 6831);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 7555);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=4;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=4;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+ 'f',
+ 4974);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 6786);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+ 'f',
+ 4583);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Pfxp'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 5798);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+ 'f',
+ 4441);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+ 't',
+ 6444);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+ 'f',
+ 4156);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 7098);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
+ 'f',
+ 5499);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+ 't',
+ 6885);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=5;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=5;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 'f',
+ 6478);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 't',
+ 5992);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 'f',
+ 6733);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='ViD'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 't',
+ 5490);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 'f',
+ 7513);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+ 't',
+ 6333);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 'f',
+ 7651);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+ 't',
+ 6983);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=6;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=6;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+ 'f',
+ 5887);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Freaky Mama=)'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 't',
+ 6461);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+ 'f',
+ 5978);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 7154);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
+ 'f',
+ 6566);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 7754);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=7;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ round=7;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+ 'f',
+ 6099);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Purity'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+ 't',
+ 5967);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
+ 'f',
+ 6480);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='FantNo'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7929);
+commit;