X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc3-04.sql;h=7f01806926ba11d0f3f79f4130f0cb4e099c5287;hp=90eaad17eb70ad897b26176628a208f1b4c03d6c;hb=1f60fb5390460b3db78b28cadc8790cce5da267c;hpb=1c54093a61bb4f6633bc7649e72a33a2ccb3bb40 diff --git a/sql/cc04/cc3-04.sql b/sql/cc04/cc3-04.sql index 90eaad1..7f01806 100644 --- a/sql/cc04/cc3-04.sql +++ b/sql/cc04/cc3-04.sql @@ -40,24 +40,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ted Kristian'), 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 3'), 1, 1, (SELECT player FROM players WHERE nick='Ted Kristian'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 4475); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Ted Kristian'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 5340); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Ted Kristian'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7032); @@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pål Andre'), 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 3'), 1, 1, (SELECT player FROM players WHERE nick='Pål Andre'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 4760); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Pål Andre'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 5946); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Pål Andre'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 5875); @@ -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5734); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7095); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8047); @@ -124,24 +133,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 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 3'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6356); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7560); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 't', 7720); @@ -152,24 +164,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 3'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6480); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7646); -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 3'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 't', 7702); @@ -199,24 +214,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Jim Andre'), 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 3'), 1, 2, (SELECT player FROM players WHERE nick='Jim Andre'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 5809); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Jim Andre'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5338); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Jim Andre'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 't', 6198); @@ -227,24 +245,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Andre'), 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 3'), 1, 2, (SELECT player FROM players WHERE nick='Andre'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 4264); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Andre'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 3773); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Andre'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 5277); @@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Dabi'), 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 3'), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 5388); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5249); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7228); @@ -283,24 +307,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 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 3'), 1, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6226); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 6708); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 't', 6445); @@ -311,24 +338,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 3'), 1, 2, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 7353); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 7214); -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 3'), 1, 2, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 't', 6791); @@ -358,24 +388,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Glukko'), 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 3'), 1, 3, (SELECT player FROM players WHERE nick='Glukko'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), 'f', 4346); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='Glukko'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 3531); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='Glukko'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 5270); @@ -386,17 +419,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ole-Christian'), 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 3'), 1, 3, (SELECT player FROM players WHERE nick='Ole-Christian'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), '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 3'), 1, 3, (SELECT player FROM players WHERE nick='Ole-Christian'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 0); @@ -407,24 +442,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Zyc'), 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 3'), 1, 3, (SELECT player FROM players WHERE nick='Zyc'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), 'f', 4898); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='Zyc'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 3333); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='Zyc'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 5149); @@ -435,24 +473,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 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 3'), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), 'f', 5189); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 4391); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7298); @@ -463,24 +504,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 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 3'), 1, 3, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), 'f', 5822); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 8510); -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 3'), 1, 3, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 't', 8504); @@ -510,24 +554,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Th0rny'), 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 3'), 1, 4, (SELECT player FROM players WHERE nick='Th0rny'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), '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 3'), 1, 4, (SELECT player FROM players WHERE nick='Th0rny'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6214); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='Th0rny'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8348); @@ -538,24 +585,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 3'), 1, 4, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), 'f', 5618); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6326); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8278); @@ -566,24 +616,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Matsi'), 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 3'), 1, 4, (SELECT player FROM players WHERE nick='Matsi'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), 'f', 4525); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='Matsi'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6008); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='Matsi'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 7040); @@ -594,24 +647,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Draconia'), 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 3'), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), 'f', 5716); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6169); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7682); @@ -622,24 +678,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 3'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), 'f', 6023); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6628); -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 3'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8179); @@ -669,24 +728,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Eruanna'), 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 3'), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 5410); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 4383); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6040); @@ -697,24 +759,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Advena'), 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 3'), 1, 5, (SELECT player FROM players WHERE nick='Advena'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 6729); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Advena'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7069); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Advena'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7624); @@ -725,24 +790,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tassen'), 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 3'), 1, 5, (SELECT player FROM players WHERE nick='Tassen'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 6911); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Tassen'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 6693); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Tassen'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7298); @@ -753,24 +821,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Duckling'), 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 3'), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), '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 3'), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7357); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7321); @@ -781,24 +852,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Olemann'), 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 3'), 1, 5, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 7471); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7919); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='Olemann'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8043); @@ -809,24 +883,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 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 3'), 1, 5, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 8546); -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 3'), 1, 5, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), '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 3'), 1, 5, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7740); @@ -856,24 +933,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bonzo'), 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 3'), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 4564); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 6212); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7211); @@ -884,24 +964,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gollum'), 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 3'), 1, 6, (SELECT player FROM players WHERE nick='Gollum'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 3139); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Gollum'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 5655); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Gollum'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6369); @@ -912,24 +995,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hugo'), 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 3'), 1, 6, (SELECT player FROM players WHERE nick='Hugo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 6888); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Hugo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8521); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Hugo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 't', 7439); @@ -940,24 +1026,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Auran'), 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 3'), 1, 6, (SELECT player FROM players WHERE nick='Auran'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 3300); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Auran'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 3813); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Auran'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 't', 4377); @@ -968,24 +1057,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 3'), 1, 6, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 5696); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 7569); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7703); @@ -996,24 +1088,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 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 3'), 1, 6, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 5989); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 7689); -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 3'), 1, 6, (SELECT player FROM players WHERE nick='Stream'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8064); @@ -1048,24 +1143,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 3'), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 5825); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 4790); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7961); @@ -1076,24 +1174,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mulefisk'), 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 3'), 2, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 6533); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5504); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Mulefisk'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 7989); @@ -1104,24 +1205,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 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 3'), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 7101); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5725); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8713); @@ -1132,24 +1236,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Th0rny'), 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 3'), 2, 1, (SELECT player FROM players WHERE nick='Th0rny'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 6377); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Th0rny'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 4994); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='Th0rny'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8140); @@ -1160,24 +1267,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 3'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 7140); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5515); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 't', 8310); @@ -1188,24 +1298,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 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 3'), 2, 1, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 6447); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5518); -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 3'), 2, 1, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8271); @@ -1235,24 +1348,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Dabi'), 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 3'), 2, 2, (SELECT player FROM players WHERE nick='Dabi'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 4394); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Dabi'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), 'f', 4295); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Dabi'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6188); @@ -1263,24 +1379,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Duckling'), 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 3'), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5898); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), 'f', 5857); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8053); @@ -1291,24 +1410,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 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 3'), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5873); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), 'f', 5881); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8283); @@ -1319,24 +1441,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 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 3'), 2, 2, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5820); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), 'f', 6437); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Stream'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8232); @@ -1347,24 +1472,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 3'), 2, 2, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6509); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), 'f', 6858); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8420); @@ -1375,24 +1503,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hugo'), 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 3'), 2, 2, (SELECT player FROM players WHERE nick='Hugo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6424); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Hugo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), 'f', 6499); -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 3'), 2, 2, (SELECT player FROM players WHERE nick='Hugo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8601); @@ -1422,24 +1553,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Zyc'), 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 3'), 2, 3, (SELECT player FROM players WHERE nick='Zyc'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 3711); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='Zyc'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 3767); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='Zyc'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 0); @@ -1450,24 +1584,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 3'), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8621); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 5773); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 6811); @@ -1478,24 +1615,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 3'), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8853); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 5898); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8750); @@ -1506,24 +1646,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Olemann'), 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 3'), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 6836); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 5513); -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 3'), 2, 3, (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', 7941); @@ -1534,24 +1677,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 3'), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8490); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 6341); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8630); @@ -1562,24 +1708,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 3'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8781); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 6211); -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 3'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 8384); @@ -1609,17 +1758,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 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 3'), 3, 0, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6565); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7765); @@ -1630,17 +1781,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 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 3'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6520); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8489); @@ -1651,17 +1804,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 3'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7553); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8621); @@ -1672,17 +1827,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 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 3'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7015); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 't', 8627); @@ -1693,17 +1850,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hugo'), 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 3'), 3, 0, (SELECT player FROM players WHERE nick='Hugo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7258); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='Hugo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8228); @@ -1714,17 +1873,19 @@ 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 3'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), '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 3'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8453); @@ -1735,17 +1896,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 3'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7605); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8374); @@ -1756,17 +1919,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 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 3'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7185); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8475); @@ -1777,17 +1942,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 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 3'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6892); -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 3'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8468); @@ -1817,17 +1984,19 @@ 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 3'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 'f', 7528); -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 3'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8273); @@ -1838,17 +2007,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hugo'), 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 3'), 4, 0, (SELECT player FROM players WHERE nick='Hugo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 'f', 7376); -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 3'), 4, 0, (SELECT player FROM players WHERE nick='Hugo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8693); @@ -1859,17 +2030,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 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 3'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 'f', 7371); -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 3'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8723); @@ -1880,17 +2053,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 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 3'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 'f', 7282); -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 3'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8778); @@ -1901,17 +2076,19 @@ 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 3'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 'f', 7352); -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 3'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8808); @@ -1922,17 +2099,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 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 3'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 'f', 7606); -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 3'), 4, 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', 8748); @@ -1943,17 +2122,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 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 3'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 'f', 7572); -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 3'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8555); @@ -1983,17 +2164,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hugo'), 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 3'), 5, 0, (SELECT player FROM players WHERE nick='Hugo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 'f', 7573); -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 3'), 5, 0, (SELECT player FROM players WHERE nick='Hugo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8539); @@ -2004,17 +2187,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 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 3'), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 'f', 7586); -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 3'), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8349); @@ -2025,17 +2210,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 3'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 'f', 7742); -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 3'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8914); @@ -2046,17 +2233,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 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 3'), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 'f', 7692); -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 3'), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8612); @@ -2067,17 +2256,19 @@ 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 3'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 'f', 7830); -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 3'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8782); @@ -2107,17 +2298,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hugo'), 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 3'), 6, 0, (SELECT player FROM players WHERE nick='Hugo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), '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 3'), 6, 0, (SELECT player FROM players WHERE nick='Hugo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8635); @@ -2128,17 +2321,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 3'), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6094); -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 3'), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8264); @@ -2149,17 +2344,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 3'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6623); -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 3'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8828); @@ -2170,17 +2367,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 3'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6455); -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 3'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8728); @@ -2210,17 +2409,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hugo'), 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 3'), 7, 0, (SELECT player FROM players WHERE nick='Hugo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8273); -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 3'), 7, 0, (SELECT player FROM players WHERE nick='Hugo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8169); @@ -2231,17 +2432,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 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 3'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8420); -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 3'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8678); @@ -2252,17 +2455,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 3'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8604); -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 3'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8794); @@ -2294,17 +2499,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 3'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5640); -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 3'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 8906); @@ -2315,17 +2522,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 3'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5750); -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 3'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 9496);