(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
(SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
);
(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
(SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
);
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
- 22, 'Ted Kristian', 34);
+ 22,
+ (SELECT player FROM players WHERE nick='Ted Kristian'),
+ 34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 1,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 2,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 3,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 4,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 5,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1, 6,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 1,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 2,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2, 3,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=3;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
3, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=4;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
4, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=5;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
5, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=6;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
6, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=7;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
7, 0,
UPDATE rounds SET randomsongs=2 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=8;
UPDATE rounds SET randomsongs=2 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
round=8;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
8, 0,