X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc2-04.sql;fp=sql%2Fcc04%2Fcc2-04.sql;h=f0511c5798df63b323c4ff80d9c22e3b86818e32;hp=d1585b55138fd1e47995edb8566e41fd7cae7c0d;hb=69e91c419df45838d7c85633b10d0998f0f92f7a;hpb=9f7b3c1a46383496e6a30e0aad8d4252e1a94fda diff --git a/sql/cc04/cc2-04.sql b/sql/cc04/cc2-04.sql index d1585b5..f0511c5 100644 --- a/sql/cc04/cc2-04.sql +++ b/sql/cc04/cc2-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 2', (SELECT country FROM countries WHERE countryname='Norway'), 'Kino 1 Sandvika', @@ -9,128 +9,128 @@ 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, '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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, (SELECT player FROM players WHERE nick='OJK'), 100); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, (SELECT player FROM players WHERE nick='Snute'), 0); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, (SELECT player FROM players WHERE nick='DufF'), 0); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, (SELECT player FROM players WHERE nick='Snofox'), 73); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, (SELECT player FROM players WHERE nick='T|na'), 66); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, (SELECT player FROM players WHERE nick='RiChY'), 60); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, (SELECT player FROM players WHERE nick='Stream'), 55); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 8, (SELECT player FROM players WHERE nick='Olemann'), 51); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Raazu' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 9, (SELECT player FROM players WHERE nick='Raazu'), 48); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 10, (SELECT player FROM players WHERE nick='Ylini'), 46); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 11, (SELECT player FROM players WHERE nick='Smiph'), 45); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 12, (SELECT player FROM players WHERE nick='Havok'), 44); -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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 13, (SELECT player FROM players WHERE nick='Draconia'), 43); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dabi' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 14, (SELECT player FROM players WHERE nick='Dabi'), 42); -INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players ); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bush' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 15, (SELECT player FROM players WHERE nick='Bush'), 41); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Memories')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 0, @@ -138,7 +138,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4327); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 1, @@ -146,7 +146,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4251); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Bush'), 2, @@ -154,13 +154,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 5910); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 0, @@ -168,7 +168,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5476); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 1, @@ -176,7 +176,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6242); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Ylini'), 2, @@ -184,13 +184,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7977); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -198,7 +198,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6224); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -206,7 +206,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6659); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Stream'), 2, @@ -214,13 +214,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7572); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -228,7 +228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6530); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -236,7 +236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6702); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='T|na'), 2, @@ -244,13 +244,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7631); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -258,7 +258,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7561); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -266,7 +266,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7616); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 2, @@ -274,32 +274,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6839); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 0, @@ -307,7 +307,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3973); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 1, @@ -315,7 +315,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 3845); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Dabi'), 2, @@ -323,13 +323,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6484); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -337,7 +337,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7827); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -345,7 +345,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6329); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Olemann'), 2, @@ -353,13 +353,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8032); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 0, @@ -367,7 +367,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7830); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 1, @@ -375,7 +375,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6336); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 2, @@ -383,13 +383,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7544); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -397,7 +397,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8058); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -405,7 +405,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7672); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 2, @@ -413,13 +413,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8167); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -427,7 +427,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8651); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -435,7 +435,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8426); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 2, @@ -443,32 +443,32 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8392); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('D2R')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 0, @@ -476,7 +476,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5012); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 1, @@ -484,7 +484,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4014); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Raazu'), 2, @@ -492,13 +492,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 6940); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 0, @@ -506,7 +506,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5541); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 1, @@ -514,7 +514,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Draconia'), 2, @@ -522,13 +522,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7524); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 0, @@ -536,7 +536,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 4355); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 1, @@ -544,7 +544,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6284); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Havok'), 2, @@ -552,13 +552,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 4399); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -566,7 +566,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5953); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -574,7 +574,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8076); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 2, @@ -582,13 +582,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7735); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -596,7 +596,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6044); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -604,7 +604,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8303); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 2, @@ -613,31 +613,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8625); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Raazu'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Raazu'), 0, @@ -645,7 +645,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7286); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Raazu'), 1, @@ -653,13 +653,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7657); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -667,7 +667,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7814); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -675,13 +675,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7986); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 0, @@ -689,7 +689,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7747); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Olemann'), 1, @@ -697,13 +697,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7721); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -711,7 +711,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8215); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -719,13 +719,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8053); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Snofox'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -733,7 +733,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8529); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -741,13 +741,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8570); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='RiChY'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -755,7 +755,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8478); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -763,13 +763,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8174); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -777,7 +777,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8743); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -785,13 +785,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8447); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='OJK'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -799,7 +799,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8695); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -807,13 +807,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8440); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 9 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -821,7 +821,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8798); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 2, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -830,31 +830,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8500); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 0, @@ -862,7 +862,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7698); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Stream'), 1, @@ -870,13 +870,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 7874); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -884,7 +884,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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -892,13 +892,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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 0, @@ -906,7 +906,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8139); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='RiChY'), 1, @@ -914,13 +914,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8403); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -928,7 +928,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8661); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -936,13 +936,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8456); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -950,7 +950,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8272); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -958,13 +958,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8353); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -972,7 +972,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8783); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -980,13 +980,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8673); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -994,7 +994,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8633); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1003,31 +1003,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8584); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1035,7 +1035,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5706); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1043,13 +1043,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8583); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='T|na'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='T|na'), 0, @@ -1057,7 +1057,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5726); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='T|na'), 1, @@ -1065,13 +1065,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8056); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -1079,7 +1079,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5553); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -1087,13 +1087,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8525); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1101,7 +1101,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5822); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1109,13 +1109,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8460); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1123,7 +1123,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 5922); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1132,31 +1132,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8725); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), 0, @@ -1164,7 +1164,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6450); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), 1, @@ -1172,13 +1172,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8236); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1186,7 +1186,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6742); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1194,13 +1194,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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1208,7 +1208,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6605); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1216,13 +1216,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8534); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1230,7 +1230,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6689); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1239,31 +1239,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 8828); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND round=6; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1271,7 +1271,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7343); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 1, @@ -1279,13 +1279,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8871); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 0, @@ -1293,7 +1293,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 7152); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 1, @@ -1301,13 +1301,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8718); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1315,7 +1315,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 6908); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1324,31 +1324,31 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 9276); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' 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 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 0, @@ -1356,7 +1356,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8662); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1, @@ -1364,13 +1364,13 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 't', 8776); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='OJK'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='OJK'), 0, @@ -1378,7 +1378,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose 'f', 8676); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )), 7, 0, (SELECT player FROM players WHERE nick='OJK'), 1,