(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 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
- 23, 'Ted Kristian', 33);
+ 23,
+ (SELECT player FROM players WHERE nick='Ted Kristian'),
+ 33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 1,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 2,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 3,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 4,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 5,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1, 6,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 1,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 2,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2, 3,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=3;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
3, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=4;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
4, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=5;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
5, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=6;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
6, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=7;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
7, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=8;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
round=8;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
8, 0,