begin; INSERT INTO tournaments (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 'Challenge Cup 4', (SELECT country FROM countries WHERE countryname='Norway'), 'Oslo Bowling', '2002-10-27', (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, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, (SELECT player FROM players WHERE nick='Tom'), 100); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, (SELECT player FROM players WHERE nick='Snute'), 90); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, (SELECT player FROM players WHERE nick='Oliyzia'), 81); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, (SELECT player FROM players WHERE nick='Daniil'), 73); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, (SELECT player FROM players WHERE nick='DufF'), 66); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, (SELECT player FROM players WHERE nick='kjmcw'), 60); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, (SELECT player FROM players WHERE nick='Draconia'), 55); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, (SELECT player FROM players WHERE nick='Slusk'), 51); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 9, (SELECT player FROM players WHERE nick='Yeye'), 48); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 10, (SELECT player FROM players WHERE nick='Telc'), 46); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 11, (SELECT player FROM players WHERE nick='ViD'), 45); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 12, (SELECT player FROM players WHERE nick='RiChY'), 44); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 13, (SELECT player FROM players WHERE nick='Snofox'), 43); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 14, (SELECT player FROM players WHERE nick='Matsi'), 42); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 15, (SELECT player FROM players WHERE nick='Havok'), 41); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lykkesopp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lykkesopp' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 16, (SELECT player FROM players WHERE nick='Lykkesopp'), 40); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 17, (SELECT player FROM players WHERE nick='Smiph'), 39); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Vampyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Vampyro' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 18, (SELECT player FROM players WHERE nick='Vampyro'), 38); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 19, (SELECT player FROM players WHERE nick='Pfxp'), 37); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 20, (SELECT player FROM players WHERE nick='Purity'), 36); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 21, (SELECT player FROM players WHERE nick='Mulefisk'), 35); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 22, (SELECT player FROM players WHERE nick='Magnar'), 34); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Electus' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 23, (SELECT player FROM players WHERE nick='Electus'), 33); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 24, (SELECT player FROM players WHERE nick='Advena'), 32); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'FantNo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'FantNo' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 25, (SELECT player FROM players WHERE nick='FantNo'), 31); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 26, (SELECT player FROM players WHERE nick='Indy'), 30); 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 27, (SELECT player FROM players WHERE nick='T|na'), 29); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ink' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 28, (SELECT player FROM players WHERE nick='Ink'), 28); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 29, (SELECT player FROM players WHERE nick='Lejordet'), 27); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Private Ryan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Private Ryan' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 30, (SELECT player FROM players WHERE nick='Private Ryan'), 26); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 31, (SELECT player FROM players WHERE nick='Spinnvill'), 25); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players ); INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 32, (SELECT player FROM players WHERE nick='Cyanid'), 24); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Private Ryan'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Private Ryan'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 4375); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Private Ryan'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 3021); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Private Ryan'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 't', 5087); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Advena'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Advena'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 4683); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Advena'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 3339); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Advena'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 5549); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Smiph'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 4578); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Smiph'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 3344); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Smiph'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 6223); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Havok'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Havok'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 7203); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Havok'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 5630); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Havok'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 't', 4005); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Tom'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 'f', 8222); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')), 'f', 6426); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 1, (SELECT player FROM players WHERE nick='Tom'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), 't', 8021); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 0, (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), 'f', 4981); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6119); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='ViD'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7714); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Electus'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Electus'), 0, (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), 'f', 4368); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Electus'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 5813); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Electus'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 6277); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 0, (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), 'f', 4703); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 6280); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='RiChY'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7609); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Lejordet'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Lejordet'), 0, (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), 'f', 3765); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Lejordet'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 5197); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Lejordet'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 0); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), 'f', 5437); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 'f', 7120); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 2, (SELECT player FROM players WHERE nick='Snute'), 2, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 7996); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 5218); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5654); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='FantNo'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 6812); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 6204); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5885); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Snofox'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7158); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Mulefisk'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Mulefisk'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 5680); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Mulefisk'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5471); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Mulefisk'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 6831); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='kjmcw'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='kjmcw'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 5968); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='kjmcw'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5746); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='kjmcw'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 7742); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Daniil'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Daniil'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 6677); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Daniil'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5663); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 3, (SELECT player FROM players WHERE nick='Daniil'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 6722); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='T|na'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='T|na'), 0, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 5497); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='T|na'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 'f', 6533); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='T|na'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 6567); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Magnar'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Magnar'), 0, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 6283); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Magnar'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 'f', 6144); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Magnar'), 2, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 't', 6716); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Vampyro'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Vampyro'), 0, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 6371); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Vampyro'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 'f', 5858); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Vampyro'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7630); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Yeye'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Yeye'), 0, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 6119); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Yeye'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 'f', 5799); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='Yeye'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7625); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='DufF'), 0, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 7047); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='DufF'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 'f', 6494); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 4, (SELECT player FROM players WHERE nick='DufF'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 't', 6830); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Pfxp'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Pfxp'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 5673); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Pfxp'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5537); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Pfxp'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7079); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Ink'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Ink'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 4015); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Ink'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 4863); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Ink'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6242); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Cyanid'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Cyanid'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 0); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Cyanid'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 1958); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Cyanid'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 1597); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Matsi'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Matsi'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 6119); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Matsi'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5965); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Matsi'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7077); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Slusk'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Slusk'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 6432); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Slusk'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5265); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Slusk'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7580); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 6791); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 6133); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 5, (SELECT player FROM players WHERE nick='Draconia'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6919); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=1; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Lykkesopp'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Lykkesopp'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 6916); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Lykkesopp'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6809); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Lykkesopp'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7459); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Indy'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Indy'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 4721); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Indy'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 5683); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Indy'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6575); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Spinnvill'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Spinnvill'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 4465); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Spinnvill'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 4167); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Spinnvill'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6554); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Purity'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Purity'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 4764); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Purity'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 6352); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Purity'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 6982); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Telc'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Telc'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 6809); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Telc'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7395); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Telc'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 6871); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 'f', 8090); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 'f', 7247); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 't', 7628); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5190); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 3795); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Smiph'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 5962); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Yeye'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Yeye'), 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5346); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Yeye'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 6453); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Yeye'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 7257); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5731); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 6274); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Snofox'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), 't', 6955); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5562); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 6207); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7205); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Draconia'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Draconia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 5925); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Draconia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 6147); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Draconia'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7368); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 'f', 7747); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 'f', 7524); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 1, (SELECT player FROM players WHERE nick='Tom'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Destiny')), 't', 6229); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 6069); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5648); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Daniil'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 7684); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5358); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5815); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='RiChY'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 6934); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Havok'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5262); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Havok'), 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5638); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Havok'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 't', 3360); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Vampyro'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Vampyro'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5244); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Vampyro'), 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 5233); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Vampyro'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 0); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 6040); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6057); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7848); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')), 'f', 5804); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')), 'f', 6013); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 2, (SELECT player FROM players WHERE nick='Oliyzia'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 7764); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')) ); UPDATE rounds SET randomsongs=2 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=2; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=2; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Matsi'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Matsi'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 6861); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Matsi'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 6804); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Matsi'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 6821); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Telc'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Telc'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 6738); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Telc'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 6529); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Telc'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7247); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Lykkesopp'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Lykkesopp'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 6144); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Lykkesopp'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 6956); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Lykkesopp'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 't', 5415); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Slusk'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Slusk'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 7081); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Slusk'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 6885); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Slusk'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 6800); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='kjmcw'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='kjmcw'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 7282); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='kjmcw'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 7330); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='kjmcw'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7266); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8141); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 'f', 8221); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 2, 3, (SELECT player FROM players WHERE nick='Snute'), 2, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 't', 6653); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=3; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=3; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Slusk'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Slusk'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5077); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Slusk'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7667); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Yeye'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Yeye'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5129); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Yeye'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 6442); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Daniil'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Daniil'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5588); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Daniil'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7420); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='kjmcw'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='kjmcw'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5806); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='kjmcw'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7431); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Draconia'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Draconia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5119); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Draconia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7657); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 5308); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7686); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Tom'), 7 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6088); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 7977); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 8 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6086); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8214); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 9 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')), 'f', 6058); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')), 't', 7956); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')) ); UPDATE rounds SET randomsongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=4; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=4; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Draconia'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Draconia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 5681); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Draconia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7525); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 6666); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7979); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Daniil'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Daniil'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 6317); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Daniil'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8333); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='kjmcw'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='kjmcw'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 5862); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='kjmcw'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 7385); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 6813); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 8165); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Tom'), 6 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 6940); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 7899); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')), 'f', 6626); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 7502); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=5; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=5; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 6570); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8317); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 7105); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8255); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Daniil'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Daniil'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 7174); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Daniil'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8253); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Tom'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 8324); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7359); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 5 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 'f', 6557); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8484); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')) ); UPDATE rounds SET randomsongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=6; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=6; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 'f', 7918); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8452); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 'f', 7340); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8058); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Daniil'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Daniil'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 'f', 6988); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Daniil'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8341); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Tom'), 4 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 'f', 7743); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 6, 0, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8761); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')) ); UPDATE rounds SET randomsongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=7; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=7; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6209); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 6875); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6382); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8354); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Tom'), 3 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')), 'f', 6356); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 7, 0, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8602); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=8; UPDATE rounds SET chosensongs=1 WHERE tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND round=8; INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), 'f', 5709); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8396); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 0, (SELECT player FROM players WHERE nick='Tom'), 2 ); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 0, (SELECT player FROM players WHERE nick='Tom'), 0, (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')), 'f', 5679); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), 8, 0, (SELECT player FROM players WHERE nick='Tom'), 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8556); commit;