begin;
INSERT INTO tournaments
(season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
- (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
'Pingleturnering',
(SELECT country FROM countries WHERE countryname='Norway'),
'Ski Metro Bowling',
);
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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1,
(SELECT player FROM players WHERE nick='Snute'),
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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2,
(SELECT player FROM players WHERE nick='Stream'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3,
(SELECT player FROM players WHERE nick='DufF'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4,
(SELECT player FROM players WHERE nick='Olemann'),
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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5,
(SELECT player FROM players WHERE nick='Ylini'),
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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6,
(SELECT player FROM players WHERE nick='Matsi'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7,
(SELECT player FROM players WHERE nick='Magnar'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
8,
(SELECT player FROM players WHERE nick='Advena'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
9,
(SELECT player FROM players WHERE nick='Gollum'),
NULL);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sparks' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sparks' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
10,
(SELECT player FROM players WHERE nick='Sparks'),
NULL);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0);
UPDATE rounds SET randomsongs=0 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Magnar'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Magnar'),
0,
't',
3411);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Magnar'),
1,
't',
3756);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Magnar'),
2,
't',
4404);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Advena'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Advena'),
0,
't',
3313);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Advena'),
1,
't',
3023);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Advena'),
2,
't',
3569);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Snute'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
't',
3823);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
't',
4597);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Snute'),
2,
't',
4830);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Gollum'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Gollum'),
0,
't',
3284);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Gollum'),
1,
't',
3634);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Gollum'),
2,
't',
0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Olemann'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Olemann'),
0,
't',
3845);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Olemann'),
1,
't',
3698);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Olemann'),
2,
't',
4257);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Ylini'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Ylini'),
0,
't',
3205);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1,
't',
4043);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Ylini'),
2,
't',
4149);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Sparks'),
7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Sparks'),
0,
't',
3710);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Sparks'),
1,
't',
3541);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Sparks'),
2,
't',
3760);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='DufF'),
8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='DufF'),
0,
't',
3924);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='DufF'),
1,
't',
4480);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='DufF'),
2,
't',
4638);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Matsi'),
9
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Matsi'),
0,
't',
2398);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Matsi'),
1,
't',
2726);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Matsi'),
2,
't',
3114);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Stream'),
10
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
't',
4022);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
't',
4189);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
1, 0,
(SELECT player FROM players WHERE nick='Stream'),
2,
4393);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0);
UPDATE rounds SET randomsongs=0 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Matsi'),
0,
't',
3052);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Matsi'),
1,
't',
2527);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Matsi'),
2,
't',
4644);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Advena'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Advena'),
0,
't',
2919);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Advena'),
1,
't',
0);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Advena'),
2,
't',
0);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Magnar'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Magnar'),
0,
't',
3157);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Magnar'),
1,
't',
897);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Magnar'),
2,
't',
4560);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Ylini'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Ylini'),
0,
't',
4060);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1,
't',
4665);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Ylini'),
2,
't',
4765);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Olemann'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Olemann'),
0,
't',
4770);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Olemann'),
1,
't',
4880);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Olemann'),
2,
't',
4858);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Stream'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
't',
4736);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
't',
4746);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Stream'),
2,
't',
4348);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='DufF'),
7
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='DufF'),
0,
't',
5719);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='DufF'),
1,
't',
5034);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='DufF'),
2,
't',
4598);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Snute'),
8
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
't',
5699);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
't',
4818);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
2, 0,
(SELECT player FROM players WHERE nick='Snute'),
2,
5513);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0);
UPDATE rounds SET randomsongs=0 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=3;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=3;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=3;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Advena'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Advena'),
0,
't',
4196);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Advena'),
1,
't',
0);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Advena'),
2,
't',
3502);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Ylini'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Ylini'),
0,
't',
4548);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1,
't',
4248);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Ylini'),
2,
't',
4492);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Stream'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
't',
5396);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
't',
4405);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Stream'),
2,
't',
4808);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Olemann'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Olemann'),
0,
't',
5012);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Olemann'),
1,
't',
4703);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Olemann'),
2,
't',
4785);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='DufF'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='DufF'),
0,
't',
5045);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='DufF'),
1,
't',
5274);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='DufF'),
2,
't',
4972);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Snute'),
6
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
't',
5699);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
't',
4818);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
3, 0,
(SELECT player FROM players WHERE nick='Snute'),
2,
5206);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0);
UPDATE rounds SET randomsongs=0 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=4;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=4;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Ylini'),
0,
'f',
4769);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Ylini'),
1,
't',
4593);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Ylini'),
2,
't',
4291);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Olemann'),
2
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Olemann'),
0,
'f',
4305);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Olemann'),
1,
't',
4963);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Olemann'),
2,
't',
4475);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Stream'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
'f',
4916);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
't',
4991);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Stream'),
2,
't',
4981);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Snute'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
'f',
4932);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
't',
5091);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='Snute'),
2,
't',
5617);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='DufF'),
5
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='DufF'),
0,
'f',
5037);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='DufF'),
1,
't',
4972);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
4, 0,
(SELECT player FROM players WHERE nick='DufF'),
2,
5323);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0);
UPDATE rounds SET randomsongs=0 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=5;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=5;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=5;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Olemann'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Olemann'),
0,
't',
0);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Olemann'),
1,
't',
4873);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Olemann'),
2,
't',
5298);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
't',
5400);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
't',
5513);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Stream'),
2,
't',
5491);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='DufF'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='DufF'),
0,
't',
5666);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='DufF'),
1,
't',
0);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='DufF'),
2,
't',
5754);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Snute'),
4
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
't',
6483);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
't',
6101);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
5, 0,
(SELECT player FROM players WHERE nick='Snute'),
2,
5884);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
);
UPDATE rounds SET randomsongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=6;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=6;
UPDATE rounds SET chosensongs=1 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='DufF'),
1
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='DufF'),
0,
'f',
6194);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='DufF'),
1,
't',
6399);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='DufF'),
2,
't',
6902);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
'f',
6545);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
't',
6381);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='Stream'),
2,
't',
6628);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='Snute'),
3
);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
'f',
6623);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
't',
6960);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
6, 0,
(SELECT player FROM players WHERE nick='Snute'),
2,
6521);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7,
0, 0);
INSERT INTO groups (tournament, round, parallel) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
);
INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
);
UPDATE rounds SET randomsongs=3 WHERE
- tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )) AND
round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT player FROM players WHERE nick='Stream'),
0,
'f',
5973);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT player FROM players WHERE nick='Stream'),
1,
'f',
6394);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT player FROM players WHERE nick='Stream'),
2,
'f',
4517);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 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='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT player FROM players WHERE nick='Snute'),
0,
'f',
6197);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT player FROM players WHERE nick='Snute'),
1,
'f',
6428);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
- (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
+ (SELECT tournament FROM tournaments WHERE tournamentname='Pingleturnering' AND season=( SELECT season FROM seasons WHERE seasonname='FrittstÃ\83Â¥ende' )),
7, 0,
(SELECT player FROM players WHERE nick='Snute'),
2,