X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fcc04%2Fcc2-04.sql;h=641a3df21ba2402f19ad36566a4d4a4fe52a1d40;hb=4ddc2d1937960d5cf4017644a41433eac2f6f391;hp=e50ba53022323a57d26f132c5d95f2a6b1637b44;hpb=1f60fb5390460b3db78b28cadc8790cce5da267c;p=ccbs diff --git a/sql/cc04/cc2-04.sql b/sql/cc04/cc2-04.sql index e50ba53..641a3df 100644 --- a/sql/cc04/cc2-04.sql +++ b/sql/cc04/cc2-04.sql @@ -1,47 +1,92 @@ begin; INSERT INTO tournaments - (season, name, country, location, "date", machine, scoringsystem) VALUES ( - (SELECT season FROM seasons WHERE name='Challenge Cup 2004'), + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'), 'Challenge Cup 2', - (SELECT country FROM countries WHERE name='Norway'), + (SELECT country FROM countries WHERE countryname='Norway'), 'Kino 1 Sandvika', '2004-04-25', - (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'), - (SELECT scoringsystem FROM scoringsystems WHERE name='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 2'), + 1, 'OJK', 100); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 2, 'Snute', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 3, 'DufF', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 4, 'Snofox', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 5, 'T|na', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 6, 'RiChY', 60); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 7, 'Stream', 55); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 8, 'Olemann', 51); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 9, 'Raazu', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 10, 'Ylini', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 11, 'Smiph', 45); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 12, 'Havok', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 13, 'Draconia', 43); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 14, 'Dabi', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 15, 'Bush', 41); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Memories')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 0, @@ -49,7 +94,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4327); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 1, @@ -57,7 +102,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4251); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 2, @@ -66,13 +111,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 5910); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -80,7 +125,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5476); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -88,7 +133,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6242); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -97,13 +142,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7977); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -111,7 +156,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6224); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -119,7 +164,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6659); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -128,13 +173,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7572); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -142,7 +187,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6530); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -150,7 +195,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6702); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -159,13 +204,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7631); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -173,7 +218,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7561); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -181,7 +226,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7616); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -189,33 +234,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6839); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 0, @@ -223,7 +268,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3973); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 1, @@ -231,7 +276,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3845); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 2, @@ -240,13 +285,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 6484); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -254,7 +299,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7827); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -262,7 +307,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6329); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -271,13 +316,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8032); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 0, @@ -285,7 +330,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7830); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 1, @@ -293,7 +338,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6336); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 2, @@ -302,13 +347,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7544); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -316,7 +361,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8058); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -324,7 +369,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7672); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -333,13 +378,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8167); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -347,7 +392,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8651); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -355,7 +400,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8426); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -363,33 +408,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8392); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('D2R')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 0, @@ -397,7 +442,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5012); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 1, @@ -405,7 +450,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4014); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 2, @@ -414,13 +459,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 6940); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 0, @@ -428,7 +473,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5541); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 1, @@ -436,7 +481,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 2, @@ -445,13 +490,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7524); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 0, @@ -459,7 +504,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4355); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 1, @@ -467,7 +512,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6284); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 2, @@ -476,13 +521,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 4399); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -490,7 +535,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5953); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -498,7 +543,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8076); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 2, @@ -507,13 +552,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7735); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -521,7 +566,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6044); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -529,7 +574,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8303); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -538,32 +583,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8625); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=2; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Raazu'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Raazu'), 0, @@ -571,7 +616,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7286); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Raazu'), 1, @@ -580,13 +625,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7657); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -594,7 +639,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7814); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -603,13 +648,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7986); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -617,7 +662,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7747); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -626,13 +671,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7721); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='T|na'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -640,7 +685,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8215); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -649,13 +694,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8053); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Snofox'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -663,7 +708,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8529); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -672,13 +717,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8570); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='RiChY'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -686,7 +731,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8478); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -695,13 +740,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8174); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -709,7 +754,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8743); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -718,13 +763,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8447); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='OJK'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -732,7 +777,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8695); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -741,13 +786,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8440); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 9 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -755,7 +800,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8798); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -764,32 +809,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8500); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=3; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=3; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -797,7 +842,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7698); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -806,13 +851,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 7874); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -820,7 +865,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8241); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -829,13 +874,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8574); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -843,7 +888,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8139); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -852,13 +897,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8403); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -866,7 +911,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8661); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -875,13 +920,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8456); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -889,7 +934,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8272); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -898,13 +943,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8353); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -912,7 +957,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8783); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -921,13 +966,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8673); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -935,7 +980,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8633); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -944,32 +989,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8584); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=4; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=4; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -977,7 +1022,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5706); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -986,13 +1031,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8583); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='T|na'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1000,7 +1045,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5726); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1009,13 +1054,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8056); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -1023,7 +1068,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5553); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -1032,13 +1077,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8525); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1046,7 +1091,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5822); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1055,13 +1100,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8460); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1069,7 +1114,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5922); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1078,32 +1123,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8725); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=5; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=5; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -1111,7 +1156,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6450); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -1120,13 +1165,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8236); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1134,7 +1179,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6742); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1143,13 +1188,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8728); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1157,7 +1202,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6605); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1166,13 +1211,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8534); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1180,7 +1225,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6689); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1189,32 +1234,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8828); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=6; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=6; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1222,7 +1267,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7343); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1231,13 +1276,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8871); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1245,7 +1290,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7152); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1254,13 +1299,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8718); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1268,7 +1313,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6908); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1277,32 +1322,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 9276); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=7; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND round=7; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1310,7 +1355,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8662); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1319,13 +1364,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8776); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1333,7 +1378,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8676); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), 1,