X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc5-04.sql;fp=sql%2Fcc04%2Fcc5-04.sql;h=a660957781c1053813139cd2a80f042c984feb4c;hp=0000000000000000000000000000000000000000;hb=e81c2d9126e54860c49eb224f44dc50467790e84;hpb=2ca0daa6916f97279a48669592e198f0d124cc59 diff --git a/sql/cc04/cc5-04.sql b/sql/cc04/cc5-04.sql new file mode 100644 index 0000000..a660957 --- /dev/null +++ b/sql/cc04/cc5-04.sql @@ -0,0 +1,2011 @@ +begin; +INSERT INTO tournaments + (season, name, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE name='Challenge Cup 2004'), + 'Challenge Cup 5 - NM', + (SELECT country FROM countries WHERE name='Norway'), + 'OsloLan', + '2004-10-02', + (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score') +); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' 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'), + 1, 1, + (SELECT player FROM players WHERE nick='Eruanna'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Eruanna'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Eruanna'), + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 0); +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'), + 1, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 6152); +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'), + 1, 1, + (SELECT player FROM players WHERE nick='Zeila'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Zeila'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Zeila'), + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 5352); +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'), + 1, 1, + (SELECT player FROM players WHERE nick='Stream'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Stream'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Stream'), + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 7590); +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'), + 1, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 6831); +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'), + 1, 1, + (SELECT player FROM players WHERE nick='Haggar'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Haggar'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 1, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 7576); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' 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'), + 1, 2, + (SELECT player FROM players WHERE nick='Chimera'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Chimera'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 5567); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Chimera'), + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 4361); +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'), + 1, 2, + (SELECT player FROM players WHERE nick='Alexxz'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Alexxz'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 5491); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Alexxz'), + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 6262); +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'), + 1, 2, + (SELECT player FROM players WHERE nick='Smiph'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Smiph'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6086); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Smiph'), + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 6603); +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'), + 1, 2, + (SELECT player FROM players WHERE nick='Duckling'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Duckling'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6327); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Duckling'), + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7596); +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'), + 1, 2, + (SELECT player FROM players WHERE nick='Pingo'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Pingo'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6255); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='Pingo'), + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7084); +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'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6772); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 8406); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' 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'), + 1, 3, + (SELECT player FROM players WHERE nick='Mickva'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Mickva'), + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 4465); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Mickva'), + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 4028); +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'), + 1, 3, + (SELECT player FROM players WHERE nick='Havok'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Havok'), + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 4920); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Havok'), + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 4843); +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'), + 1, 3, + (SELECT player FROM players WHERE nick='Felz'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Felz'), + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 5808); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Felz'), + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5815); +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'), + 1, 3, + (SELECT player FROM players WHERE nick='Mync'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Mync'), + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 5263); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Mync'), + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5942); +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'), + 1, 3, + (SELECT player FROM players WHERE nick='Gogo'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Gogo'), + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 6737); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Gogo'), + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6570); +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'), + 1, 3, + (SELECT player FROM players WHERE nick='Snute'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 7205); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 3, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6463); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' 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'), + 1, 4, + (SELECT player FROM players WHERE nick='Ingviild'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Ingviild'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Ingviild'), + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), + 'f', + 4881); +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'), + 1, 4, + (SELECT player FROM players WHERE nick='Ngan'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Ngan'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Ngan'), + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), + 'f', + 5443); +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'), + 1, 4, + (SELECT player FROM players WHERE nick='Cuivien'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Cuivien'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Cuivien'), + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), + 'f', + 6291); +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'), + 1, 4, + (SELECT player FROM players WHERE nick='Daniil'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Daniil'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Daniil'), + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), + 'f', + 6442); +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'), + 1, 4, + (SELECT player FROM players WHERE nick='Olemann'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Olemann'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='Olemann'), + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), + 'f', + 6436); +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'), + 1, 4, + (SELECT player FROM players WHERE nick='RiChY'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='RiChY'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 4, + (SELECT player FROM players WHERE nick='RiChY'), + (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), + 'f', + 6351); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' 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'), + 1, 5, + (SELECT player FROM players WHERE nick='Maxion'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Maxion'), + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 5747); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Maxion'), + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 6617); +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'), + 1, 5, + (SELECT player FROM players WHERE nick='Lindaninja'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Lindaninja'), + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 6165); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Lindaninja'), + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 6631); +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'), + 1, 5, + (SELECT player FROM players WHERE nick='Asphodel'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Asphodel'), + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 7341); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Asphodel'), + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 6061); +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'), + 1, 5, + (SELECT player FROM players WHERE nick='Cehtna'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Cehtna'), + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 7809); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Cehtna'), + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 7520); +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'), + 1, 5, + (SELECT player FROM players WHERE nick='T|na'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='T|na'), + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8235); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='T|na'), + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 7930); +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'), + 1, 5, + (SELECT player FROM players WHERE nick='Ylini'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Ylini'), + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8154); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='Ylini'), + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 7758); +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'), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8580); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8478); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=1; +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' 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'), + 1, 6, + (SELECT player FROM players WHERE nick='Athena'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Athena'), + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 'f', + 4975); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Athena'), + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 5292); +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'), + 1, 6, + (SELECT player FROM players WHERE nick='Andre'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Andre'), + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 'f', + 5503); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Andre'), + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 5618); +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'), + 1, 6, + (SELECT player FROM players WHERE nick='Marilla'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Marilla'), + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 'f', + 5338); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Marilla'), + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 5008); +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'), + 1, 6, + (SELECT player FROM players WHERE nick='Ozon'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Ozon'), + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 'f', + 6040); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Ozon'), + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 6589); +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'), + 1, 6, + (SELECT player FROM players WHERE nick='Haanz'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Haanz'), + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 'f', + 4809); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Haanz'), + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 6176); +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'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 'f', + 6040); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 8064); +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'), + 1, 6, + (SELECT player FROM players WHERE nick='Oliyzia'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Oliyzia'), + (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), + 'f', + 6274); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 1, 6, + (SELECT player FROM players WHERE nick='Oliyzia'), + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 7686); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=2; +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'), + 2, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 'f', + 8122); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 'f', + 7553); +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'), + 2, 1, + (SELECT player FROM players WHERE nick='Mync'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Mync'), + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 'f', + 7831); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Mync'), + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 'f', + 7442); +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'), + 2, 1, + (SELECT player FROM players WHERE nick='Haggar'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 'f', + 8742); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 'f', + 8478); +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'), + 2, 1, + (SELECT player FROM players WHERE nick='Daniil'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Daniil'), + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 'f', + 8218); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Daniil'), + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 'f', + 7626); +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'), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 'f', + 8734); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 'f', + 8640); +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'), + 2, 1, + (SELECT player FROM players WHERE nick='OJK'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 'f', + 8692); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 1, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 'f', + 7952); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=2; +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'), + 2, 2, + (SELECT player FROM players WHERE nick='Ozon'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Ozon'), + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 6062); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Ozon'), + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 6369); +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'), + 2, 2, + (SELECT player FROM players WHERE nick='RiChY'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='RiChY'), + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 6416); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='RiChY'), + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 6971); +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'), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 6535); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 6863); +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'), + 2, 2, + (SELECT player FROM players WHERE nick='T|na'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='T|na'), + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 6705); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='T|na'), + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 6938); +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'), + 2, 2, + (SELECT player FROM players WHERE nick='Nameless'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Nameless'), + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 6565); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Nameless'), + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 7037); +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'), + 2, 2, + (SELECT player FROM players WHERE nick='Olemann'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Olemann'), + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 6181); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 2, + (SELECT player FROM players WHERE nick='Olemann'), + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 6748); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=2; +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'), + 2, 3, + (SELECT player FROM players WHERE nick='Ylini'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Ylini'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Ylini'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8037); +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'), + 2, 3, + (SELECT player FROM players WHERE nick='Pingo'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Pingo'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Pingo'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8011); +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'), + 2, 3, + (SELECT player FROM players WHERE nick='Gogo'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Gogo'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Gogo'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8240); +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'), + 2, 3, + (SELECT player FROM players WHERE nick='Duckling'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Duckling'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Duckling'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8158); +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'), + 2, 3, + (SELECT player FROM players WHERE nick='Stream'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Stream'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='Stream'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 7795); +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'), + 2, 3, + (SELECT player FROM players WHERE nick='DufF'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='DufF'), + (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 ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 2, 3, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8658); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=3; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=3; +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'), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8665); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='Pingo'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Pingo'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8071); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8651); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='T|na'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='T|na'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 7787); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8492); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Gogo'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8267); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='Nameless'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Nameless'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8565); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8580); +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'), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8805); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=4; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=4; +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'), + 4, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Gogo'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6387); +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'), + 4, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6883); +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'), + 4, 0, + (SELECT player FROM players WHERE nick='Nameless'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Nameless'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6593); +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'), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6498); +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'), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6765); +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'), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6536); +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'), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6884); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=5; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=5; +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'), + 5, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='RiChY'), + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 7858); +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'), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 8682); +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'), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 8257); +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'), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 8741); +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'), + 5, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 5, 0, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 8403); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=6; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=6; +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'), + 6, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 8198); +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'), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 7744); +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'), + 6, 0, + (SELECT player FROM players WHERE nick='DufF'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 8365); +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'), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 8455); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=7; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=7; +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'), + 7, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 8550); +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'), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 8763); +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'), + 7, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 7, 0, + (SELECT player FROM players WHERE nick='Haggar'), + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 8516); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 8, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 8, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 8, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=8; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=8; +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'), + 8, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 8, 0, + (SELECT player FROM players WHERE nick='DufF'), + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), + 'f', + 6621); +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'), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), + 'f', + 6634); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=9; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=9; +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'), + 9, 0, + (SELECT player FROM players WHERE nick='Ylini'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0, + (SELECT player FROM players WHERE nick='Ylini'), + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5271); +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'), + 9, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5683); +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'), + 9, 0, + (SELECT player FROM players WHERE nick='T|na'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 9, 0, + (SELECT player FROM players WHERE nick='T|na'), + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5509); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 10, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 10, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 10, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=10; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND + round=10; +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'), + 10, 0, + (SELECT player FROM players WHERE nick='T|na'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 10, 0, + (SELECT player FROM players WHERE nick='T|na'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8343); +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'), + 10, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'), + 10, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8013); +commit;