(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'),
+ 1, 'Snute', 100);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 2, 'DufF', 90);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 3, 'OJK', 81);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 4, 'Oliyzia', 73);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 5, 'Tom', 66);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 6, 'Snofox', 60);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 7, 'RiChY', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 8, 'Haggar', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 9, 'Mulefisk', 48);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 10, 'Daniil', 46);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 11, 'T|na', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 12, 'Stream', 44);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 13, 'Purity', 43);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 14, 'Spinnvill', 42);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 15, 'Jallaman', 41);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 16, 'Smiph', 40);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 17, 'Electus', 39);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 18, 'Havok', 38);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 19, 'Dexter', 37);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 20, 'Draconia', 36);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 21, 'Advena', 35);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 22, 'Slusk', 34);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 23, 'Telc', 33);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 24, 'Matsi', 32);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 25, 'Olemann', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 26, 'Duckling', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 27, 'Ylini', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 28, 'Golddragon', 28);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 29, 'tombot', 27);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 30, 'x3mnrj', 26);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 31, 'Tha Dragon', 25);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 32, 'Octu', 24);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 33, 'Ink', 23);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+ 34, 'Auran', 22);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),