X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc7-04.sql;h=7ab0b3d5e0b145282b056b4cdee04ed85552738b;hp=18f43e3bea6f9342d1031b20bf3d8e91619e36d1;hb=1f60fb5390460b3db78b28cadc8790cce5da267c;hpb=0bf5bdff5cf1840aca5bde3fa36a74a6ce959a80 diff --git a/sql/cc04/cc7-04.sql b/sql/cc04/cc7-04.sql index 18f43e3..7ab0b3d 100644 --- a/sql/cc04/cc7-04.sql +++ b/sql/cc04/cc7-04.sql @@ -40,24 +40,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Crienexzy'), 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 7'), 1, 1, (SELECT player FROM players WHERE nick='Crienexzy'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5584); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Crienexzy'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 4702); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Crienexzy'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6464); @@ -68,24 +71,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Tove'), 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 7'), 1, 1, (SELECT player FROM players WHERE nick='Tove'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 4854); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Tove'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 4742); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Tove'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 't', 5960); @@ -96,24 +102,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='JonAnders'), 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 7'), 1, 1, (SELECT player FROM players WHERE nick='JonAnders'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5596); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='JonAnders'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 3874); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='JonAnders'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 6468); @@ -124,24 +133,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Andeplane'), 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 7'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6008); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 4778); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8366); @@ -152,24 +164,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Matsi'), 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 7'), 1, 1, (SELECT player FROM players WHERE nick='Matsi'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5523); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Matsi'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5217); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Matsi'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7826); @@ -180,24 +195,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6511); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5597); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='Snofox'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7861); @@ -208,24 +226,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 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 7'), 1, 1, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6435); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), 'f', 5090); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 1, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8182); @@ -255,24 +276,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='uSimen'), 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 7'), 1, 2, (SELECT player FROM players WHERE nick='uSimen'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 5520); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='uSimen'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 6691); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='uSimen'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 't', 5919); @@ -283,24 +307,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pfxp'), 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 7'), 1, 2, (SELECT player FROM players WHERE nick='Pfxp'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 5958); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Pfxp'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 7853); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Pfxp'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7595); @@ -311,24 +338,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Glock'), 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 7'), 1, 2, (SELECT player FROM players WHERE nick='Glock'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 4185); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Glock'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 6679); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Glock'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 't', 6267); @@ -339,24 +369,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Eruanna'), 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 7'), 1, 2, (SELECT player FROM players WHERE nick='Eruanna'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 4341); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Eruanna'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 7410); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Eruanna'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7395); @@ -367,24 +400,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='v|per'), 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 7'), 1, 2, (SELECT player FROM players WHERE nick='v|per'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 6649); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='v|per'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 7443); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='v|per'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7410); @@ -395,24 +431,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Daniil'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 7830); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 8431); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 't', 6831); @@ -423,24 +462,27 @@ 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 7'), 1, 2, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 'f', 8724); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 8731); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 2, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 't', 6959); @@ -470,24 +512,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Benny'), 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 7'), 1, 3, (SELECT player FROM players WHERE nick='Benny'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 6069); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Benny'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5138); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Benny'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8091); @@ -498,24 +543,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Volstad'), 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 7'), 1, 3, (SELECT player FROM players WHERE nick='Volstad'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 6326); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Volstad'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5502); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Volstad'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7588); @@ -526,24 +574,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Annkakri'), 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 7'), 1, 3, (SELECT player FROM players WHERE nick='Annkakri'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 4418); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Annkakri'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 4148); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Annkakri'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6373); @@ -554,24 +605,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Athena'), 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 7'), 1, 3, (SELECT player FROM players WHERE nick='Athena'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 6783); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Athena'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5119); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Athena'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7869); @@ -582,24 +636,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Felz'), 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 7'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 7297); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6030); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 't', 7391); @@ -610,24 +667,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 7'), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 7471); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6230); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7479); @@ -638,24 +698,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 7'), 1, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 7854); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6684); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7493); @@ -685,24 +748,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Voffen'), 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 7'), 1, 4, (SELECT player FROM players WHERE nick='Voffen'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 3516); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Voffen'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 3154); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Voffen'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 't', 3880); @@ -713,24 +779,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Zackie'), 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 7'), 1, 4, (SELECT player FROM players WHERE nick='Zackie'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 6260); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Zackie'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 4965); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Zackie'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7501); @@ -741,24 +810,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 7'), 1, 4, (SELECT player FROM players WHERE nick='Zeila'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 6582); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Zeila'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 6357); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Zeila'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7466); @@ -769,24 +841,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Alexxz'), 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 7'), 1, 4, (SELECT player FROM players WHERE nick='Alexxz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7079); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Alexxz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 6790); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Alexxz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 7418); @@ -797,24 +872,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 7'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7219); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 6300); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8442); @@ -825,24 +903,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 7'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7680); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), 'f', 6996); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8415); @@ -872,24 +953,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='SLC'), 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 7'), 1, 5, (SELECT player FROM players WHERE nick='SLC'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')), 'f', 5267); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='SLC'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 5382); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='SLC'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8059); @@ -900,24 +984,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Matti'), 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 7'), 1, 5, (SELECT player FROM players WHERE nick='Matti'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')), 'f', 5707); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Matti'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 4999); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Matti'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7415); @@ -928,24 +1015,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Hyper'), 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 7'), 1, 5, (SELECT player FROM players WHERE nick='Hyper'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')), 'f', 4604); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Hyper'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 4909); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Hyper'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8154); @@ -956,24 +1046,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 7'), 1, 5, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')), 'f', 5602); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 5644); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Mync'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 8002); @@ -984,24 +1077,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Duckling'), 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 7'), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')), 'f', 5867); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 5728); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8126); @@ -1012,24 +1108,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 7'), 1, 5, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')), 'f', 6375); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), 'f', 6569); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 5, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 't', 8548); @@ -1059,24 +1158,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Dritago'), 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 7'), 1, 6, (SELECT player FROM players WHERE nick='Dritago'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 'f', 7445); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Dritago'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6566); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Dritago'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8257); @@ -1087,24 +1189,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pyro'), 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 7'), 1, 6, (SELECT player FROM players WHERE nick='Pyro'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 'f', 7026); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Pyro'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5519); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Pyro'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7792); @@ -1115,24 +1220,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 7'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 'f', 6970); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5783); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7532); @@ -1143,24 +1251,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 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 7'), 1, 6, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 'f', 7202); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6666); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Pingo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8740); @@ -1171,24 +1282,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 7'), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 'f', 7537); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6450); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='Bonzo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8608); @@ -1199,24 +1313,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 7'), 1, 6, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 'f', 7612); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6822); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 6, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 't', 8570); @@ -1246,24 +1363,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Indy'), 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 7'), 1, 7, (SELECT player FROM players WHERE nick='Indy'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 4984); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Indy'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 4764); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Indy'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7395); @@ -1274,24 +1394,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Electron'), 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 7'), 1, 7, (SELECT player FROM players WHERE nick='Electron'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 6998); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Electron'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 6599); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Electron'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7401); @@ -1302,24 +1425,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bush'), 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 7'), 1, 7, (SELECT player FROM players WHERE nick='Bush'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 5022); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Bush'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 3527); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Bush'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 5434); @@ -1330,24 +1456,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 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 7'), 1, 7, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8367); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 7439); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Gogo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7768); @@ -1358,24 +1487,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Smiph'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 7428); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 6726); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8047); @@ -1386,24 +1518,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 7'), 1, 7, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8429); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8532); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 1, 7, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8675); @@ -1438,24 +1573,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='v|per'), 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 7'), 2, 1, (SELECT player FROM players WHERE nick='v|per'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 5504); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='v|per'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 5609); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='v|per'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 6936); @@ -1466,24 +1604,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 7'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 6179); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6075); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8508); @@ -1494,24 +1635,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Duckling'), 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 7'), 2, 1, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 6417); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6355); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8581); @@ -1522,24 +1666,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 7'), 2, 1, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 6640); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6515); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8359); @@ -1550,24 +1697,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 7'), 2, 1, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 6630); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6243); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Pingo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8738); @@ -1578,24 +1728,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 7'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 6730); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6719); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8805); @@ -1606,24 +1759,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 7'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 6697); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6758); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8297); @@ -1653,24 +1809,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Alexxz'), 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 7'), 2, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6175); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 6752); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 7730); @@ -1681,24 +1840,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Smiph'), 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 7'), 2, 2, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 5951); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 6669); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8209); @@ -1709,24 +1871,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (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', 6003); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 7353); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8111); @@ -1737,24 +1902,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 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 7'), 2, 2, (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', 6792); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 6897); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Gogo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8678); @@ -1765,24 +1933,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6704); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 8140); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8539); @@ -1793,24 +1964,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 7'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6455); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 7779); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8648); @@ -1821,24 +1995,27 @@ 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 7'), 2, 2, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6606); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 8683); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 2, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8596); @@ -1868,24 +2045,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Felz'), 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 7'), 2, 3, (SELECT player FROM players WHERE nick='Felz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 7472); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Felz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 6843); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Felz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8098); @@ -1896,24 +2076,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 7'), 2, 3, (SELECT player FROM players WHERE nick='Andeplane'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 8100); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Andeplane'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 6651); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Andeplane'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8529); @@ -1924,24 +2107,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bonzo'), 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 7'), 2, 3, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 8294); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 8144); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Bonzo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8673); @@ -1952,24 +2138,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 7'), 2, 3, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 7415); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 6458); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8566); @@ -1980,24 +2169,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 7'), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 7732); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 7534); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8077); @@ -2008,24 +2200,27 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 8004); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 8351); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Snofox'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8672); @@ -2036,24 +2231,27 @@ 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 7'), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 8352); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 'f', 8506); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 2, 3, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8743); @@ -2083,17 +2281,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 7'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6592); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8710); @@ -2104,17 +2304,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 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 7'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6798); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8698); @@ -2125,17 +2327,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 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 7'), 3, 0, (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', 6281); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8210); @@ -2146,17 +2350,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6681); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 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', 8551); @@ -2167,17 +2373,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6873); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8553); @@ -2188,17 +2396,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bonzo'), 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 7'), 3, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6497); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 9102); @@ -2209,17 +2419,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 7'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6778); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 't', 8795); @@ -2230,17 +2442,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 7'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6637); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 't', 8631); @@ -2251,17 +2465,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 9 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6667); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8909); @@ -2291,17 +2507,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 7'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 7190); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8806); @@ -2312,17 +2530,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 6818); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8630); @@ -2333,17 +2553,19 @@ 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 7'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 7492); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8462); @@ -2354,17 +2576,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 7135); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8913); @@ -2375,17 +2599,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 7539); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8869); @@ -2396,17 +2622,19 @@ 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 7'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 7486); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8824); @@ -2417,17 +2645,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bonzo'), 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 7'), 4, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 7116); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 4, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8847); @@ -2457,17 +2687,19 @@ 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 7'), 5, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Remember You')), 'f', 4624); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8607); @@ -2478,17 +2710,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Remember You')), 'f', 4707); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8978); @@ -2499,17 +2733,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Remember You')), 'f', 4620); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8696); @@ -2520,17 +2756,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Remember You')), 'f', 4811); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8846); @@ -2541,17 +2779,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Remember You')), 'f', 4891); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8798); @@ -2581,17 +2821,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snofox'), 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 7'), 6, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8290); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 6, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8658); @@ -2602,17 +2844,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 7'), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8621); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8760); @@ -2623,17 +2867,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 7'), 6, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8421); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 6, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8744); @@ -2644,17 +2890,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 7'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8756); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8772); @@ -2684,17 +2932,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 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 7'), 7, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), '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 7'), 7, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8859); @@ -2705,17 +2955,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 7'), 7, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6855); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 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', 8787); @@ -2726,17 +2978,19 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), '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 7'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8954); @@ -2768,17 +3022,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 7'), 8, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 'f', 7821); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 8, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 9608); @@ -2789,17 +3045,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 7'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U')), 'f', 7845); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 9578);