From: Steinar H. Gunderson Date: Sat, 5 Mar 2005 02:59:39 +0000 (+0000) Subject: Added CC04-8 data. X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=436f02fda8edf060483e54423f6e61652303341e Added CC04-8 data. --- diff --git a/sql/cc04/cc8-04.sql b/sql/cc04/cc8-04.sql new file mode 100644 index 0000000..6d26165 --- /dev/null +++ b/sql/cc04/cc8-04.sql @@ -0,0 +1,3202 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'), + 'Challenge Cup 8', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Bowling 1 Lillehammer', + '2004-12-19', + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, + (SELECT player FROM players WHERE nick='Snute'), + 100); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, + (SELECT player FROM players WHERE nick='Haggar'), + 90); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, + (SELECT player FROM players WHERE nick='DufF'), + 81); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, + (SELECT player FROM players WHERE nick='OJK'), + 73); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, + (SELECT player FROM players WHERE nick='RiChY'), + 66); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, + (SELECT player FROM players WHERE nick='Gogo'), + 60); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, + (SELECT player FROM players WHERE nick='Oliyzia'), + 55); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, + (SELECT player FROM players WHERE nick='Pingo'), + 51); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 9, + (SELECT player FROM players WHERE nick='Nameless'), + 48); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 10, + (SELECT player FROM players WHERE nick='Haanz'), + 46); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 11, + (SELECT player FROM players WHERE nick='Bonzo'), + 45); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 12, + (SELECT player FROM players WHERE nick='Olemann'), + 44); +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 tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 13, + (SELECT player FROM players WHERE nick='T|na'), + 43); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 14, + (SELECT player FROM players WHERE nick='Daniil'), + 42); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 15, + (SELECT player FROM players WHERE nick='Ylini'), + 41); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 16, + (SELECT player FROM players WHERE nick='Stream'), + 40); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 17, + (SELECT player FROM players WHERE nick='Cuivien'), + 39); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 18, + (SELECT player FROM players WHERE nick='Ozon'), + 38); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zredna' AS nick WHERE 'Zredna' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 19, + (SELECT player FROM players WHERE nick='Zredna'), + 37); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 20, + (SELECT player FROM players WHERE nick='Andeplane'), + 36); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 21, + (SELECT player FROM players WHERE nick='Pyro'), + 35); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 22, + (SELECT player FROM players WHERE nick='Smiph'), + 34); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nuust' AS nick WHERE 'Nuust' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 23, + (SELECT player FROM players WHERE nick='Nuust'), + 33); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 24, + (SELECT player FROM players WHERE nick='Alexxz'), + 32); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick WHERE 'Sesse' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 25, + (SELECT player FROM players WHERE nick='Sesse'), + 31); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Master' AS nick WHERE 'Master' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 26, + (SELECT player FROM players WHERE nick='Master'), + 30); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 27, + (SELECT player FROM players WHERE nick='Draconia'), + 29); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 28, + (SELECT player FROM players WHERE nick='Felz'), + 28); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 29, + (SELECT player FROM players WHERE nick='Mync'), + 27); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 30, + (SELECT player FROM players WHERE nick='Duckling'), + 26); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 31, + (SELECT player FROM players WHERE nick='Guru'), + 25); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 32, + (SELECT player FROM players WHERE nick='Montana'), + 24); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 33, + (SELECT player FROM players WHERE nick='Ngan'), + 23); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 34, + (SELECT player FROM players WHERE nick='JonAnders'), + 22); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Evil Ed' AS nick WHERE 'Evil Ed' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 35, + (SELECT player FROM players WHERE nick='Evil Ed'), + 21); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 36, + (SELECT player FROM players WHERE nick='Hyper'), + 20); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 37, + (SELECT player FROM players WHERE nick='Goku'), + 19); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 38, + (SELECT player FROM players WHERE nick='Zackie'), + 18); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 39, + (SELECT player FROM players WHERE nick='Cehtna'), + 17); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 40, + (SELECT player FROM players WHERE nick='Indy'), + 16); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 41, + (SELECT player FROM players WHERE nick='v|per'), + 15); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 42, + (SELECT player FROM players WHERE nick='Glock'), + 14); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 43, + (SELECT player FROM players WHERE nick='Athena'), + 13); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 44, + (SELECT player FROM players WHERE nick='Eruanna'), + 12); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Master'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Master'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 'f', + 6619); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Master'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 'f', + 6488); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Master'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8270); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Pyro'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Pyro'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 'f', + 6738); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Pyro'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 'f', + 6660); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Pyro'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8308); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Cehtna'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Cehtna'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 'f', + 6734); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Cehtna'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 'f', + 6369); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Cehtna'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7694); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Duckling'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Duckling'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 'f', + 6624); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Duckling'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 'f', + 6356); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Duckling'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8093); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Ylini'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Ylini'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 'f', + 6706); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Ylini'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 'f', + 6719); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Ylini'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8059); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), + 'f', + 6929); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 'f', + 6937); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 7756); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Nuust'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Nuust'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7237); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Nuust'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 6727); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Nuust'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8453); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Ngan'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Ngan'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 6593); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Ngan'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 5471); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Ngan'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7571); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Hyper'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Hyper'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 6264); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Hyper'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 4876); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Hyper'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8320); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Olemann'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Olemann'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7945); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Olemann'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 6385); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Olemann'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8507); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7963); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 6734); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8396); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 8388); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 7354); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 8694); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Living in America')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Evil Ed'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Evil Ed'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), + 'f', + 4609); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Evil Ed'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), + 'f', + 5827); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Evil Ed'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7355); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='v|per'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='v|per'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), + 'f', + 5134); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='v|per'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), + 'f', + 5276); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='v|per'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6718); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Cuivien'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Cuivien'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), + 'f', + 6247); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Cuivien'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), + 'f', + 6328); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Cuivien'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8542); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Smiph'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Smiph'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), + 'f', + 5687); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Smiph'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), + 'f', + 6207); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Smiph'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8572); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Stream'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Stream'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), + 'f', + 6308); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Stream'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), + 'f', + 6567); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='Stream'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7994); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='OJK'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), + 'f', + 6623); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), + 'f', + 7128); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 3, + (SELECT player FROM players WHERE nick='OJK'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), + 't', + 7554); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Sesse'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Sesse'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 7636); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Sesse'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8428); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Sesse'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8406); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zredna'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zredna'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 8003); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zredna'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8158); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zredna'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8519); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zackie'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zackie'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 5276); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zackie'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 6514); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Zackie'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7845); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Athena'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Athena'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 4802); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Athena'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 5373); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Athena'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7489); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Mync'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Mync'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 7202); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Mync'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8496); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Mync'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8554); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Pingo'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Pingo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 7483); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Pingo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8679); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Pingo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8809); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Haggar'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 'f', + 8321); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8881); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 4, + (SELECT player FROM players WHERE nick='Haggar'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 't', + 8616); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Haanz'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Haanz'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 'f', + 5470); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Haanz'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 6054); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Haanz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8663); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Guru'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Guru'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 'f', + 5347); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Guru'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 5650); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Guru'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8047); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Goku'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Goku'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 'f', + 4947); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Goku'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 5990); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Goku'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 7891); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Eruanna'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Eruanna'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 'f', + 4600); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Eruanna'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 4726); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Eruanna'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7537); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Draconia'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 'f', + 5210); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Draconia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 6351); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Draconia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8180); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Bonzo'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Bonzo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 'f', + 6101); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Bonzo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 6778); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='Bonzo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 8466); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='RiChY'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 'f', + 5487); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 6818); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 5, + (SELECT player FROM players WHERE nick='RiChY'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8107); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Glock'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Glock'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 6054); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Glock'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), + 'f', + 5164); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Glock'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6318); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='JonAnders'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='JonAnders'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 6545); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='JonAnders'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), + 'f', + 5614); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='JonAnders'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7394); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Andeplane'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Andeplane'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 7156); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Andeplane'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), + 'f', + 7261); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Andeplane'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8533); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Alexxz'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Alexxz'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 6690); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Alexxz'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), + 'f', + 7365); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Alexxz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8441); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Gogo'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Gogo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 7458); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Gogo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), + 'f', + 7554); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Gogo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8774); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 7729); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), + 'f', + 7620); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 6, + (SELECT player FROM players WHERE nick='Nameless'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 8501); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Indy'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Indy'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 5526); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Indy'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), + 'f', + 5459); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Indy'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7379); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Montana'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Montana'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 7483); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Montana'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), + 'f', + 5227); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Montana'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7768); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Felz'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Felz'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 7800); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Felz'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), + 'f', + 6311); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Felz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 7844); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Ozon'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Ozon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 8006); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Ozon'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), + 'f', + 6209); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Ozon'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8510); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='T|na'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='T|na'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 7910); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), + 'f', + 6828); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='T|na'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8627); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Oliyzia'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 'f', + 8463); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), + 'f', + 7025); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 1, 7, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 't', + 8691); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Stream'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Stream'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8235); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Stream'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 8241); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Stream'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8621); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8508); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 7030); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Andeplane'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8358); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Haanz'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Haanz'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8551); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Haanz'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 7999); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Haanz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8787); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8803); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 7817); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8543); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Gogo'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Gogo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8780); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Gogo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 8316); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Gogo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8748); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Nameless'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Nameless'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8852); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Nameless'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 8327); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Nameless'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8728); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Oliyzia'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8694); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 8286); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 1, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8660); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Ylini'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Ylini'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 'f', + 6347); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Ylini'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 7766); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Ylini'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8344); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Zredna'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Zredna'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 'f', + 6316); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Zredna'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 7166); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Zredna'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8524); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 'f', + 6795); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 8776); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Snute'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 't', + 8850); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Cuivien'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Cuivien'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 'f', + 5902); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Cuivien'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 7552); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Cuivien'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8584); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Pingo'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Pingo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 'f', + 6269); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Pingo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 8408); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Pingo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8717); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Bonzo'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Bonzo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 'f', + 6430); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Bonzo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 8157); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='Bonzo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8766); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')), + 'f', + 6782); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 'f', + 8742); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8500); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (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 tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Olemann'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Olemann'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6347); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Olemann'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8358); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Olemann'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8516); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Ozon'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Ozon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6261); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Ozon'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8225); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Ozon'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8294); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='RiChY'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6218); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8663); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='RiChY'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8760); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Daniil'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6085); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Daniil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8491); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Daniil'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8550); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='OJK'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6508); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8698); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='OJK'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8630); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Pyro'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Pyro'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 5161); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Pyro'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8179); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Pyro'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8147); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Haggar'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6617); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8732); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 2, 3, + (SELECT player FROM players WHERE nick='Haggar'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8332); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=3; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=3; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 6085); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8615); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Pingo'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Pingo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 5663); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Pingo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8664); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 6167); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8697); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 6571); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8537); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 6545); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 't', + 8520); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 5880); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8851); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 6434); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8770); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 6697); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 8887); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Nameless'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Nameless'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 5690); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 3, 0, + (SELECT player FROM players WHERE nick='Nameless'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8608); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=4; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=4; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 6599); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8377); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 7122); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Gogo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8309); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 7322); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8639); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 7369); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8574); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 7541); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), + 't', + 8823); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 7100); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), + 't', + 8450); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), + 'f', + 7766); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8673); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=5; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=5; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8648); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8629); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8829); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8556); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8463); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8313); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8498); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8793); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8909); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8934); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=6; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8669); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 8951); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8729); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 9424); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='DufF'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8588); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 9179); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8654); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 9826); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=7; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=7; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 7559); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8751); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 7562); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8834); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 7506); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8918); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=8; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + round=8; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), + 'f', + 5582); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0, + (SELECT player FROM players WHERE nick='Haggar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8826); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), + 'f', + 5915); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8891); +commit; diff --git a/sql/cc04/update-cc04.sh b/sql/cc04/update-cc04.sh index d1902bb..231f3a8 100755 --- a/sql/cc04/update-cc04.sh +++ b/sql/cc04/update-cc04.sh @@ -16,4 +16,5 @@ SEASON="Challenge Cup 2004" 5 39 6 40 7 41 +8 42 EOF