begin;
INSERT INTO tournaments
(season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
- (SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
'Fredrikstad Turnering',
(SELECT country FROM countries WHERE countryname='Norway'),
'Fredrikstad Mestern Bowling',
);
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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1,
(SELECT player FROM players WHERE nick='FantNo'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2,
(SELECT player FROM players WHERE nick='Purity'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Freaky Mama=)' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Freaky Mama=)' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4,
(SELECT player FROM players WHERE nick='ViD'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5,
(SELECT player FROM players WHERE nick='Pfxp'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Naughty' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Naughty' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6,
(SELECT player FROM players WHERE nick='Naughty'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7,
(SELECT player FROM players WHERE nick='T|na'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8,
(SELECT player FROM players WHERE nick='Snofox'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9,
(SELECT player FROM players WHERE nick='x3mnrj'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sniff' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sniff' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10,
(SELECT player FROM players WHERE nick='Sniff'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11,
(SELECT player FROM players WHERE nick='DiJam'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'erikTman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'erikTman' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12,
(SELECT player FROM players WHERE nick='erikTman'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13,
(SELECT player FROM players WHERE nick='Smiph'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14,
(SELECT player FROM players WHERE nick='Jallaman'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Svimse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Svimse' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15,
(SELECT player FROM players WHERE nick='Svimse'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
16,
(SELECT player FROM players WHERE nick='Jannemor'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nypd' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nypd' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
17,
(SELECT player FROM players WHERE nick='Nypd'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
18,
(SELECT player FROM players WHERE nick='Cyanid'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Joachim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Joachim' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
19,
(SELECT player FROM players WHERE nick='Joachim'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
20,
(SELECT player FROM players WHERE nick='Haz'),
NULL);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='T|na'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='T|na'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='T|na'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='T|na'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Nypd'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Nypd'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Nypd'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Nypd'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Purity'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Purity'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Purity'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Purity'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Smiph'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Smiph'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Smiph'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 1,
(SELECT player FROM players WHERE nick='Smiph'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2);
UPDATE rounds SET randomsongs=0 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Cyanid'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Cyanid'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Cyanid'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Cyanid'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='DiJam'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='DiJam'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='DiJam'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='DiJam'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Pfxp'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='ViD'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='ViD'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='ViD'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='ViD'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Jannemor'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Jannemor'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Jannemor'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 2,
(SELECT player FROM players WHERE nick='Jannemor'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT song FROM songs WHERE lower(title)=lower('20th November'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Jallaman'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Jallaman'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Jallaman'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Jallaman'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='erikTman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='erikTman'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='erikTman'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='erikTman'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='FantNo'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='FantNo'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='FantNo'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='FantNo'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Sniff'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Sniff'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Sniff'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Sniff'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Haz'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Haz'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Haz'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 3,
(SELECT player FROM players WHERE nick='Haz'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Svimse'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Svimse'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Svimse'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Svimse'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Snofox'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Snofox'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Snofox'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Snofox'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Naughty'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Naughty'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Naughty'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Naughty'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Joachim'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Joachim'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Joachim'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 4,
(SELECT player FROM players WHERE nick='Joachim'),
2,
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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Purity'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Purity'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Purity'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Purity'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='T|na'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='T|na'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='T|na'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='T|na'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='x3mnrj'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='ViD'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='ViD'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='ViD'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='ViD'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Pfxp'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Pfxp'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Pfxp'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='Pfxp'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='DiJam'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='DiJam'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='DiJam'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 1,
(SELECT player FROM players WHERE nick='DiJam'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='FantNo'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='FantNo'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='FantNo'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='FantNo'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Sniff'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Sniff'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Sniff'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Sniff'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='erikTman'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='erikTman'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='erikTman'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='erikTman'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Naughty'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Naughty'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Naughty'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Naughty'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
2,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Snofox'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Snofox'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Snofox'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 2,
(SELECT player FROM players WHERE nick='Snofox'),
2,
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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT song FROM songs WHERE lower(title)=lower('B4U'))
);
UPDATE rounds SET randomsongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=3;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='ViD'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='ViD'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='ViD'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Purity'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Purity'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Purity'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Naughty'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Naughty'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Naughty'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='FantNo'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='FantNo'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='FantNo'),
1,
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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
);
UPDATE rounds SET randomsongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=4;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Purity'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Purity'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Purity'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Pfxp'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='ViD'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='ViD'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='ViD'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='FantNo'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='FantNo'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='FantNo'),
1,
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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
);
UPDATE rounds SET randomsongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=5;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='ViD'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='ViD'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='ViD'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Purity'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Purity'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Purity'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='FantNo'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='FantNo'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='FantNo'),
1,
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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
);
UPDATE rounds SET randomsongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=6;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Freaky Mama=)'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Purity'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Purity'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Purity'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='FantNo'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='FantNo'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='FantNo'),
1,
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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
);
UPDATE rounds SET randomsongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=7;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Purity'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Purity'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Purity'),
1,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='FantNo'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='FantNo'),
0,
'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Ã\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='FantNo'),
1,