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' )),
'Follo lag turnering',
(SELECT country FROM countries WHERE countryname='Norway'),
'Ski Metro Bowling',
);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1,
(SELECT player FROM players WHERE nick='Havok'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1,
(SELECT player FROM players WHERE nick='RiChY'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1,
(SELECT player FROM players WHERE nick='Stream'),
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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2,
(SELECT player FROM players WHERE nick='Snofox'),
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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2,
(SELECT player FROM players WHERE nick='ViD'),
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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2,
(SELECT player FROM players WHERE nick='Jannemor'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3,
(SELECT player FROM players WHERE nick='Spinnvill'),
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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3,
(SELECT player FROM players WHERE nick='Jallaman'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3,
(SELECT player FROM players WHERE nick='Indy'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4,
(SELECT player FROM players WHERE nick='Snute'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4,
(SELECT player FROM players WHERE nick='Slusk'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4,
(SELECT player FROM players WHERE nick='Matsi'),
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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5,
(SELECT player FROM players WHERE nick='Smiph'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Iris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Iris' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5,
(SELECT player FROM players WHERE nick='Iris'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5,
(SELECT player FROM players WHERE nick='Ylini'),
NULL);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT player FROM players WHERE nick='Indy'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT player FROM players WHERE nick='Indy'),
0,
'f',
4653);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT player FROM players WHERE nick='Indy'),
1,
'f',
5301);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT player FROM players WHERE nick='Iris'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT player FROM players WHERE nick='Iris'),
0,
'f',
3728);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1, 0,
(SELECT player FROM players WHERE nick='Iris'),
1,
3723);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
- (SELECT song FROM songs WHERE lower(title)=lower('CandyâÂ\98Â\86'))
+ (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
(SELECT player FROM players WHERE nick='Smiph'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
(SELECT player FROM players WHERE nick='Smiph'),
0,
- (SELECT song FROM songs WHERE lower(title)=lower('CandyâÂ\98Â\86')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86')),
'f',
5687);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
(SELECT player FROM players WHERE nick='Smiph'),
1,
'f',
7943);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
(SELECT player FROM players WHERE nick='Spinnvill'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
(SELECT player FROM players WHERE nick='Spinnvill'),
0,
- (SELECT song FROM songs WHERE lower(title)=lower('CandyâÂ\98Â\86')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86')),
'f',
5385);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
2, 0,
(SELECT player FROM players WHERE nick='Spinnvill'),
1,
7583);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Jannemor'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Jannemor'),
0,
'f',
4632);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Jannemor'),
1,
'f',
4470);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Stream'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
'f',
5638);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
3, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
5961);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Slusk'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Slusk'),
0,
'f',
4632);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Slusk'),
1,
'f',
7219);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
0,
'f',
4862);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
4, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
1,
6836);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT song FROM songs WHERE lower(title)=lower('D2R'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Smiph'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Smiph'),
0,
'f',
4855);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Smiph'),
1,
'f',
5763);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Havok'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Havok'),
0,
'f',
4733);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
5, 0,
(SELECT player FROM players WHERE nick='Havok'),
1,
5903);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
0,
'f',
5949);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='Jallaman'),
1,
'f',
6361);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='ViD'),
0,
'f',
5865);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6, 0,
(SELECT player FROM players WHERE nick='ViD'),
1,
7033);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Ylini'),
0,
'f',
4136);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1,
'f',
6417);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Indy'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Indy'),
0,
'f',
3949);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
7, 0,
(SELECT player FROM players WHERE nick='Indy'),
1,
6290);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=8;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(SELECT player FROM players WHERE nick='ViD'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(SELECT player FROM players WHERE nick='ViD'),
0,
'f',
6247);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(SELECT player FROM players WHERE nick='ViD'),
1,
'f',
8112);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(SELECT player FROM players WHERE nick='Snute'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
'f',
7071);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
8, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
8421);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=9;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT player FROM players WHERE nick='Matsi'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT player FROM players WHERE nick='Matsi'),
0,
'f',
4785);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT player FROM players WHERE nick='Matsi'),
1,
'f',
6046);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT player FROM players WHERE nick='RiChY'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT player FROM players WHERE nick='RiChY'),
0,
'f',
6103);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
9, 0,
(SELECT player FROM players WHERE nick='RiChY'),
1,
8380);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT song FROM songs WHERE lower(title)=lower('B4U'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=10;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT player FROM players WHERE nick='Snute'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
'f',
7395);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
'f',
8533);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT player FROM players WHERE nick='Snofox'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT player FROM players WHERE nick='Snofox'),
0,
'f',
6785);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
10, 0,
(SELECT player FROM players WHERE nick='Snofox'),
1,
8245);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=11;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT player FROM players WHERE nick='Ylini'),
0,
'f',
5661);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1,
'f',
4896);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT player FROM players WHERE nick='Spinnvill'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT player FROM players WHERE nick='Spinnvill'),
0,
'f',
5612);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
11, 0,
(SELECT player FROM players WHERE nick='Spinnvill'),
1,
7466);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=12;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT player FROM players WHERE nick='Iris'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT player FROM players WHERE nick='Iris'),
0,
'f',
3737);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT player FROM players WHERE nick='Iris'),
1,
'f',
4697);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT player FROM players WHERE nick='Jannemor'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT player FROM players WHERE nick='Jannemor'),
0,
'f',
4397);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
12, 0,
(SELECT player FROM players WHERE nick='Jannemor'),
1,
4913);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=13;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT player FROM players WHERE nick='Snofox'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT player FROM players WHERE nick='Snofox'),
0,
'f',
6719);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT player FROM players WHERE nick='Snofox'),
1,
'f',
7780);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT player FROM players WHERE nick='Slusk'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT player FROM players WHERE nick='Slusk'),
0,
'f',
1357);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
13, 0,
(SELECT player FROM players WHERE nick='Slusk'),
1,
6766);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=14;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT player FROM players WHERE nick='Matsi'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT player FROM players WHERE nick='Matsi'),
0,
'f',
4824);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT player FROM players WHERE nick='Matsi'),
1,
'f',
6750);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT player FROM players WHERE nick='Havok'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT player FROM players WHERE nick='Havok'),
0,
'f',
4924);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
14, 0,
(SELECT player FROM players WHERE nick='Havok'),
1,
5773);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
);
UPDATE rounds SET randomsongs=2 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
round=15;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT player FROM players WHERE nick='Stream'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
'f',
5900);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
'f',
7930);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT player FROM players WHERE nick='RiChY'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT player FROM players WHERE nick='RiChY'),
0,
'f',
6917);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
15, 0,
(SELECT player FROM players WHERE nick='RiChY'),
1,