+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 1, 'Haggar', 100);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 2, 'Snute', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 3, 'Nameless', 81);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 4, 'Snofox', 73);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 5, 'Bonzo', 66);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 6, 'Oliyzia', 60);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 7, 'RiChY', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 8, 'OJK', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 9, 'Pingo', 48);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 10, 'Gogo', 46);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 11, 'T|na', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 12, 'Olemann', 44);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 13, 'Duckling', 43);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 14, 'Andeplane', 42);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 15, 'Ylini', 41);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 16, 'Daniil', 0);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 17, 'Mync', 39);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 18, 'Smiph', 38);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 19, 'Felz', 37);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 20, 'Alexxz', 36);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 21, 'v|per', 35);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 22, 'Dritago', 34);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 23, 'SLC', 33);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 24, 'Athena', 32);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 25, 'Pfxp', 31);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 26, 'Matsi', 30);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 27, 'Zeila', 29);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 28, 'Electron', 28);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 29, 'Pyro', 27);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 30, 'Volstad', 26);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 31, 'Zackie', 25);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 32, 'Matti', 24);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 33, 'Eruanna', 23);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 34, 'Indy', 22);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 35, 'Crienexzy', 21);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 36, 'Hyper', 20);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 37, 'Benny', 19);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 38, 'Marilla', 18);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 39, 'uSimen', 17);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 40, 'JonAnders', 16);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 41, 'Bush', 15);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 42, 'Voffen', 14);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 43, 'Annkakri', 13);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 44, 'Glock', 12);
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
+ 45, 'Tove', 11);