X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc5-04.sql;h=0865dd108efbf9cb50ab6676c9521c9f0287ea91;hp=a660957781c1053813139cd2a80f042c984feb4c;hb=1f60fb5390460b3db78b28cadc8790cce5da267c;hpb=e81c2d9126e54860c49eb224f44dc50467790e84 diff --git a/sql/cc04/cc5-04.sql b/sql/cc04/cc5-04.sql index a660957..0865dd1 100644 --- a/sql/cc04/cc5-04.sql +++ b/sql/cc04/cc5-04.sql @@ -40,20 +40,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Eruanna'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Eruanna'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 4721); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Eruanna'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 0); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Eruanna'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6966); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -61,20 +71,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Andeplane'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5019); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Andeplane'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 6152); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 7108); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -82,20 +102,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Zeila'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Zeila'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5066); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Zeila'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 5352); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Zeila'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 7198); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -103,20 +133,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6156); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 7590); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Stream'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8352); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -124,20 +164,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bonzo'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5813); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 6831); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7766); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -145,20 +195,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6444); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 1, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 'f', 7576); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Haggar'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), + 't', + 7626); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2); @@ -185,20 +245,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Chimera'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Chimera'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 5567); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Chimera'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 4361); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Chimera'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 5565); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -206,20 +276,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Alexxz'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 5491); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Alexxz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 6262); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Alexxz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7712); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -227,20 +307,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Smiph'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6086); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 6603); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Smiph'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8273); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -248,20 +338,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Duckling'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6327); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 7596); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Duckling'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7879); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -269,20 +369,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6255); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 7084); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Pingo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8287); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -290,20 +400,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6772); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 8406); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 7950); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3); @@ -330,20 +450,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mickva'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mickva'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 4465); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mickva'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 4028); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Mickva'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 5991); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -351,20 +481,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Havok'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 4920); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Havok'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 4843); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Havok'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7321); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -372,20 +512,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Felz'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5808); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Felz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 5815); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Felz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 7912); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -393,20 +543,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mync'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5263); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 5942); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Mync'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8607); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -414,20 +574,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 6737); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 6570); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Gogo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 7713); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -435,20 +605,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 7205); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 3, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), 'f', 6463); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Snute'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 7926); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4); @@ -475,20 +655,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ingviild'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ingviild'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 5859); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ingviild'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 4881); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Ingviild'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6608); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -496,20 +686,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ngan'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ngan'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 6613); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Ngan'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5443); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Ngan'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 't', + 5594); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -517,20 +717,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Cuivien'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Cuivien'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 7812); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Cuivien'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6291); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Cuivien'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8215); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -538,20 +748,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Daniil'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 8313); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6442); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Daniil'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8048); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -559,20 +779,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Olemann'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 8573); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6436); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Olemann'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8156); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -580,20 +810,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 7958); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 4, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6351); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='RiChY'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8482); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5); @@ -620,20 +860,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Maxion'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Maxion'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 5747); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Maxion'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6617); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Maxion'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 't', + 5844); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -641,20 +891,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Lindaninja'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Lindaninja'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 6165); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Lindaninja'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6631); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Lindaninja'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7569); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -662,20 +922,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Asphodel'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Asphodel'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7341); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Asphodel'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6061); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Asphodel'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7656); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -683,20 +953,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Cehtna'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Cehtna'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7809); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Cehtna'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7520); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Cehtna'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 7030); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -704,20 +984,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8235); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7930); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='T|na'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7759); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -725,20 +1015,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8154); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7758); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Ylini'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7463); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -746,20 +1046,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8580); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 5, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 8478); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 't', + 8195); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6); @@ -786,20 +1096,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Athena'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Athena'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 4975); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Athena'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 5292); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Athena'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6141); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -807,20 +1127,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Andre'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Andre'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5503); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Andre'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 5618); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Andre'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6345); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -828,20 +1158,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Marilla'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5338); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Marilla'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 5008); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Marilla'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 6534); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -849,20 +1189,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ozon'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6040); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 6589); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Ozon'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8005); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -870,20 +1220,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haanz'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Haanz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 4809); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Haanz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 6176); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Haanz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7953); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -891,20 +1251,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6040); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 8064); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 7648); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -912,20 +1282,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 6274); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 'f', 7686); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 7587); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -957,20 +1337,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Bonzo'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8122); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 7553); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8550); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -978,20 +1368,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Mync'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 7831); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 7442); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Mync'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8239); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -999,20 +1399,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8742); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 8478); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Haggar'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 8785); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1020,20 +1430,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Daniil'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8218); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 7626); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Daniil'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8773); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1041,20 +1461,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8734); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 8640); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 8773); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1062,20 +1492,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 'f', 8692); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 1, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), 'f', 7952); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='OJK'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 8653); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2); @@ -1102,20 +1542,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ozon'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Ozon'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6062); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Ozon'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6369); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Ozon'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8251); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1123,20 +1573,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6416); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6971); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='RiChY'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8504); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1144,20 +1604,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6535); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6863); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8476); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1165,20 +1635,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6705); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6938); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='T|na'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8378); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1186,20 +1666,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6565); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 7037); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Nameless'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8454); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1207,20 +1697,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Olemann'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Olemann'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), 'f', 6181); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 2, (SELECT player FROM players WHERE nick='Olemann'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6748); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Olemann'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8457); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3); @@ -1247,20 +1747,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 5689); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8037); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Ylini'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8235); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1268,20 +1778,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6172); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8011); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Pingo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8558); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1289,20 +1809,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6544); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8240); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Gogo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8820); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1310,20 +1840,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Duckling'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 5960); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8158); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Duckling'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8486); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1331,20 +1871,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Stream'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Stream'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6287); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='Stream'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 7795); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Stream'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8495); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1352,20 +1902,30 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6870); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 2, 3, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8658); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 8677); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1392,13 +1952,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8665); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8561); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1406,13 +1975,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Pingo'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8071); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Pingo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8262); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1420,13 +1998,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8651); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8731); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1434,13 +2021,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7787); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8652); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1448,13 +2044,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8492); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8654); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1462,13 +2067,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8267); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8734); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1476,13 +2090,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8565); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Nameless'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8643); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1490,13 +2113,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 8 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8580); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8693); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1504,13 +2136,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 9 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8805); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8819); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1537,13 +2178,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Gogo'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6387); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 7925); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1551,13 +2201,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6883); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8820); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1565,13 +2224,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Nameless'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6593); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Nameless'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8561); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1579,13 +2247,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6498); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8723); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1593,13 +2270,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6765); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8606); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1607,13 +2293,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6536); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy')), + 't', + 8855); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1621,13 +2316,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6884); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8757); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1654,13 +2358,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='RiChY'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 7858); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8472); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1668,13 +2381,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8682); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8800); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1682,13 +2404,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8257); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8754); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1696,13 +2427,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8741); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8766); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1710,13 +2450,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 'f', 8403); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8604); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1743,13 +2492,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8198); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 9195); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1757,13 +2515,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='OJK'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 7744); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8691); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1771,13 +2538,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8365); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 't', + 8600); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1785,13 +2561,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8455); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8875); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1818,13 +2603,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8550); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8972); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1832,13 +2626,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8763); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8905); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1846,13 +2649,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Haggar'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 7, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 'f', 8516); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8070); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1879,13 +2691,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='DufF'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6621); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 8, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8891); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1893,13 +2714,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Snute'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6634); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 9672); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1926,13 +2756,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Ylini'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5271); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0, + (SELECT player FROM players WHERE nick='Ylini'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7905); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1940,13 +2779,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5683); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8381); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1954,13 +2802,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 9, 0, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5509); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8471); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -1987,13 +2844,22 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='T|na'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 10, 0, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8343); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 10, 0, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8674); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), @@ -2001,11 +2867,20 @@ INSERT INTO roundparticipation (tournament, round, parallel, player, position) V (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), 10, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8013); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 10, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 7325); commit;