X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc1-04.sql;fp=sql%2Fcc04%2Fcc1-04.sql;h=5a1d89ebe17c87750b91368d68c6ee7cb90f6119;hp=9928c2cd733b2a6aa8ff5bad5cae5c4a88175935;hb=1f60fb5390460b3db78b28cadc8790cce5da267c;hpb=0bf5bdff5cf1840aca5bde3fa36a74a6ce959a80 diff --git a/sql/cc04/cc1-04.sql b/sql/cc04/cc1-04.sql index 9928c2c..5a1d89e 100644 --- a/sql/cc04/cc1-04.sql +++ b/sql/cc04/cc1-04.sql @@ -40,24 +40,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 7505); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 'f', 7204); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 7952); @@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 5104); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 'f', 6302); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6940); @@ -96,24 +102,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mulefisk'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 7279); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 'f', 7205); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 7649); @@ -124,24 +133,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Slusk'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Slusk'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 5544); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Slusk'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 'f', 6465); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Slusk'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7619); @@ -152,24 +164,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tom'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Tom'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 6968); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Tom'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 'f', 8480); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 1, (SELECT player FROM players WHERE nick='Tom'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7702); @@ -199,24 +214,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Golddragon'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Golddragon'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5536); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Golddragon'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 5202); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Golddragon'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 6905); @@ -227,24 +245,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Jallaman'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Jallaman'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5390); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Jallaman'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 4746); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Jallaman'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8151); @@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6849); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 6513); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8242); @@ -283,24 +307,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Matsi'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Matsi'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5675); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Matsi'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 4952); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Matsi'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7354); @@ -311,24 +338,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6720); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 6243); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 2, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 't', 8513); @@ -358,24 +388,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='tombot'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='tombot'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 4876); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='tombot'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 6868); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='tombot'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 6622); @@ -386,24 +419,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ink'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Ink'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 4458); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Ink'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 4053); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Ink'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 't', 5636); @@ -414,24 +450,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 5985); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7459); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Stream'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 't', 7837); @@ -442,24 +481,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Spinnvill'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Spinnvill'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 6173); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Spinnvill'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7732); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Spinnvill'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8031); @@ -470,24 +512,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Telc'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Telc'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 5563); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Telc'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7290); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='Telc'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 't', 7467); @@ -498,24 +543,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 6545); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8636); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 3, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7666); @@ -545,24 +593,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Duckling'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 5235); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 5049); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7172); @@ -573,24 +624,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Auran'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Auran'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 4330); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Auran'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 3698); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Auran'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 4459); @@ -601,24 +655,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Advena'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Advena'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 5233); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Advena'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 5076); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Advena'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7787); @@ -629,24 +686,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 7143); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 7727); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Snofox'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7700); @@ -657,24 +717,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Smiph'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 4862); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 6848); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6668); @@ -685,24 +748,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 8288); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8252); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 4, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7566); @@ -732,24 +798,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='x3mnrj'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='x3mnrj'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6004); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='x3mnrj'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 5699); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='x3mnrj'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 6712); @@ -760,24 +829,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Octu'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Octu'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 5789); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Octu'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 4891); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Octu'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 6321); @@ -788,24 +860,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Electus'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Electus'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6256); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Electus'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 6376); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Electus'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7992); @@ -816,24 +891,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Purity'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Purity'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6498); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Purity'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 6584); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Purity'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8079); @@ -844,24 +922,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Havok'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Havok'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6482); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Havok'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 5994); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Havok'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7576); @@ -872,24 +953,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Draconia'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6130); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 5705); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7935); @@ -919,24 +1003,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Dexter'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Dexter'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6276); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Dexter'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 7296); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Dexter'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8433); @@ -947,24 +1034,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Olemann'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6171); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 6554); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Olemann'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7315); @@ -975,24 +1065,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tha Dragon'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Tha Dragon'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 5269); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Tha Dragon'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 5511); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Tha Dragon'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7357); @@ -1003,24 +1096,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6425); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 8002); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8452); @@ -1031,24 +1127,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6501); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 8519); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8529); @@ -1059,24 +1158,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Daniil'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6503); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 7729); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 1, 6, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8248); @@ -1111,24 +1213,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Smiph'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 5962); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 5704); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8098); @@ -1139,24 +1244,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Daniil'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 7436); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6489); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8489); @@ -1167,24 +1275,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 7619); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6603); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8445); @@ -1195,24 +1306,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 8436); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6567); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8425); @@ -1223,24 +1337,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Purity'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Purity'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 7441); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Purity'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6068); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='Purity'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8424); @@ -1251,24 +1368,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 8253); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6456); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 1, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8595); @@ -1298,24 +1418,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Havok'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Havok'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 'f', 6396); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Havok'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 0); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Havok'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 't', 3161); @@ -1326,24 +1449,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Jallaman'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Jallaman'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 'f', 6943); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Jallaman'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 4881); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Jallaman'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 0); @@ -1354,24 +1480,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 'f', 7235); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6126); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8160); @@ -1382,24 +1511,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 'f', 6370); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5386); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8107); @@ -1410,24 +1542,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 'f', 7691); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6540); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8190); @@ -1438,24 +1573,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 'f', 7777); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6359); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 7800); @@ -1485,24 +1623,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mulefisk'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Mulefisk'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5974); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Mulefisk'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7951); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Mulefisk'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8229); @@ -1513,24 +1654,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5953); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7738); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Stream'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7874); @@ -1541,24 +1685,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Electus'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Electus'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5444); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Electus'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7090); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Electus'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 't', 7249); @@ -1569,24 +1716,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Spinnvill'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Spinnvill'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5540); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Spinnvill'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 6936); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Spinnvill'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 7821); @@ -1597,24 +1747,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 6206); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8084); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7733); @@ -1625,24 +1778,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tom'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Tom'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5836); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Tom'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8046); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 2, 3, (SELECT player FROM players WHERE nick='Tom'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8508); @@ -1672,17 +1828,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8251); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8380); @@ -1693,17 +1851,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7881); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8316); @@ -1714,17 +1874,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8295); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8678); @@ -1735,17 +1897,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8092); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8680); @@ -1756,17 +1920,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mulefisk'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Mulefisk'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7806); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Mulefisk'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 7815); @@ -1777,17 +1943,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8414); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8180); @@ -1798,17 +1966,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8406); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8260); @@ -1819,17 +1989,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 8 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8441); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8539); @@ -1840,17 +2012,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tom'), 9 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Tom'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8489); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 3, 0, (SELECT player FROM players WHERE nick='Tom'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8381); @@ -1880,17 +2054,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), 'f', 6595); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8588); @@ -1901,17 +2077,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), 'f', 6301); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8706); @@ -1922,17 +2100,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), 'f', 6654); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8693); @@ -1943,17 +2123,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), 'f', 6596); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7821); @@ -1964,17 +2146,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tom'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Tom'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), 'f', 6766); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Tom'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 't', 8379); @@ -1985,17 +2169,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), 'f', 6433); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8563); @@ -2006,17 +2192,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), 'f', 6803); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8351); @@ -2046,17 +2234,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7245); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8452); @@ -2067,17 +2257,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tom'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='Tom'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6701); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='Tom'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8960); @@ -2088,17 +2280,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7521); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8615); @@ -2109,17 +2303,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7227); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8541); @@ -2130,17 +2326,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6819); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8853); @@ -2170,17 +2368,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 6663); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8637); @@ -2191,17 +2391,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 6662); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 't', 8044); @@ -2212,17 +2414,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 6810); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 't', 8506); @@ -2233,17 +2437,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 6759); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8544); @@ -2273,17 +2479,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 8391); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8130); @@ -2294,17 +2502,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 9537); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8352); @@ -2315,17 +2525,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 9032); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 8623); @@ -2355,17 +2567,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 'f', 6678); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8781); @@ -2376,17 +2590,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 'f', 6827); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8691);