X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc5-04.sql;h=0865dd108efbf9cb50ab6676c9521c9f0287ea91;hp=2bb2e31b5b127345734c0e74884472350be132e9;hb=1f60fb5390460b3db78b28cadc8790cce5da267c;hpb=1c54093a61bb4f6633bc7649e72a33a2ccb3bb40 diff --git a/sql/cc04/cc5-04.sql b/sql/cc04/cc5-04.sql index 2bb2e31..0865dd1 100644 --- a/sql/cc04/cc5-04.sql +++ b/sql/cc04/cc5-04.sql @@ -40,24 +40,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 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Eruanna'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 4721); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Eruanna'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), '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 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Eruanna'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6966); @@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Andeplane'), 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 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5019); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 6152); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 7108); @@ -96,24 +102,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Zeila'), 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 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Zeila'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5066); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Zeila'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 5352); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Zeila'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7198); @@ -124,24 +133,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 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6156); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 7590); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8352); @@ -152,24 +164,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bonzo'), 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 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5813); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 6831); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7766); @@ -180,24 +195,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 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 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6444); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 7576); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 't', 7626); @@ -227,24 +245,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Chimera'), 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 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Chimera'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 5567); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Chimera'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 4361); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Chimera'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 5565); @@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Alexxz'), 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 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 5491); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 6262); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7712); @@ -283,24 +307,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Smiph'), 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 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6086); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 6603); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8273); @@ -311,24 +338,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 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6327); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 7596); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7879); @@ -339,24 +369,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 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 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6255); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 7084); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Pingo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8287); @@ -367,24 +400,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 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6772); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 8406); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7950); @@ -414,24 +450,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mickva'), 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 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mickva'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 4465); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mickva'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 4028); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mickva'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 5991); @@ -442,24 +481,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Havok'), 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 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 4920); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 4843); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7321); @@ -470,24 +512,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Felz'), 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 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5808); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 5815); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 7912); @@ -498,24 +543,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mync'), 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 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5263); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 5942); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mync'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8607); @@ -526,24 +574,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 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 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 6737); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 6570); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7713); @@ -554,24 +605,27 @@ 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 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 7205); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 6463); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 't', 7926); @@ -601,24 +655,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ingviild'), 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 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ingviild'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 5859); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ingviild'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 4881); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ingviild'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6608); @@ -629,24 +686,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ngan'), 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 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ngan'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 6613); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ngan'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5443); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ngan'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 't', 5594); @@ -657,24 +717,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Cuivien'), 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 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Cuivien'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 7812); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Cuivien'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6291); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Cuivien'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8215); @@ -685,24 +748,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Daniil'), 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 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 8313); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6442); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8048); @@ -713,24 +779,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 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 8573); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6436); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8156); @@ -741,24 +810,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 7958); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6351); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8482); @@ -788,24 +860,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Maxion'), 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 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Maxion'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 5747); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Maxion'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6617); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Maxion'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 't', 5844); @@ -816,24 +891,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Lindaninja'), 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 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Lindaninja'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 6165); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Lindaninja'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6631); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Lindaninja'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7569); @@ -844,24 +922,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Asphodel'), 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 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Asphodel'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7341); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Asphodel'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6061); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Asphodel'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7656); @@ -872,24 +953,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Cehtna'), 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 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Cehtna'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7809); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Cehtna'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7520); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Cehtna'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 7030); @@ -900,24 +984,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 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 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8235); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7930); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 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', 7759); @@ -928,24 +1015,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 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 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8154); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7758); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7463); @@ -956,24 +1046,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8580); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 8478); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 't', 8195); @@ -1003,24 +1096,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Athena'), 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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Athena'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 4975); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Athena'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 5292); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Athena'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 6141); @@ -1031,24 +1127,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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Andre'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5503); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Andre'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), '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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Andre'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 6345); @@ -1059,24 +1158,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Marilla'), 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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), '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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 5008); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 6534); @@ -1087,24 +1189,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ozon'), 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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6040); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 6589); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8005); @@ -1115,24 +1220,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haanz'), 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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Haanz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 4809); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Haanz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 6176); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Haanz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 7953); @@ -1143,24 +1251,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6040); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 8064); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 7648); @@ -1171,24 +1282,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 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 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6274); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 7686); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7587); @@ -1223,24 +1337,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 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8122); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), '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 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8550); @@ -1251,24 +1368,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mync'), 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 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 7831); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 7442); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8239); @@ -1279,24 +1399,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 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8742); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 8478); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8785); @@ -1307,24 +1430,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Daniil'), 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 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8218); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 7626); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8773); @@ -1335,24 +1461,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 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8734); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 8640); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8773); @@ -1363,24 +1492,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 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 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8692); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 7952); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8653); @@ -1410,24 +1542,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ozon'), 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 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Ozon'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6062); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Ozon'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6369); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Ozon'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8251); @@ -1438,24 +1573,27 @@ 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 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6416); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6971); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8504); @@ -1466,24 +1604,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 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6535); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6863); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8476); @@ -1494,24 +1635,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6705); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6938); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8378); @@ -1522,24 +1666,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), '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 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 7037); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8454); @@ -1550,24 +1697,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Olemann'), 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 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6181); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6748); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (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', 8457); @@ -1597,24 +1747,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 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 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 5689); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8037); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8235); @@ -1625,24 +1778,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 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 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6172); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8011); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8558); @@ -1653,24 +1809,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 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 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6544); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8240); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8820); @@ -1681,24 +1840,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 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 5960); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8158); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8486); @@ -1709,24 +1871,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 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 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6287); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (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', 7795); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Stream'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8495); @@ -1737,24 +1902,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 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6870); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8658); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 8677); @@ -1784,17 +1952,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 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 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8665); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8561); @@ -1805,17 +1975,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 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 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8071); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8262); @@ -1826,17 +1998,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8651); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8731); @@ -1847,17 +2021,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7787); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8652); @@ -1868,17 +2044,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 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 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8492); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8654); @@ -1889,17 +2067,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 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 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8267); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8734); @@ -1910,17 +2090,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8565); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8643); @@ -1931,17 +2113,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 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 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8580); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8693); @@ -1952,17 +2136,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 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 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8805); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8819); @@ -1992,17 +2178,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 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 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6387); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 7925); @@ -2013,17 +2201,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6883); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8820); @@ -2034,17 +2224,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6593); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8561); @@ -2055,17 +2247,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6498); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8723); @@ -2076,17 +2270,19 @@ 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 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6765); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8606); @@ -2097,17 +2293,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 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 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6536); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 't', 8855); @@ -2118,17 +2316,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 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6884); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8757); @@ -2158,17 +2358,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 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 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 7858); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8472); @@ -2179,17 +2381,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 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8682); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8800); @@ -2200,17 +2404,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8257); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8754); @@ -2221,17 +2427,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8741); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 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', 8766); @@ -2242,17 +2450,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 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 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8403); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8604); @@ -2282,17 +2492,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 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8198); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 9195); @@ -2303,17 +2515,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 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 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 7744); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8691); @@ -2324,17 +2538,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 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8365); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8600); @@ -2345,17 +2561,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8455); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8875); @@ -2385,17 +2603,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 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8550); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8972); @@ -2406,17 +2626,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 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8763); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8905); @@ -2427,17 +2649,19 @@ 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 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8516); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8070); @@ -2467,17 +2691,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 5 - NM'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6621); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8891); @@ -2488,17 +2714,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 5 - NM'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6634); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 9672); @@ -2528,17 +2756,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 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 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5271); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7905); @@ -2549,17 +2779,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 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5683); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8381); @@ -2570,17 +2802,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 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 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5509); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8471); @@ -2610,17 +2844,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 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 5 - NM'), 10, 0, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8343); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 10, 0, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8674); @@ -2631,17 +2867,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 5 - NM'), 10, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8013); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 10, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 7325);