(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 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 1,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 2,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 3,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 4,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 5,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=1;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1, 6,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 1,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 2,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=2;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=2;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2, 3,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=3;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=3;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
3, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=4;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=4;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
4, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=5;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=5;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
5, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=6;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=6;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
6, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=7;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=7;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
7, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
7, 0,
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=8;
UPDATE rounds SET chosensongs=1 WHERE
tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
round=8;
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
8, 0,
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
8, 0,