X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fvarious-10.sql;fp=sql%2Fvarious%2Fvarious-10.sql;h=d52775562bb62d603844a1ac026862f7b10d874f;hp=0000000000000000000000000000000000000000;hb=38489516a9ad620f3f5cf5a8e5f36117c579e922;hpb=7dfd3ff8c5e3fde12813a1e7b937e5816a027f7a diff --git a/sql/various/various-10.sql b/sql/various/various-10.sql new file mode 100644 index 0000000..d527755 --- /dev/null +++ b/sql/various/various-10.sql @@ -0,0 +1,1611 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Geneva Tournament' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 'Geneva Tournament IV (score)', + (SELECT country FROM countries WHERE countryname='Switzerland'), + 'Las Vegas - Switzerland', + '2004-06-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, 'Dex' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dex' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, + (SELECT player FROM players WHERE nick='Dex'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lord Glenn' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lord Glenn' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, + (SELECT player FROM players WHERE nick='Lord Glenn'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'F Destroyer' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'F Destroyer' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, + (SELECT player FROM players WHERE nick='F Destroyer'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Boli' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Boli' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, + (SELECT player FROM players WHERE nick='Boli'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Shiniji' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Shiniji' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, + (SELECT player FROM players WHERE nick='Shiniji'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T Master' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T Master' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, + (SELECT player FROM players WHERE nick='T Master'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Loopy Chew' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Loopy Chew' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, + (SELECT player FROM players WHERE nick='Loopy Chew'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Simon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Simon' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, + (SELECT player FROM players WHERE nick='Simon'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jucelin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jucelin' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 9, + (SELECT player FROM players WHERE nick='Jucelin'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jose' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jose' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 10, + (SELECT player FROM players WHERE nick='Jose'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kyo X' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kyo X' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 11, + (SELECT player FROM players WHERE nick='Kyo X'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hirro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hirro' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 12, + (SELECT player FROM players WHERE nick='Hirro'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ganon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ganon' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 13, + (SELECT player FROM players WHERE nick='Ganon'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Red Baron' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Red Baron' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 14, + (SELECT player FROM players WHERE nick='Red Baron'), + NULL); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6467); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Simon'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Simon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 5814); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6548); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='T Master'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='T Master'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 5333); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Red Baron'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Red Baron'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 0); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Kyo X'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Kyo X'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 4883); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Hirro'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Hirro'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 1937); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Ganon'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Ganon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 1805); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6635); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Jucelin'), + 10 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Jucelin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 5763); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Dex'), + 11 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6154); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Boli'), + 12 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Boli'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6692); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Jose'), + 13 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Jose'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 4578); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 14 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 1, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 5423); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ganon'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ganon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 2133); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ganon'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 1313); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ganon'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), + 't', + 2760); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 7289); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 7959); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 7916); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Kyo X'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Kyo X'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 5173); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Kyo X'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 1647); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Kyo X'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7027); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Jucelin'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Jucelin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 5309); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Jucelin'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 7053); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Jucelin'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7743); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Shiniji'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Shiniji'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 7175); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Shiniji'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 7606); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Shiniji'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8223); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 8077); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 8732); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 't', + 7850); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Dex'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 8825); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Dex'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 8549); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 1, + (SELECT player FROM players WHERE nick='Dex'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8841); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Red Baron'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Red Baron'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 1095); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Red Baron'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 0); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Red Baron'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 5630); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Hirro'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Hirro'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 1114); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Hirro'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 4290); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Hirro'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), + 't', + 3930); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jose'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jose'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 4448); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jose'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 4271); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jose'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 5624); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='T Master'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='T Master'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 6108); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='T Master'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 5661); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='T Master'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 7031); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Simon'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Simon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 1221); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Simon'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 4833); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Simon'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6110); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='F Destroyer'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='F Destroyer'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 7794); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='F Destroyer'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 6615); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='F Destroyer'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8255); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Boli'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Boli'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), + 'f', + 6977); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Boli'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 6550); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 2, 2, + (SELECT player FROM players WHERE nick='Boli'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6727); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=3; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=3; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Jucelin'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Jucelin'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 957); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Jucelin'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7049); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Simon'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Simon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 3613); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Simon'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6407); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 5188); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8209); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Jose'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Jose'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 798); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Jose'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 0); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 7625); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7814); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='T Master'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='T Master'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 4090); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='T Master'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 6541); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 8154); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 't', + 8441); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Boli'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Boli'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 6683); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Boli'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7925); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Dex'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 8563); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='Dex'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8822); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 10 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 7779); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 3, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8306); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=4; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=4; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Simon'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Simon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 4225); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Simon'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6709); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='T Master'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='T Master'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5128); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='T Master'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7882); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5433); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 7288); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Boli'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Boli'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5521); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Boli'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7879); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5299); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Loopy Chew'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 7137); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5652); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8575); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5742); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8712); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Dex'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5855); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 4, 0, + (SELECT player FROM players WHERE nick='Dex'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8675); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=5; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=5; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), + 'f', + 6389); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Shiniji'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7837); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='T Master'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='T Master'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), + 'f', + 5778); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='T Master'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6995); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Boli'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Boli'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), + 'f', + 6229); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Boli'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8336); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), + 'f', + 6420); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 9032); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), + 'f', + 6293); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8638); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Dex'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')), + 'f', + 6640); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 5, 0, + (SELECT player FROM players WHERE nick='Dex'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8893); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=6; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=6; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Boli'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Boli'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7152); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Boli'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 7701); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7663); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8712); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7352); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8593); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Dex'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7844); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 6, 0, + (SELECT player FROM players WHERE nick='Dex'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 9086); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=7; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=7; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8323); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='F Destroyer'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 't', + 8356); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8663); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 't', + 8146); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='Dex'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8782); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 7, 0, + (SELECT player FROM players WHERE nick='Dex'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8798); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=8; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND + round=8; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6319); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lord Glenn'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8634); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0, + (SELECT player FROM players WHERE nick='Dex'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0, + (SELECT player FROM players WHERE nick='Dex'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), + 'f', + 6578); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )), + 8, 0, + (SELECT player FROM players WHERE nick='Dex'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8848); +commit;