X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc8-04.sql;h=778f5e7e7d4ac21223093352a5c72d9cf91bcf12;hp=6d26165e3ec5987e972b574af16fbe6a1ed07aeb;hb=69e91c419df45838d7c85633b10d0998f0f92f7a;hpb=9f7b3c1a46383496e6a30e0aad8d4252e1a94fda diff --git a/sql/cc04/cc8-04.sql b/sql/cc04/cc8-04.sql index 6d26165..778f5e7 100644 --- a/sql/cc04/cc8-04.sql +++ b/sql/cc04/cc8-04.sql @@ -1,7 +1,7 @@ begin; INSERT INTO tournaments (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( - (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'), + (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 'Challenge Cup 8', (SELECT country FROM countries WHERE countryname='Norway'), 'Bowling 1 Lillehammer', @@ -9,302 +9,302 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, (SELECT player FROM players WHERE nick='Snute'), 100); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, (SELECT player FROM players WHERE nick='Haggar'), 90); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, (SELECT player FROM players WHERE nick='DufF'), 81); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, (SELECT player FROM players WHERE nick='OJK'), 73); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, (SELECT player FROM players WHERE nick='RiChY'), 66); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, (SELECT player FROM players WHERE nick='Gogo'), 60); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, (SELECT player FROM players WHERE nick='Oliyzia'), 55); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, (SELECT player FROM players WHERE nick='Pingo'), 51); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 9, (SELECT player FROM players WHERE nick='Nameless'), 48); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haanz' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 10, (SELECT player FROM players WHERE nick='Haanz'), 46); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 11, (SELECT player FROM players WHERE nick='Bonzo'), 45); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 12, (SELECT player FROM players WHERE nick='Olemann'), 44); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 13, (SELECT player FROM players WHERE nick='T|na'), 43); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 14, (SELECT player FROM players WHERE nick='Daniil'), 42); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 15, (SELECT player FROM players WHERE nick='Ylini'), 41); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 16, (SELECT player FROM players WHERE nick='Stream'), 40); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cuivien' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 17, (SELECT player FROM players WHERE nick='Cuivien'), 39); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ozon' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 18, (SELECT player FROM players WHERE nick='Ozon'), 38); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zredna' AS nick WHERE 'Zredna' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zredna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zredna' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 19, (SELECT player FROM players WHERE nick='Zredna'), 37); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Andeplane' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 20, (SELECT player FROM players WHERE nick='Andeplane'), 36); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pyro' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 21, (SELECT player FROM players WHERE nick='Pyro'), 35); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 22, (SELECT player FROM players WHERE nick='Smiph'), 34); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nuust' AS nick WHERE 'Nuust' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nuust' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nuust' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 23, (SELECT player FROM players WHERE nick='Nuust'), 33); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Alexxz' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 24, (SELECT player FROM players WHERE nick='Alexxz'), 32); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick WHERE 'Sesse' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sesse' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 25, (SELECT player FROM players WHERE nick='Sesse'), 31); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Master' AS nick WHERE 'Master' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Master' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Master' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 26, (SELECT player FROM players WHERE nick='Master'), 30); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); +INSERT INTO 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='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 27, (SELECT player FROM players WHERE nick='Draconia'), 29); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Felz' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 28, (SELECT player FROM players WHERE nick='Felz'), 28); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mync' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 29, (SELECT player FROM players WHERE nick='Mync'), 27); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 30, (SELECT player FROM players WHERE nick='Duckling'), 26); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Guru' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 31, (SELECT player FROM players WHERE nick='Guru'), 25); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Montana' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 32, (SELECT player FROM players WHERE nick='Montana'), 24); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ngan' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 33, (SELECT player FROM players WHERE nick='Ngan'), 23); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'JonAnders' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 34, (SELECT player FROM players WHERE nick='JonAnders'), 22); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Evil Ed' AS nick WHERE 'Evil Ed' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Evil Ed' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Evil Ed' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 35, (SELECT player FROM players WHERE nick='Evil Ed'), 21); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hyper' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 36, (SELECT player FROM players WHERE nick='Hyper'), 20); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Goku' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 37, (SELECT player FROM players WHERE nick='Goku'), 19); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zackie' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 38, (SELECT player FROM players WHERE nick='Zackie'), 18); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cehtna' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 39, (SELECT player FROM players WHERE nick='Cehtna'), 17); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 40, (SELECT player FROM players WHERE nick='Indy'), 16); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'v|per' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 41, (SELECT player FROM players WHERE nick='v|per'), 15); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Glock' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 42, (SELECT player FROM players WHERE nick='Glock'), 14); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Athena' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 43, (SELECT player FROM players WHERE nick='Athena'), 13); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eruanna' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 44, (SELECT player FROM players WHERE nick='Eruanna'), 12); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Master'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Master'), 0, @@ -312,7 +312,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6619); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Master'), 1, @@ -320,7 +320,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6488); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Master'), 2, @@ -328,13 +328,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8270); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), 0, @@ -342,7 +342,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6738); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), 1, @@ -350,7 +350,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6660); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), 2, @@ -358,13 +358,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8308); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Cehtna'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Cehtna'), 0, @@ -372,7 +372,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6734); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Cehtna'), 1, @@ -380,7 +380,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6369); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Cehtna'), 2, @@ -388,13 +388,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7694); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Duckling'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Duckling'), 0, @@ -402,7 +402,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6624); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Duckling'), 1, @@ -410,7 +410,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6356); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Duckling'), 2, @@ -418,13 +418,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8093); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -432,7 +432,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6706); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -440,7 +440,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6719); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -448,13 +448,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8059); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -462,7 +462,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6929); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -470,7 +470,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6937); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -478,32 +478,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7756); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Nuust'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Nuust'), 0, @@ -511,7 +511,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7237); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Nuust'), 1, @@ -519,7 +519,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6727); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Nuust'), 2, @@ -527,13 +527,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8453); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Ngan'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Ngan'), 0, @@ -541,7 +541,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6593); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Ngan'), 1, @@ -549,7 +549,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5471); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Ngan'), 2, @@ -557,13 +557,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7571); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Hyper'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Hyper'), 0, @@ -571,7 +571,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6264); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Hyper'), 1, @@ -579,7 +579,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4876); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Hyper'), 2, @@ -587,13 +587,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8320); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -601,7 +601,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7945); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -609,7 +609,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6385); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -617,13 +617,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8507); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Daniil'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Daniil'), 0, @@ -631,7 +631,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7963); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Daniil'), 1, @@ -639,7 +639,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6734); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Daniil'), 2, @@ -647,13 +647,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8396); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -661,7 +661,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8388); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -669,7 +669,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7354); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -677,32 +677,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8694); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('Stomp')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Evil Ed'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Evil Ed'), 0, @@ -710,7 +710,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4609); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Evil Ed'), 1, @@ -718,7 +718,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5827); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Evil Ed'), 2, @@ -726,13 +726,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7355); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='v|per'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='v|per'), 0, @@ -740,7 +740,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5134); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='v|per'), 1, @@ -748,7 +748,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5276); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='v|per'), 2, @@ -756,13 +756,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6718); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Cuivien'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Cuivien'), 0, @@ -770,7 +770,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6247); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Cuivien'), 1, @@ -778,7 +778,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6328); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Cuivien'), 2, @@ -786,13 +786,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8542); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Smiph'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Smiph'), 0, @@ -800,7 +800,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5687); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Smiph'), 1, @@ -808,7 +808,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6207); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Smiph'), 2, @@ -816,13 +816,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8572); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Stream'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -830,7 +830,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6308); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -838,7 +838,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6567); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -846,13 +846,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7994); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -860,7 +860,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6623); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -868,7 +868,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7128); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -876,32 +876,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7554); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Sesse'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Sesse'), 0, @@ -909,7 +909,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7636); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Sesse'), 1, @@ -917,7 +917,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8428); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Sesse'), 2, @@ -925,13 +925,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8406); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zredna'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zredna'), 0, @@ -939,7 +939,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8003); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zredna'), 1, @@ -947,7 +947,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8158); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zredna'), 2, @@ -955,13 +955,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8519); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zackie'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zackie'), 0, @@ -969,7 +969,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5276); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zackie'), 1, @@ -977,7 +977,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6514); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Zackie'), 2, @@ -985,13 +985,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7845); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Athena'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Athena'), 0, @@ -999,7 +999,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4802); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Athena'), 1, @@ -1007,7 +1007,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5373); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Athena'), 2, @@ -1015,13 +1015,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7489); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mync'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mync'), 0, @@ -1029,7 +1029,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7202); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mync'), 1, @@ -1037,7 +1037,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8496); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Mync'), 2, @@ -1045,13 +1045,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8554); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Pingo'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Pingo'), 0, @@ -1059,7 +1059,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7483); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Pingo'), 1, @@ -1067,7 +1067,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8679); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Pingo'), 2, @@ -1075,13 +1075,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8809); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -1089,7 +1089,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8321); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -1097,7 +1097,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8881); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), 2, @@ -1105,32 +1105,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8616); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Haanz'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Haanz'), 0, @@ -1138,7 +1138,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5470); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Haanz'), 1, @@ -1146,7 +1146,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6054); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Haanz'), 2, @@ -1154,13 +1154,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8663); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Guru'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Guru'), 0, @@ -1168,7 +1168,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5347); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Guru'), 1, @@ -1176,7 +1176,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5650); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Guru'), 2, @@ -1184,13 +1184,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8047); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Goku'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Goku'), 0, @@ -1198,7 +1198,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4947); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Goku'), 1, @@ -1206,7 +1206,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5990); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Goku'), 2, @@ -1214,13 +1214,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7891); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 0, @@ -1228,7 +1228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4600); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 1, @@ -1236,7 +1236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4726); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Eruanna'), 2, @@ -1244,13 +1244,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7537); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 0, @@ -1258,7 +1258,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5210); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 1, @@ -1266,7 +1266,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6351); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 2, @@ -1274,13 +1274,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8180); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 0, @@ -1288,7 +1288,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6101); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 1, @@ -1296,7 +1296,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6778); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='Bonzo'), 2, @@ -1304,13 +1304,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8466); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -1318,7 +1318,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5487); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -1326,7 +1326,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6818); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -1334,32 +1334,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8107); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Glock'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Glock'), 0, @@ -1367,7 +1367,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6054); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Glock'), 1, @@ -1375,7 +1375,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5164); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Glock'), 2, @@ -1383,13 +1383,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6318); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='JonAnders'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='JonAnders'), 0, @@ -1397,7 +1397,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6545); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='JonAnders'), 1, @@ -1405,7 +1405,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5614); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='JonAnders'), 2, @@ -1413,13 +1413,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7394); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Andeplane'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Andeplane'), 0, @@ -1427,7 +1427,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7156); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Andeplane'), 1, @@ -1435,7 +1435,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7261); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Andeplane'), 2, @@ -1443,13 +1443,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8533); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Alexxz'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Alexxz'), 0, @@ -1457,7 +1457,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6690); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Alexxz'), 1, @@ -1465,7 +1465,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7365); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Alexxz'), 2, @@ -1473,13 +1473,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8441); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gogo'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gogo'), 0, @@ -1487,7 +1487,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7458); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gogo'), 1, @@ -1495,7 +1495,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7554); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Gogo'), 2, @@ -1503,13 +1503,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8774); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -1517,7 +1517,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7729); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -1525,7 +1525,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7620); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 6, (SELECT player FROM players WHERE nick='Nameless'), 2, @@ -1533,32 +1533,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8501); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Indy'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Indy'), 0, @@ -1566,7 +1566,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5526); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Indy'), 1, @@ -1574,7 +1574,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5459); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Indy'), 2, @@ -1582,13 +1582,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7379); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Montana'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Montana'), 0, @@ -1596,7 +1596,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7483); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Montana'), 1, @@ -1604,7 +1604,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5227); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Montana'), 2, @@ -1612,13 +1612,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7768); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Felz'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Felz'), 0, @@ -1626,7 +1626,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7800); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Felz'), 1, @@ -1634,7 +1634,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6311); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Felz'), 2, @@ -1642,13 +1642,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7844); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Ozon'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Ozon'), 0, @@ -1656,7 +1656,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8006); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Ozon'), 1, @@ -1664,7 +1664,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6209); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Ozon'), 2, @@ -1672,13 +1672,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8510); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='T|na'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1686,7 +1686,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7910); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1694,7 +1694,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6828); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -1702,13 +1702,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8627); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Oliyzia'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -1716,7 +1716,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8463); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -1724,7 +1724,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7025); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 7, (SELECT player FROM players WHERE nick='Oliyzia'), 2, @@ -1733,36 +1733,36 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8691); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Stream'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -1770,7 +1770,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8235); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -1778,7 +1778,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8241); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -1786,13 +1786,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8621); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Andeplane'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Andeplane'), 0, @@ -1800,7 +1800,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8508); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Andeplane'), 1, @@ -1808,7 +1808,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7030); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Andeplane'), 2, @@ -1816,13 +1816,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8358); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Haanz'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Haanz'), 0, @@ -1830,7 +1830,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8551); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Haanz'), 1, @@ -1838,7 +1838,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7999); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Haanz'), 2, @@ -1846,13 +1846,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8787); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1860,7 +1860,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8803); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1868,7 +1868,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7817); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -1876,13 +1876,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8543); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), 0, @@ -1890,7 +1890,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8780); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), 1, @@ -1898,7 +1898,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8316); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), 2, @@ -1906,13 +1906,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8748); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Nameless'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -1920,7 +1920,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8852); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -1928,7 +1928,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8327); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Nameless'), 2, @@ -1936,13 +1936,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8728); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -1950,7 +1950,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8694); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -1958,7 +1958,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8286); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 1, (SELECT player FROM players WHERE nick='Oliyzia'), 2, @@ -1966,32 +1966,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8660); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -1999,7 +1999,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6347); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -2007,7 +2007,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7766); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -2015,13 +2015,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8344); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Zredna'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Zredna'), 0, @@ -2029,7 +2029,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6316); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Zredna'), 1, @@ -2037,7 +2037,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7166); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Zredna'), 2, @@ -2045,13 +2045,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8524); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Snute'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2059,7 +2059,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6795); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2067,7 +2067,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8776); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -2075,13 +2075,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8850); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Cuivien'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Cuivien'), 0, @@ -2089,7 +2089,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5902); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Cuivien'), 1, @@ -2097,7 +2097,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7552); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Cuivien'), 2, @@ -2105,13 +2105,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8584); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Pingo'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Pingo'), 0, @@ -2119,7 +2119,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6269); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Pingo'), 1, @@ -2127,7 +2127,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8408); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Pingo'), 2, @@ -2135,13 +2135,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8717); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Bonzo'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Bonzo'), 0, @@ -2149,7 +2149,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6430); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Bonzo'), 1, @@ -2157,7 +2157,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8157); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='Bonzo'), 2, @@ -2165,13 +2165,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8766); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2179,7 +2179,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6782); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2187,7 +2187,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8742); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -2195,32 +2195,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8500); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -2228,7 +2228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6347); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -2236,7 +2236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8358); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -2244,13 +2244,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8516); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ozon'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ozon'), 0, @@ -2258,7 +2258,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6261); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ozon'), 1, @@ -2266,7 +2266,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8225); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Ozon'), 2, @@ -2274,13 +2274,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8294); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2288,7 +2288,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6218); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2296,7 +2296,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8663); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -2304,13 +2304,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8760); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Daniil'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Daniil'), 0, @@ -2318,7 +2318,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6085); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Daniil'), 1, @@ -2326,7 +2326,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8491); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Daniil'), 2, @@ -2334,13 +2334,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8550); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='OJK'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -2348,7 +2348,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6508); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -2356,7 +2356,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8698); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -2364,13 +2364,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8630); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pyro'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pyro'), 0, @@ -2378,7 +2378,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5161); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pyro'), 1, @@ -2386,7 +2386,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8179); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Pyro'), 2, @@ -2394,13 +2394,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8147); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2408,7 +2408,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6617); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2416,7 +2416,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8732); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 2, @@ -2425,31 +2425,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8332); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('D2R')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=3; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=3; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -2457,7 +2457,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6085); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -2465,13 +2465,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8615); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), 0, @@ -2479,7 +2479,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5663); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Pingo'), 1, @@ -2487,13 +2487,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8664); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2501,7 +2501,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6167); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2509,13 +2509,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8697); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2523,7 +2523,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6571); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2531,13 +2531,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8537); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2545,7 +2545,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6545); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2553,13 +2553,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8520); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Gogo'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Gogo'), 0, @@ -2567,7 +2567,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5880); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Gogo'), 1, @@ -2575,13 +2575,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8851); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -2589,7 +2589,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6434); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -2597,13 +2597,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8770); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2611,7 +2611,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6697); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2619,13 +2619,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8887); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), 9 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), 0, @@ -2633,7 +2633,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5690); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), 1, @@ -2642,31 +2642,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8608); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=4; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=4; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, @@ -2674,7 +2674,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6599); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, @@ -2682,13 +2682,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8377); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Gogo'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Gogo'), 0, @@ -2696,7 +2696,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7122); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Gogo'), 1, @@ -2704,13 +2704,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8309); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2718,7 +2718,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7322); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2726,13 +2726,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8639); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2740,7 +2740,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7369); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2748,13 +2748,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8574); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2762,7 +2762,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7541); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2770,13 +2770,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8823); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -2784,7 +2784,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7100); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -2792,13 +2792,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8450); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2806,7 +2806,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7766); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2815,31 +2815,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8673); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=5; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=5; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -2847,7 +2847,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8648); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -2855,13 +2855,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8629); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -2869,7 +2869,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8829); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -2877,13 +2877,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8556); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -2891,7 +2891,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8463); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -2899,13 +2899,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8313); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -2913,7 +2913,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8498); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -2921,13 +2921,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8793); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -2935,7 +2935,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8909); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -2944,33 +2944,33 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8934); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=6; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -2978,7 +2978,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8669); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -2986,13 +2986,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8951); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -3000,7 +3000,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8729); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -3008,13 +3008,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 9424); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -3022,7 +3022,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8588); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -3030,13 +3030,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 9179); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -3044,7 +3044,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8654); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -3053,31 +3053,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 9826); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=7; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=7; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -3085,7 +3085,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7559); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -3093,13 +3093,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8751); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Haggar'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -3107,7 +3107,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7562); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -3115,13 +3115,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8834); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -3129,7 +3129,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7506); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -3138,31 +3138,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8918); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=8; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=8; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Haggar'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Haggar'), 0, @@ -3170,7 +3170,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5582); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Haggar'), 1, @@ -3178,13 +3178,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8826); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -3192,7 +3192,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5915); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 1,