X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fvarious-12.sql;fp=sql%2Fvarious%2Fvarious-12.sql;h=76c039d47e37cd1978bc04bf7f973bd6985cc151;hp=0000000000000000000000000000000000000000;hb=38489516a9ad620f3f5cf5a8e5f36117c579e922;hpb=7dfd3ff8c5e3fde12813a1e7b937e5816a027f7a diff --git a/sql/various/various-12.sql b/sql/various/various-12.sql new file mode 100644 index 0000000..76c039d --- /dev/null +++ b/sql/various/various-12.sql @@ -0,0 +1,2767 @@ +begin; +INSERT INTO tournaments + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='International' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 'European Tournament in London', + (SELECT country FROM countries WHERE countryname='Europe'), + 'Namco Station - London (United Kingdom)', + '2004-01-25', + (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, 'Lion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lion' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, + (SELECT player FROM players WHERE nick='Lion'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, + (SELECT player FROM players WHERE nick='Snute'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stelisevil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stelisevil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, + (SELECT player FROM players WHERE nick='Stelisevil'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, + (SELECT player FROM players WHERE nick='Tom'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Usagi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Usagi' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, + (SELECT player FROM players WHERE nick='Usagi'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, + (SELECT player FROM players WHERE nick='Oliyzia'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, + (SELECT player FROM players WHERE nick='DufF'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mintsauce 82' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mintsauce 82' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'S2K' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'S2K' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 9, + (SELECT player FROM players WHERE nick='S2K'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ryosuke' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ryosuke' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 10, + (SELECT player FROM players WHERE nick='Ryosuke'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Xai' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Xai' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 10, + (SELECT player FROM players WHERE nick='Xai'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Krisminime' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Krisminime' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 10, + (SELECT player FROM players WHERE nick='Krisminime'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 13, + (SELECT player FROM players WHERE nick='RiChY'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 13, + (SELECT player FROM players WHERE nick='Snofox'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Healingvizion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Healingvizion' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 13, + (SELECT player FROM players WHERE nick='Healingvizion'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afrojunglist' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afrojunglist' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 16, + (SELECT player FROM players WHERE nick='Afrojunglist'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jester' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jester' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 16, + (SELECT player FROM players WHERE nick='Jester'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matt' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matt' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 16, + (SELECT player FROM players WHERE nick='Matt'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 19, + (SELECT player FROM players WHERE nick='Havok'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 19, + (SELECT player FROM players WHERE nick='Smiph'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 19, + (SELECT player FROM players WHERE nick='Daniil'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afronova' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afronova' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 19, + (SELECT player FROM players WHERE nick='Afronova'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Albo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Albo' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 19, + (SELECT player FROM players WHERE nick='Albo'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tieguy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tieguy' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 19, + (SELECT player FROM players WHERE nick='Tieguy'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 25, + (SELECT player FROM players WHERE nick='Draconia'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 25, + (SELECT player FROM players WHERE nick='kjmcw'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Myst' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Myst' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 25, + (SELECT player FROM players WHERE nick='Myst'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Badbeat' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Badbeat' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 25, + (SELECT player FROM players WHERE nick='Badbeat'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 25, + (SELECT player FROM players WHERE nick='Ylini'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 30, + (SELECT player FROM players WHERE nick='Lejordet'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mecklar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mecklar' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 30, + (SELECT player FROM players WHERE nick='Mecklar'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'sd-koala' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'sd-koala' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 30, + (SELECT player FROM players WHERE nick='sd-koala'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'LLDJ' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'LLDJ' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 30, + (SELECT player FROM players WHERE nick='LLDJ'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Simon x' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Simon x' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 30, + (SELECT player FROM players WHERE nick='Simon x'), + NULL); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Fez' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Fez' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 30, + (SELECT player FROM players WHERE nick='Fez'), + NULL); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Mecklar'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Mecklar'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 5812); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Mecklar'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 5090); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Mecklar'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 6696); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Albo'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Albo'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 6746); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Albo'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 6572); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Albo'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8159); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7456); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 6981); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7781); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7624); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 8030); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8316); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 'f', + 7941); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 'f', + 8351); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), + 't', + 8137); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Fez'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Fez'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 5212); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Fez'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 4986); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Fez'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6177); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 6265); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6507); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Daniil'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8734); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Draconia'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Draconia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 5909); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Draconia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 5637); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Draconia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8204); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Ryosuke'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Ryosuke'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 8100); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Ryosuke'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6577); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Ryosuke'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8739); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 8073); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6299); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8312); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Xai'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Xai'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 'f', + 7338); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Xai'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), + 'f', + 6497); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 2, + (SELECT player FROM players WHERE nick='Xai'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8031); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Simon x'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Simon x'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 4726); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Simon x'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 3494); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Simon x'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 't', + 4588); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Ylini'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Ylini'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 6114); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Ylini'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 3894); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Ylini'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7132); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Matt'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Matt'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 7510); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Matt'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 6371); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Matt'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7497); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8189); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 6828); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7239); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Krisminime'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Krisminime'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8489); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Krisminime'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 7241); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Krisminime'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 7538); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Tieguy'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Tieguy'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 'f', + 8411); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Tieguy'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 6738); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 3, + (SELECT player FROM players WHERE nick='Tieguy'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Stomp')), + 't', + 5747); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='LLDJ'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='LLDJ'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 'f', + 0); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='LLDJ'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 5255); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='LLDJ'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 5255); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Havok'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 'f', + 6053); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Havok'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 6657); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Havok'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7880); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Snofox'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Snofox'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 'f', + 7073); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Snofox'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 7267); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Snofox'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7625); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Myst'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Myst'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 'f', + 7594); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Myst'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 7411); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Myst'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), + 't', + 4424); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 'f', + 7487); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 7909); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7606); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Usagi'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Usagi'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 'f', + 7909); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Usagi'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 7914); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 4, + (SELECT player FROM players WHERE nick='Usagi'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8612); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Lejordet'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Lejordet'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 0); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Lejordet'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 6235); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Lejordet'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), + 't', + 643); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Smiph'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Smiph'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 5727); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Smiph'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 6766); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Smiph'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7277); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='S2K'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='S2K'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 8103); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='S2K'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8057); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='S2K'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8291); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 0); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8134); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 7216); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Tom'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Tom'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 8162); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Tom'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8652); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Tom'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7719); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Stelisevil'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Stelisevil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 'f', + 7822); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Stelisevil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 'f', + 8940); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 5, + (SELECT player FROM players WHERE nick='Stelisevil'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 't', + 7645); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=1; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Afronova'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Afronova'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 5608); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Afronova'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5365); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Afronova'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 5365); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='sd-koala'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='sd-koala'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 5266); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='sd-koala'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5265); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='sd-koala'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), + 't', + 5916); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Jester'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Jester'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 6507); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Jester'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5595); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Jester'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8224); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Badbeat'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Badbeat'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 5929); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Badbeat'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5445); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Badbeat'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), + 't', + 6976); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 6985); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6731); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 7604); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Lion'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 7894); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6831); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 1, 6, + (SELECT player FROM players WHERE nick='Lion'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 't', + 8557); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Matt'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Matt'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 'f', + 6484); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Matt'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 4944); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Matt'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7575); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Stelisevil'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Stelisevil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 'f', + 6712); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Stelisevil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 6623); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Stelisevil'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8812); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 'f', + 6876); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 5416); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8766); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 'f', + 6349); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 5736); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='RiChY'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 7901); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 'f', + 6682); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 6476); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8828); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ryosuke'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ryosuke'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')), + 'f', + 6754); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ryosuke'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 6198); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 1, + (SELECT player FROM players WHERE nick='Ryosuke'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 8095); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Snofox'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Snofox'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), + 'f', + 6502); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Snofox'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8342); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Snofox'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), + 't', + 7948); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jester'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jester'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), + 'f', + 7193); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jester'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 7827); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Jester'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7707); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), + 'f', + 7703); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8483); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8028); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), + 'f', + 7735); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8569); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), + 't', + 7984); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Krisminime'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Krisminime'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), + 'f', + 7174); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Krisminime'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8485); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Krisminime'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8080); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Tom'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Tom'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), + 'f', + 7849); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Tom'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 'f', + 8678); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 2, + (SELECT player FROM players WHERE nick='Tom'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 't', + 8096); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=2; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=2; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8037); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), + 'f', + 6638); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Afrojunglist'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 't', + 7524); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Xai'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Xai'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8371); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Xai'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), + 'f', + 6604); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Xai'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8220); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 7976); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), + 'f', + 6666); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Healingvizion'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8253); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='S2K'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='S2K'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8540); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='S2K'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), + 'f', + 6508); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='S2K'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8577); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Lion'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8816); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), + 'f', + 6835); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Lion'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8602); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Usagi'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Usagi'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 'f', + 8691); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Usagi'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), + 'f', + 6905); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 2, 3, + (SELECT player FROM players WHERE nick='Usagi'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 8277); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=3; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=3; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7287); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8604); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='S2K'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='S2K'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7368); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='S2K'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7697); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7421); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Mintsauce 82'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8084); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7121); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8465); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7691); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 't', + 7974); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7520); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8709); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Tom'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Tom'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7764); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Tom'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8357); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 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='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8777); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lion'), + 9 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), + 'f', + 7797); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 3, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8609); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=4; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=4; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6386); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), + 't', + 8371); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6170); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 9039); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6493); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8551); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Tom'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Tom'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6379); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Tom'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8828); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6633); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8622); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lion'), + 6 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6793); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8620); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 6703); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 4, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 8741); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=5; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=5; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Tom'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Tom'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 7610); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Tom'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8346); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 7341); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Usagi'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8541); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 7869); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8481); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lion'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 7855); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 't', + 8697); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 7869); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 5, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8494); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=6; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=6; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Tom'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Tom'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 7805); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Tom'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8389); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8401); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8403); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8389); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 8791); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lion'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 7996); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 6, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8802); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=7; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=7; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), + 'f', + 5813); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8943); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), + 'f', + 5785); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8981); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')), + 'f', + 5949); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 7, 0, + (SELECT player FROM players WHERE nick='Stelisevil'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 8178); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, + 0, 0); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=8; +UPDATE rounds SET chosensongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND + round=8; +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lion'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 7490); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0, + (SELECT player FROM players WHERE nick='Lion'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 9425); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), + 'f', + 7363); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )), + 8, 0, + (SELECT player FROM players WHERE nick='Snute'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), + 't', + 8068); +commit;